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

  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.

  Define bc/nf normal form and third normal form

BC/NF Normal Form and Third Normal Form

  Discuss process you went through to select appropriate data

Discuss the process you went through to select the appropriate data types, primary and foreign keys, and other constraints that are necessary to maintain the integrity of the database.

  Quality control consists of testing and defect management

The current environment consists of Development (sized at about 30% of production), Disaster Recover /Operational Recovery servers, and Production servers. The business area consists of about 300 Wintel desktop and laptop computers. The VP of Tech..

  What tables and columns would you create in relational data

You need to store information on the business's employees, inventory, and completed sales. You also need to account for the fact that each salesperson receives a different percentage of their sales in commission. What tables and columns would you ..

  Demonstrate why a database was required in the first place

A narrative description of the field chosen for the application being created. This should also include a description of the problem and addressing the weaknesses to be solved by the database.

  Describe inventory application with keyboard events

(Inventory Application with Keyboard Events) Enhance the Inventory application that you developed in Tutorial 4 to prevent the user from entering input that is not a number. Use keyboard events to allow the user to press the number keys, the left and..

  Calculate individual consultants pay based on the tasks

Principles of database design, as demonstrated by the database design for project -  Designing and creating the following basic (master) tables for the application and "Employee" table, to hold the details of employees

  Identify key determinant that affect degree of normalization

Identify the key determinants that could affect the degree of normalization of a database. Justify your response. Next, identify the aspects of the database design that can be denormalized.

  Create all not null constraints as indicated in the erd

Create all NOT NULL constraints as indicated in the ERD. Create all PK constraints as indicated in the ERD. Create all FK constraints as indicated in the ERD.

  Discuss three different ways to create an oracle database

Discuss three different ways to create an Oracle Database. What are the advantages/disadvantages of each method. What is the difference between control files and redo logs. What is a datafile. What is a tablespace

  Compare different types of partitions-disks and volumes

You are tasked to design Windows 2008 servers to host a database and the company's Web application that will be used heavily by 1,000 employees. The goals are to minimize the downtime, provide the best possible performance for both the application..

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