Create a relation database that maintains users- Database Management System
This assignment is to understand relational database and its fundamentals. It uses mysql community server and mysql workbench, which we discussed in the slides posted.
Problem 1: Use mysql community server and workbench to create a relation database that maintains users in the internet social media by following a standard process: schema -> tables -> records.
Define attributes of each user in the internet social media. It is your decision to include what kind of attributes on such users. You can think of users in we chat or in facebook.
At least two tables
At least 10 records under each table
Use at least two views inside workbench to query the database to get results by using two tables
To hand in, you need to write your design schema, tables and views. All are backed by showing screenshots your work
Problem 2: Use mysql community server and workbench to create another relation database that stores image, voice and video.
There are different ways to doing that. It is not easy. You can search internet for clues.
The challenging part is to design a schema that enables search on these multi-media contents
Create at least two tables
Stores at least 5 records on each (image, voice, video)
Develop at least two views inside workbench to query the database to get results by using two tables
To hand in, you need to write your design schema, tables and views. All are backed by showing screenshots your work
