User Account

All Pages

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

Database Management System Questions & Answers

  How would you do it and what changes would you make

Describe how you use the database, and how you think the database makes that process easier. In addition, if you could redesign the database you described, how would you do it and what changes would you make

  What is the significance of points a and b

Semantic Interoperability Gives IT Meaning - ?Please make sure its atleast half a page on Microsoft word and proper English. please explain in details What is the significance of points A and B?

  Identify the foreign key columns in the table structures

The problems below use the Customer, OrderTbl, and Employee tables of a simplified Order Entry database.

  Design an er diagram to capture the given requirements

Design an ER diagram to capture the requirements. State any assumptions you have that affects your design and three-level schema architecture for the Gyan Gurukul Company that provide better security also design a data abstraction for his client ka..

  Develop a domain model for the case study

The objective of the assignment is to apply and consolidate skills acquired in the requirement and analysis disciplines through analysis of a simple case study, and to express the results through the relevant UML diagrams.

  What are advantages of storing data in a dbms like access

Some people like to store their information in Excel files. What are the advantages of storing data in a database management system like Access over Excel? Name 3.

  Summarize the difference between on-line transaction

your database has been a hit. you have been called back to the customers headquarters and they want a detailed report

  Create a gantt chart illustrating the project tasks

Write clearly and concisely about Systems Analysis and Development topics using proper writing mechanics and technical style conventions.

  Drawing entities and relationship using crow-s foot notation

These following questions require to you to create entities and their relationship using the Crow's Foot notation suitably.

  Explain normalistion and data entry screen

Visualise the computer data entry screens that could be used to capture data for the following business events in Mike's business.

  Explain how you arrived at your final solution

Explain how you arrived at your final solution for the four conceptual and process view diagrams that you have created and describe how you created the conceptual and process view for all four (4) diagrams. In the description, be sure to provide a j..

  Background adventure works cycles the fictitious company on

background adventure works cycles the fictitious company on which the adventureworks sample databases are based is a

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd