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)

One to one relation

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