ZuoTi.Pro
Question

Assume that you have the following table: (BusRouteID, Date, BusLineNumber,BusLineName, BusID, DriverID, DriverName, DriverDOB, BusPurchaseDate, StopID,...

Assume that you have the following table: (BusRouteID, Date, BusLineNumber,BusLineName, BusID, DriverID, DriverName, DriverDOB, BusPurchaseDate, StopID, StopName, ArrivalTime, DepartureTime)Assume that the following functional dependencies beyond that of the primary key are valid:

BusRouteID →BusLineNumber, BusLineName

StopID→StopName

BusLineNumber →BusLineName

DriverID →DriverName, DriverDOB

BusID →BusPurchaseDate

BusRouteID, Date →BusID, DriverID

Convert the table into 3NF.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Please upvote thanks

0 0
Add a comment
Know the answer?
Add Answer to:
Assume that you have the following table: (BusRouteID, Date, BusLineNumber,BusLineName, BusID, DriverID, DriverName, DriverDOB, BusPurchaseDate, StopID,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Consider the following relation R, where {A, B} is its PK. Assume that R is in...

    Consider the following relation R, where {A, B} is its PK. Assume that R is in the first normal form (INF). R (A, B, C, D, E, F) Functional dependencies: FD1: BàC FD2: AàDE FD3: ABàF Why is this table not in 2NF? Specify which FDs make R violate 2NF. Normalize the data shown in this table to second normal form (2NF). Specify the primary and foreign key (if any) in each table of your 3NF relations. Normalize the data...

  • R = {Q1,Q2,Q3,Q4,Q5,Q6,Q7,Q8,Q9,QJ} Given these functional dependencies: {Q5,Q6} > {Q7} {Q5} &...

    R = {Q1,Q2,Q3,Q4,Q5,Q6,Q7,Q8,Q9,QJ} Given these functional dependencies: {Q5,Q6} > {Q7} {Q5} > {Q8,Q9} {Q6} >  {QJ} {QJ} >  {Q1, Q2} {Q8} >  {Q3, Q4} {Q3} > {Q7, Q1, Q2, Q5, Q6} a. Identify 2 primary keys to this table b. Assuming it is in 1NF, explain why it is not in 2NF.Make the required adjustments to convert table to 2NF.Show primary key of each table c. Assuming it is in 1NF, explain why your 2NF table is not in 3NF....

  • You have a table R1 with five fields A, b, C, P and S. You have...

    You have a table R1 with five fields A, b, C, P and S. You have the following functional dependencies(this set is not complete, but it allows you to compute all the missing ones that you will need): B -> A P -> C B, P -> A, C, S 1. What is the only choice for the primary key of this table? Why? 2. Give one normal form that the table does not satisfy, explain why. 3. Modify the...

  • Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date,...

    Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date, contractor, contractNo) Some notes on the semantics of attributes are as follows: • Each project has a unique project ID (projID) and also has a title, type and manager. Each manager has a specialty project type. • A project often contracts jobs to contractors with start-date and end-date. Contracts are identified by contract numbers (contractNo), but contract details are out of the scope of...

  • 2. The following is the relation notation of a table for a veterinary office. [70 pts....

    2. The following is the relation notation of a table for a veterinary office. [70 pts. total] VETERINARY_OFFICE (PetID, PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName, ServiceDescription, ServiceDate, ServiceCharge) The functional dependencies are given below: PetID -> PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName OwnerID -> OwnerLastName, OwnerFirstName ServiceDescription -> ServiceCharge PetID, ServiceDate > ServiceDescription, ServiceCharge Assumptions: 1)A pet belongs to only one owner, 2) an owner may have more than one pet, 3A pet receives at most one treatment on any...

  • Consider the relational schemas given below and the respective sets of functional dependencies va...

    Write the complete proof. Consider the relational schemas given below and the respective sets of functional dependencies valid in the schemas For each one of the relational schemas, determine the highest normal form, which is valid for a schema. Justify your answer If a schema is not in BCNF, then decompose it into a minimum number of schemas so that each one of them is in BCNF. Justify your answers. Justification must include the derivations of minimal keys from the...

  • PART A: The schema for the Jefferson Dance Company is shown below. CUSTOMER (CUSTID, NAME, ZIP,...

    PART A: The schema for the Jefferson Dance Company is shown below. CUSTOMER (CUSTID, NAME, ZIP, BALANCE) DANCESTEP (STEPID, NAME) GLESSONS_TAKEN (GLESSONID, CUSTID) GROUP_LESSON (GLESSONID, INSTID, FEE, DATE, TIME, STEPID) INSTRUCTOR (INSTID, NAME, ZIP) MASTERED_STEPS (INSTID, STEPID) PRIVATE_LESSON (PLESSONID, CUSTID, INSTID, FEE, DATE, TIME, STEPID) Normalize this database using the following example for the CUSTOMER table as a guide.             Table: CUSTOMER (CUSTID, NAME, ZIP, BALANCE)             Functional Dependencies:                         CUSTID ® NAME, ZIP, BALANCE             Key: CUSTID Description                                                                                  YES           ...

  • MySQL: Consider the following abstract relational schema: (A, B, C, D, E, F) Now assume the...

    MySQL: Consider the following abstract relational schema: (A, B, C, D, E, F) Now assume the following functional dependencies: A -> B, C, D, E, F C -> B Note: This implies that A is a key. Is this database in 1NF, 2NF, 3NF, or BCNF? Why?

  • a. Design a simple database with at least 5 relations for such applications as “students taking...

    a. Design a simple database with at least 5 relations for such applications as “students taking courses taught by faculty in class rooms at a specific time” b. Is the relation R in 3NF? Explain your answer using functional dependencies. c. If your R above is in 3NF, create at least one table from your database that is not in 3NF. If your R is not in 3NF, decompose R into 3NF relations. In each case, you are required to...

  • The following is the relation notation of the Veterinary Office List. VETERINARY_OFFICE (PetID, PetName, PetType, PetBreed,...

    The following is the relation notation of the Veterinary Office List. VETERINARY_OFFICE (PetID, PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName, ServiceDescription, ServiceDate, ServiceCharge) The functional dependencies are given below: PetID -> PetName, PetType, PetBreed, OwnerID, OwnerLastName, OwnerFirstName OwnerID -> OwnerLastName, OwnerFirstName ServiceDescription -> ServiceCharge PetID, ServiceDate -> ServicedDescription, ServiceCharge Assumption: A pet belongs to only one owner, while an owner may have more than one pet. A pet receives at most one treatment on any given date. Use the functional dependencies...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT