100 points
Please type your answers on this document and submit this document.
1. Suppose that you are using the Database composed of the two tables shown in the following
figure. Use these tables to answer part A,B,C (40 points)
Theater Database Tables
Table name: DIRECTOR
Table name: PLAY
A. Identify the primary keys for each table. ( 15 points )
DIR_NUM, PLAY_CODE
B. Identify the foreign key. ( 15 points )
DIR_NUM
C. What is the relationship between these 2 tables? (10 points)
2. Use the following Tables to answer questions A-C . ( 60 Total points )
PRODUCT and vendor Database Tables
Table name: PRODUCT
Table name: VENDOR
A. For each table, identify the primary key and the foreign key(s). If a table does
not have a foreign key, write None in the assigned space. ( 20 points )
TABLE |
PRIMARY KEY |
FOREIGN KEY(S) |
PRODUCT
|
|
|
VENDOR |
|
|
B. Do the tables exhibit entity integrity? Answer Yes or No, and then explain
your answer. ( 20 points )
TABLE |
ENTITY INTEGRITY? Type Yes or No here |
EXPLANATION Explain the reason here |
PRODUCT |
|
|
VENDOR |
|
|
C. Do the tables exhibit referential integrity? Answer Yes or No, and then explain
your answer. Write NA (Not Applicable) if the table does not have a foreign
key. ( 20 points )
TABLE |
REFERENTIAL INTEGRITY |
EXPLANATION |
PRODUCT |
|
|
VENDOR |
|
|
1
NURS 6002: Foundations of Graduate Study
Academic and Professional Success Plan Template
Prepared by:
<INSERT NAME>
Week 6 | Part 6: Finalizing the Plan
I have considered various options for my nursing specialty, including a close look at my selected (or currently preferred) specialty and second-preferred specialty. I have also developed a justification of my selected (or preferred) specialty. Lastly, I have examined one professional organization related to my selected or preferred specialty and considered how I can become a member of this organization.
The results of my efforts are below.
Directions: Complete Step 1 by writing 2-3 paragraphs in the space below comparing the nursing specialty you have selected – or the one you prefer if your choice is still under consideration - to your second preference. Identify each specialty and describe the focus and the role that graduates are prepared for. Identify any other differentiators you feel are significant, especially those that helped or may help you reach a decision.
Complete Step 2 by writing a paragraph identifying and justifying your reasons for choosing your MSN specialization. Be sure to incorporate any feedback you received from colleagues in this week’s Discussion Forum.
Complete Step 3 by examining and identifying one professional organization related to your selected or preferred specialty. Explain how you can become a member of this organization.
Remember to include an introduction paragraph which contains a clear and comprehensive purpose statement which delineates all required criteria, and end the assignment Part with a conclusion paragraph.
Step 1: Comparison of Nursing Specialties
Step 2: Justification of Nursing Specialty
Step 3: Professional Organizations
- END -
Academic and Professional Success Plan Template
Prepared by:
<INSERT NAME>
NURS 6
00
2
:
Foundations of
Graduate Study
Academic and Professional Success Plan Template
Prepared by:
<INSERT NAME>
NURS 6002: Foundations of
Graduate Study

Get help from top-rated tutors in any subject.
Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com