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 does access identify each record within a database

How does Access identify each record within a database? What is the benefit for your data entry people by providing their data entries via combo boxes? What is the purpose of creating a lookup column in Access?

  Describe test environment and including hardware requirement

Describes the process of migrating existing data to the testing platform. Describe the test environment, including hardware requirements and the personnel who will participate in user acceptance testing.

  Create mock-up report to make the monthly claim

He wishes you to group data by insurance company number, with subtotals by company and grand totals for each numeric field.

  Build an entity relationship model for the above scenario

Draw a DFD (Context and Level 1) for placing an order based on the E-R diagram shown here.

  Part a - use cases perform a requirements analysis for the

part a - use cases perform a requirements analysis for the case study. express the results using the following

  Describe business rules that impact structure of database

Based on your research and / or common knowledge of a college and the information tracked by a college, describe the business rules that could impact the structure of the database.

  Perform data mining steps on the given dataset

You will perform data mining steps (data preprocesing, classification) on this dataset and write your results in a project report in the form of a IEEE conference paper.

  Encryption in ensuring confidentiality

Discuss the role of encryption in ensuring confidentiality; use a popular encryption to make your point if needed.

  Explain the level of normalization

Use Microsoft Access to create the keys and relationships between tables for the Huffman Trucking Driver Log.

  Design relational database using entity-relationship diagram

Design a Relational Database using Entity-Relationship Diagram (ER-D) and design a Relational Database by Mapping Entity-Relationship Diagram (ER-D) into Relational Models.

  Bonds and term structure1 graph the bond yield to maturity

bonds and term structure1. graph the bond yield to maturity ytm on the y-axis of an xy-scatter plot with the bond to

  Writing an application in assembly language

Suppose we have TEGRA, a multi-core mobile processor. While writing an application in assembly language for the given device, we have two options regarding code optimization.

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!

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