Problem1: Use mysql community server and workbench to create a relation database

Question

Problem1: Use mysql community server and workbench to create a relation database that maintains users in the internet social medai 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 wechat or in facebook

. • At least two tables • At least 10 records under each tables

• 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

Problem 3:
Develop a web based application to retrieve multi-media that created in the last assignment
•   A image can be retrieved
•   A voice can be retrieved and played
•   A video can be retrieved and played

Include screen shots and a short write up to explain

Explanation / Answer

problem 3

Image Retrieval Procedure:

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.