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

Assignmentconsider the employee database with the following

Assignment Consider the employee database with the following list of tables. Please create these tables with appropriate primary keys & foreign keys. The list of tables is: Company(cid, company_name, city, state) /* city ...

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

Suppose that you are the database developer for a local

Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training s ...

Taskoverview of business casealive amp boating aampb is a

Task Overview of business case: Alive & Boating (A&B) is a small start­up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the availa ...

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

Projectfalcor supplies is a distributor of high tech

Project Falcor Supplies is a distributor of high tech teaching equipment. Its primary target customers are schools in the region who purchase the teaching equipment for classrooms and online use. The company's main compe ...

Assignment1write a query that retrieves studentlastname

Assignment 1. Write a query that retrieves student.last_name, student.first_name and total number of enrollments from the student and enrollment tables. Your query should also include students that do not have any enroll ...

Consider a typical sales invoice that would include the

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to re ...

Assignment business rules and data modelssuppose a local

Assignment: Business Rules and Data Models Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and cour ...

Relational databases with ms access1 create a table

Relational Databases with MS Access 1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run 2) Your code (for the button) will dynamically read the caption from the table and assign it t ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro