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