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

  Insertion sort and merged using standard merging mechanism

Using "insertion sort" and then merged using standard merging mechanism, where k is value to be determined. How must be we select k in practice?

  Explain how to determine line in o-n lg n time

Explain how to determine such a line in O(n lg n) time. Provide the O(n^2 lg n)-time algorithm to pair Ghostbusters with ghosts in such a way that no streams cross.

  Write a brief explanation about abstract data types

Write a brief explanation about each topic and example or definition- Abstract Data Types and Abstraction and Data hiding

  Why internet need http

Discuss why does the Internet need HTTP, TCP, IP and DNS? Explain why is not the Internet Protocol enough to do the job? Please reply to these specific points of confusion.

  Describe purpose of queue in breadth-first traversal

Describe the purpose of queue in breadth-first traversal? Assume you had function call displayAtDepthN, which when given tree and depth would display only nodes at that depth.

  Analyzing network problem

Assume you are the Systems Analyst at a producing corporation in Seattle, WA. A Systems Analyst in your company's New York office sends you a trace file to examine.

  What is an algorithm

What is an algorithm? Find one on-line example of an algorithm (try to find one that solves any math problem), and repeat (retype and/or copy by taking a screen shot) that algorithm into your homework submittal

  Deleting a random element from an arraylist

In the archive, you will find the RandomQueue class, which implements the Queue interface in a way that, when we call remove()/poll(), a random element is removed from the queue. Currently, this is done by storing all the elements in an ArrayList ..

  Design algorithm to find the average miles per gallon

Design an algorithm to find the average miles per gallon. Sample data: 68723, 71289, 15.75, 16.30, 10.95, 20.65, 30.00.

  Systems analysis and design

What are the benefits of a thorough system requirements document? Drawbacks? How can a system requirements document be used to manage stakeholder expectations?

  Write algorithm that allows the customer to enter amount

An ATM allows a customer to withdraw a maximum of $500 per day. If a customer withdraws more than $300, the service charge is 4% of the amount over $300.

  Question about trigger

What are triggers used for, and why are they important in database systems? Give an example of a situation where a trigger would be appropriate.

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