Create a relation database that maintains users

Assignment Help Database Management System

Reference no: EM131400786

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

Reference no: EM131400786

Questions Cloud

What would large values in positions a and d tell you : Does there appear to be strong association between hand dominance and eye dominance?- What would large values in positions b and c tell you?

Write on department of state intrusion : Write on Department of State intrusion. Describe mission of each organization, as found on their web site. How each organization has been targeted in the recent past for cyberattack(s), as reported in news or journal articles.

Define the short-run break-even price : Define the short-run break-even price. What are economic profits at this price? Why would a firm be willing to operate permanently at this price?

Does aspirin really help prevent heart attacks : Would you be concerned about the results for aspirin having been unduly influenced by the fact that most of the aspirin-takers were also nonsmokers? Explain.

Create a relation database that maintains users : 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

Appropriate for explaining decisions made by entrepreneurs : What is the difference between accounting profits and economic profits? Which of the two concepts is more appropriate for explaining decisions made by entrepreneurs? Explain.

Describe what you believe to be the best tv commercial : During the last year, you have been exposed to a number of television advertisements. Identify and describe what you believe to be the best TV commercial that you have experienced over the last year. Why do you feel that this ad is the very best?

Critique merits of major services found on the dms website : Critique the merits of the major services found on the DMS Website. Analyze the security mechanisms needed to protect the DMS systems from both state employees and users accessing over the Internet.

Exchanging excess phones for textiles : Assume that the production of one unit of cell phones in the US requires 20 units of resources, while the production of one unit of textiles uses 10 units of resources. Also assume the world price is 1 unit of cell phones = 4 units of textiles Ple..

Reviews

len1400786

2/20/2017 2:38:11 AM

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. For those in onsite class, each team needs prepare a 3 minutes demo in front of the class. Bring the device to show the result.

Write a Review

Required(*) Message

User Account

All Pages