Assignment on SQL
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
Attachment:- Assignment File.rar