Assignment - 1 - redoing to improve grades, Database Management System

Assignment Help:
Assignment #1
Data Management

The questions on this exam are based on the Baxter Aviation case scenario.

1. (5 points) The systems analyst proposes the following two relationships between the Flight and Pilot entities:



What question do you need to answer to decide which of the relationships is correct? (Hint:The answer requires only one sentence.)

2. A part of the initial ER diagram for the Baxter Aviation database appears as follows:






(a) (5 points) State in words the meaning of this relationship.

(b) (5 points) Why can’t this relationship be represented directly in a relational database?

(c) (5 points) Redraw the diagram so that it is compatible with the design of a relational database.

3. (10 points) Assume that you have been presented with the following relation for the Baxter Aviation database:

Charters (Pilot#, Pilot name, Aircraft ID#, #seats, Village, Flight#, Flight date, Flight time, Customer#, Customer name)

(a) How many entities are represented by this relation?

(b) What is the primary key of this relation? (Hint: Flight# is unique; flight numbers do not repeat as they do on commercial airlines with regularly scheduled flights. Each flight can go to many villages and over time a village can receive many flights.)


(c) Give a specific example of one insertion anomaly present in this relation.

(d) Give a specific example of one deletion anomaly present in this relation.

(e) Is this relation in first, second, or third normal form? Why?


4. A portion of the Baxter Aviation database is as follows:

Aircraft (Aircraft ID #, Make, Model, #seats, total airtime, hours on engine)
Village (Village name, Type of runway)
Flight (Flight time, Flight date, Aircraft ID#, Flight#, Customer #)
Destinations (Flight#, Village name)
Customers (Customer name, House number, Phone, Customer #)


(a) (5 points) Identify the primary key for each relation.

(b) (5 points) Identify all foreign keys and the primary keys they reference.

(c) (10 points) List all the constraints that must be verified whenever a row is inserted into the Flight relation. (In other words, what are the specific integrity checks that must be made?) In your list, indicate exactly which attributes are being checked and the specific test(s) being performed on each. (hint: Here’s a partial example: The database needs to validate that the primary key of the relation is unique.)

Related Discussions:- Assignment - 1 - redoing to improve grades

Economics, Economics: It is now usually accepted that it costs less to make...

Economics: It is now usually accepted that it costs less to make a system of smaller computers with the equivalent power of a one large computer. It is more cost-effective to get s

Create a company database, Company Database: a-)Here is the ER Model ...

Company Database: a-)Here is the ER Model b-)Here is the Relational Model:     IMPORTANT NOTICE FOR SOLUTION TYPE: ***THIS ASSIGNMENT WILL BE SOLVED BY THE

DW, #ques Define a job scheduling strategy that will meet business requirem...

#ques Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a p

Information Technology, What benefits can a company gain by managing its ow...

What benefits can a company gain by managing its own information infrastructure and servicea

What is log shipping, What is Log Shipping? Log shipping is the method ...

What is Log Shipping? Log shipping is the method of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a stand

Explain projection operation distribute over union operation, Illustrate th...

Illustrate the statement 'Projection operation distributes over the union operation'. Give an example.    Ans: Π L (E 1 ∪ E 2 ) = (Π L (E 1 )) ∪ (Π L (E 2 ))   This says th

Explain generalization and aggregation in e_r diagram, Explain the concept ...

Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug

Functional dependency, Functional Dependency Consider a relation R that...

Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every

What are data models, What are data models? Explain it detail? Entity ...

What are data models? Explain it detail? Entity relationship model Rectangles Ellipse Diamonds Lines Relational model Relational model use a collection

Write Your Message!

Captcha
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