User Account

All Pages

Dependency diagram reflects a table that is in

Assignment Help Data Structure & Algorithms
Reference no: EM13854370

1. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined


2. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined


3. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined


4. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined


5. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined


Questions 6 - 9

The dependency diagram indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book.

Book royalty dependency diagram

6. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. No Normal Form

7. What are the Partial Dependencies (more than one may apply)?
a. ISBN -> BookTitle
b. ISBN -> Author_Num
c. ISBN -> LastName
d. ISBN - > Publisher
e. ISBN -> Royalty
f. ISBN -> Edition
g. BookTitle -> Author_Num
h. BookTitle -> LastName
i. BookTitle -> Publisher
j. BookTitle -> Royalty
k. BookTitle -> Edition
l. Author_Num -> LastName
m. Author_Num -> Publisher
n. Author_Num -> Royalty
o. Author_Num -> Edition

8. What are the Transitive Dependencies (more than one may apply)?
a. ISBN -> BookTitle
b. ISBN -> Author_Num
c. ISBN -> LastName
d. ISBN - > Publisher
e. ISBN -> Royalty
f. ISBN -> Edition
g. BookTitle -> Author_Num
h. BookTitle -> LastName
i. BookTitle - > Publisher
j. BookTitle -> Royalty
k. BookTitle -> Edition
l. Author_Num -> LastName
m. Author_Num -> Publisher
n. Author_Num -> Royalty
o. Author_Num -> Edition

9. How many tables would be required to make this complete ERD 3NF?
a. 2 Tables
b. 3 Tables
c. 4 Tables
d. 5 Tables

Questions 10 - 12

For the two tables in the ERD below, view the dependency diagrams below the ERD.

Business Rule: A doctor can schedule many appointments, but an appointment is scheduled by one and only one doctor. The "APPOINTMENT" table includes the App_Num, as well as the doctors Emp_ID, the appointment time, date, Patient_ID, and patient information.
Note that in the "APPOINTMENT" table, the attribute "App_PatientID" is a patients ID number, and can be used to uniquely identify all other patient attributes, including App_Name to App_Zip.

10. The "Doctor" dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined

11. The "Appointment" dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined

12. How many tables would be required to make this complete ERD 3NF?
a. 2 Tables
b. 3 Tables
c. 4 Tables
d. 5 Tables


Attachment:- Chapter 6 Exercise 1 (1) (1).pdf

Reference no: EM13854370

Questions Cloud

Prime brokerage customers for use as working capital : Prime brokerage accounts were moved from Bear Stearns during the week of 2010. This was part of the run. These accounts were closed so Bear no longer had access to the funds deposited by their prime brokerage customers for use as working capital. tru..
Calculate how many days are needed to complete an activity : Calculate how many days per week are needed to complete an activity. Duration may also be calculated in hours for a more accurate picture.
Drafts of the external and internal environmental analysis : Identify one important concept, research finding, theory, or idea in strategy that you learned while completing this weeks work. Why do you believe that this concept, research finding, theory, or idea in strategy is important
What was the firm''s 2012 operating cash flow, or ocf : The 2011 balance sheet of Anna's Tennis Shop, Inc., showed long-term debt of $5.5 million, and the 2012 balance sheet showed long-term debt of $5.75 million. The 2012 income statement showed an interest expense of $180,000. The 2011 balance sheet of ..
Dependency diagram reflects a table that is in : dependency diagram reflects a table that is in
Exxon is evaluating an oil well : Question 2:Exxon is evaluating an oil well that will produce oil for two years. In year 1, the company plans to produce 100,000 barrels of oil, and the production cost will be $20 per barrel. In year 2, it plans to produce 50,000 barrels of oil, but ..
Drafts of the strategic choice and evaluation paper : Identify one important concept, research finding, theory, or idea in strategy that you learned while completing this weeks work
Draft your performance canvas : Draft your performance canvas and submit it to the assignment folder and post it as a response in a new message. You will use this canvas as a personal tool as we progress through the class.
How they will fundamentally work in today economy : According to the article please describe the new paradigm of what an artist is and how they will fundamentally work in today's economy. Has the perception of an artist by others changed? for better? for worse? (your judgment) - please explain your p..

Reviews

Write a Review

Data Structure & Algorithms Questions & Answers

  Create algorithm to perform any sequence of two operations

Let A[1, n] be an array of real numbers. Create an algorithm to perform any sequence of the following two operations: Add(i, x): add the value x to A[i].

  How to work on datasturetur assignment how to work on

how to work on datasturetur assignment how to work on datasturetur assignment how to work on datasturetur

  Compiler to separate the numbers using dashes

write this code using structures.with writing the SSN in one line this ask the compiler to seperate the numbers using dashes.

  Refresh address counter

A microcomputer memory is built from 64K X 1 DRAM, with DRAM cell array organized into 256 rows. Each row requires being refreshed at least once every four ms, strictly on a periodic basis.

  Write a xml schema for the validation of the document notes.

write a XML schema for the validation of the document notes.xml. Write the schema according to the following three approaches;1.- Based on the document structure2.- Structured (bottom-up design)3.- Type-based (top-down design)

  Comparison of the applicability of array

Data structures include: 1. a linked list, 2. an ordered, one dimensional array, and three. a binary tree. Assume the list of letters R, A, N, B, C, F, X and G are stored in a list.

  The time delay of a long-distance

The time delay of a long-distance call can be determined by multiplying a small fixed constant by the number of communication links on the telephone network between the caller and callee

  What are entity-relationship diagrams

What are entity-relationship diagrams, and how are they used? Discuss the ethical issues to consider when planning a database.

  Interchange contents of working registers

Make a stack at 1000h and use the stack to interchange the contents of all of working registers. Exchange AX with DX, BX with CX, and DI with SI.

  Submit your programs by email the program should have as

submit your programs by email. the program should have as many comments as necessary. the top comments should explain

  Questionneural and tree learning on continuous attributesa

questionneural and tree learning on continuous attributesa in general feedforward neural networks multi-layer

  Explain why the tower of hanoi puzzle is an example of a

the tower of hanoi puzzle is a popular diversion which you may have encountered before.nbsp we are interested in this

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd