Question: DATABASE STAFF Table AID table POSITION Table PLAN Table 1. Identify primary key and foreign keys for each table and write none if dont have

DATABASE

STAFF Table

DATABASE STAFF Table AID table POSITION Table PLAN Table 1. Identify primary

AID table

key and foreign keys for each table and write none if dont

POSITION Table

have foreign key. 2. Illustrate Crow's Foot ERD to show relationships among

PLAN Table

STAFF,AID,POSITION and PLAN 3. Did the tables exhibit referential integrity? Explain answer.

1. Identify primary key and foreign keys for each table and write none if dont have foreign key.

2. Illustrate Crow's Foot ERD to show relationships among STAFF,AID,POSITION and PLAN

3. Did the tables exhibit referential integrity? Explain answer. Write none if table dont have foreign key

STAFF_NO 14 STAFF_NAME POSITION_CODE Zawawi 2 15 1 Maximus Amirul 16 1 17 Harris 3 20 Dexter 2 STAFF_NO PLAN_CODE 2 15 15 16 3 1 17 1 17 17 4 20 3 POSITION_CODE 1 POSITION_DESCRIPTION REGISTRAR SYSTEM ANALYST 2 3 CLERK PLAN_CODE 1 2 PLAN_DESCRIPTION MEDICAL STOCK PURCHASE UNIT TRUST DENTAL 4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Working on the Oracle APEX Sample Database Application, use the 4 database tables, shown below, to answer following questions. a . For each table, identify primary key and foreign key ( s ) . If a...

CSDA 5 2 4 0 Database Programming Week 1 Assignment Working on the Oracle APEX Sample Database Application, add a new customer ( yourself or make up one ) and, optionally, place an order on a few...

QUESTION 1 Discuss the importance of data models. (2 marks) QUESTION 2 Given a PILOT entity with the following attributes: PILOT_NUMBER. PILOT_ADDRESS. PILOT QUALIFICATION, PILOT DATE OF BIRTH...

Part 1 : Normalization 1 . Consider a table Alphabet ( A , B , C , D , E ) with the following functional dependencies: FD 1 : AB C FD 2 : AC B FD 3 : BC A FD 4 : D E a . Determine all the candidate...

database ! Project Description You have been asked to design a database for Healthway Hospital. Healthway depends on a large number of persons for its continued success. There are four groups of...

answer first two requirements in detail!!! solution to stage 2 below Kim's Flowers Revenue Cycle Assignment - Stage Three Due to the technical issue that prevented your access to the original...

1. Create a Crows Foot ERD for the following business rules. (35 pts) 2. QUESTIONS One publisher publishes many books and must publish at least one book. Each book must be published by one publisher....

Discuss the importance of data models. Given below is a database that records data about a music track. Table name: ARTIST ArtistID ArtistName ArtstLabour YearsActive 20010 Ernie Zakrie FMC Music...

you can create the screens in Part E using javaFx NP You are required to develop a simple database application for a small recruiting firm that wishes to keep track of all the employees at the firm;...

Indie sold the following securities during 2019: Date Acquired Date Sold Sales Price Basis A 6-30-2014 4-30-2019 $ 8,000 $12,000 B 7-12-2019 11-1-2019 $ 2,500 $ 5,000 C 8-20-2018 5-16-2019 $20,000...

Blue Water Yachts is a small company founded by two business people who are friends and avid sailors. At present, they are interested in expanding the business and have asked you to review its...

Loan proceeds are not directly tied to Group of answer choices sales revenue. expenses. meeting cash flow problems. planned expansion of a firm.

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

=+foreign language(s)? Who should take responsibility (headquarters personnel, host-country specialists, or third-party vendors) for translation? Should

=+e-learning in the MNE? Can training programs be developed in various locations and made available to everyone? What are the effects of the various options?

=+training programs be exported from headquarters or should overseas employees be brought to centralized or regional training facilities? How effective is