Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Assignment: Data Management

The problems are based on the Baxter Aviation case scenario.

problem 1: The systems analyst proposes the following two relationships between the Flight and Pilot entities: What problem do you need to answer to decide which of the relationships is correct?

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

a) State in words the meaning of this relationship.
b) Why can't this relationship be represented directly in a relational database?
c) Redraw the diagram so that it is compatible with the design of a relational database.

problem 3: 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?
c) Give a specific ex of one insertion anomaly present in this relation.
d) Give a specific ex of one deletion anomaly present in this relation.
e) Is this relation in first, second, or third normal form? Why?

problem 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) Identify the primary key for each relation.

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

c) 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.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M9782

Have any Question? 


Related Questions in DBMS

Assessment item 1taskthe fermoy house databasethe owners of

Assessment Item 1: Task The Fermoy House database The owners of Fermoy House, a Bed and Breakfast guest house in the Blue Mountains of NSW, have approached you to build them a database to help them run their business. Fe ...

Database design and use group assignmentassignment

Database Design and Use Group Assignment Assignment Description - In this assignment you will use your normalized "City Jail" database you have created in your assignment one. You will form a group (2-3 students) and imp ...

Overviewfor this assignment you will implement and query a

Overview For this assignment you will implement and query a database from a supplied ER Diagram and Schema. You will be required to write the SQL statements to create the database structures, to fill the database with da ...

Database management systems assignment-overview-for this

Database Management Systems Assignment- Overview- For this assignment you will implement and query a database from a supplied ER Diagram and Schema.  You will be required to write the SQL statements to create the databas ...

1 objective named entity recognitionin this project you

1. Objective: Named Entity Recognition In this project, you will use scikit-learn and python 3 to engineer an effective clas- sifier for an important Information Extraction task called Named Entity Recognition. 2. Gettin ...

Questionwrite a 2 to 3 page essay describing the use of an

Question: Write a 2 to 3 page essay describing the use of an OLAP Data Cube. Your essay should also describe the operations of Drill Down, Roll Up, Slice, and Dice. Video: What is Business Intelligence and an OLAP Cube? ...

Design a relational database for a video rental store the

Design a relational database for a video rental store. The store, which rents only DVDs and has no sales other than DVD rentals, has approximately 5,000 customers and approximately 1,200 DVD titles. There are 25 supplier ...

In general my report talks about the database management

In general, my report talks about the Database management system. But I want to a specific topics of it in 3 pages. The topics are: 1. Comparison between File approach and Database approach. 2. Advantages and disadvantag ...

Part aexercise 1 data scienceread the article at

Part A Exercise 1: Data Science Read the article at http://datascience.berkeley.edu/about/what-is-data-science/ and answer the following: What is Data Science? According to IBM estimation, what is the percent of the data ...

Coit20247 database design and development assignmentyou

COIT20247 Database Design and Development Assignment You must use that sample solution of assignment only for the following tasks: Assessment task- 1. Normalization a) Map the ERD, from the sample solution, into a set of ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate