Explain the role of primary and foreign keys in databases

Assignment Help Database Management System
Reference no: EM131258013

Database Systems for Website Applications Assignment:

In this assignment, you will review the below schema then answer the three questions listed afterwards.

Assume and review the following Internet movie database schema:

Database:

Table: movie
id - int, primary key

title - char

year - int

rating - float
Table: person
id - int, primary key

name - char

sex - char

age - int
Table: role
personid - foreign key references person - int

movieid - foreign key references movie -- int

character - char

Based on your review of the Internet movie database schema above, respond to the following:

• Explain the role of primary and foreign keys in databases. Explain why we need them and whether we can extract information from tables without having primary or foreign keys.

• Write and execute a SQL for each of the following scenarios:

o An SQL with a nested subquery.
o A select query that uses GROUP BY
o A select query that uses ORDER BY
o A select query that uses Inner JOIN
o A select query that uses an Outer JOIN
o A select query that uses UNION
o A select query that uses EXCEPT

• Make sure you give a screenshot of the output from executing your queries.

Reference no: EM131258013

Find the average size of the airports in california

Find the average size of the airports in California that have been open since 1935. Describe the four steps in the transfer of data from disk to primary memory. Describe how a

Identified in the system analysis report

An E-R diagram of your database that clearly shows the primary and foreign keys - Database has minimum number of records in each table as specified in assignment instructions.

Create trend-moving averages with the given values form

Create trend-moving averages with the following values form: 10, 100, and 200. Graph the data with Excel. Create centered-moving averages with the following values form: 10, 1

Explain what is the purpose of database

Explain what is the purpose of Database? The purpose of a database is to store information about certain types of objects. Give an example of two related TABLES.

How to use traditional database design method

Explain how you would follow three phases of traditional database design method (Hierarchical, Network, and Relational), considering the following scenario.

List the relational notation for each normal form

List the relational notation for each normal form (e.g. Invoice (abc, def, ghi): When your done creating the ERD in Visio submit your completed Visio file to me for grading

Discuss business analytics and data mining tools

Explain Business Intelligence in three to four paragraphs. Focus upon what it is, its architecture and purpose - Discuss business analytics and data mining tools including the

Write names-e-mail addresses for all customers from table

Show all the data in each of the four tables. Do not show foreign key columns. Write names and e-mail addresses for all customers who have had a stove repair that cost more t

Reviews

Write a Review

 
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