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

Serialisability, Serialisability: Any schedule that makes the similar resul...

Serialisability: Any schedule that makes the similar results as a serial schedule is known as a serialisable schedule. But how can a schedule are determined to be serialisable or n

Display how records can be deleted and updated in qbe, With the help of an ...

With the help of an example display how records can be deleted and updated in QBE. (i) Increase Pay_Rate of employees along with the skill of ‘cook' by 10%. (ii) Delete employee

Computer, what is object-identity

what is object-identity

Advantages of database systems, Problem 1. Describe the following a)...

Problem 1. Describe the following a) Advantages of Database Systems b) Functions of a DBMS Explanation of part (a) and (b) 2. Explain the following concepts w

What is a name, What is a Name? A user-supplied name is used for identi...

What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it

What is a hash index, What is a hash index? A hash index organizes the ...

What is a hash index? A hash index organizes the search keys, with their associated pointers, into a hash file structure.

Explain the query processing, Explain the Query Processing  Data Query ...

Explain the Query Processing  Data Query Processing permits a user to report or analyze structured and unstructured data pulled from multiple data sources.

Explain sequential file organization, Question 1 What do you mean by datab...

Question 1 What do you mean by database management system? Question 2 Write a note on Object-Oriented Model Question 3 Explain Sequential File Organization Question

Process-oriented decompositions, Process-oriented decompositions Pr...

Process-oriented decompositions Process-oriented decompositions divide complex process, task or function into simpler sub processes until they get simple enough to be deal

What are the object-oriented approaches, What are the object-oriented appro...

What are the object-oriented approaches Software systems which are designed with structured design methodology never support some of desired quality attributes for example reus

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