Question: 7. Answer the questions below based on the following relational schemas : SCIENTIST (SCT ID, SCT_NAME, SCT_PHONENO, SCT_ADDR) EXPERIMENT(EXP NO, EXP_NAME, PROJ_CODE*) PROJECT (PROJ CODE,

7. Answer the questions below based on the following relational schemas : SCIENTIST (SCT ID, SCT_NAME, SCT_PHONENO, SCT_ADDR) EXPERIMENT(EXP NO, EXP_NAME, PROJ_CODE*) PROJECT (PROJ CODE, PROJ_NAME, PROJ_STARTDATE) SCIENTIST_EXPERIMENT (SCT_ID*, EXP NO*, DATE, TIME) a) Do the relational schemas above exhibit entity integrity? Answer YES or NO and then explain your answer: TABLE ENTITY INTEGRITY EXPLANATION SCIENTIST EXPERIMENT PROJECT SCIENTIST EXPERIMENT b) Do the relational schemas above exhibit referential integrity? Answer YES or NO and then explain your answer TABLE REFERENTIAL INTEGRITY EXPLANATION SCIENTIST EXPERIMENT PROJECT SCIENTIST EXPERIMENT

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 General Management Questions!

Alpha Mann Ltd makes and sells computer carry bags. Bill Blake, the company accountant, is responsible for preparing the company's annual budget. In compiling the budget data for next year, Blake has...

Esp 3 5 6 7 8 9 Answer the questions about the polygons below. Figure A Figure B Figure C Which figure is an octagon? O Figure A O Figure B O Figure C O None X 5 Which figure is a pentagon? Figure A...

QUESTIONS 1 to 7 ANSWER ALL QUESTIONS Ensure that your student number is written at the top of each submitted page. Indicate whether each of the following 7 statements is TRUE or FALSE by writing (or...

1. Answer both questions: a. A project currently generates sales of $10 million, variable costs equal to 50% of sales, and fixed costs of $2 million. The firm's tax rate is 35%. What are the effects...

I need help with creating a formula for Strata 3 and Strata 4 on the excel spreasheet. YouDriveOut: The conversation The scene: Executives at YouDriveOut, a chain of used car lots, are brainstorming...

What is a typical Price to Sales and Price to Earnings ratio for the firms in this industry? Base the conclusion on at least three pure-play competitors. Assuming that the valuation ratios will be...

10:48 PM Sun Jun 15 . 75% Assignment . . . Lab Activity 2: Report Lab Activity 2 - Projectile Motion.docx . . . SCIT 1420 Lab Manual Professors Mckey, Roed Lab Activity 2: Projectile Motion Objective...

Answer alll of the following questions. Things about contact and inflection questions. has to be answered with number line if needed and well explained. please answer it in a paper by writing it....

PLEASE ANSWER TO ALL MY QUESTIONS PLEASE AND THANK YOU ======================================================================== 1. What does it mean to say "Pet inherits from Dog"?...

The Manual Accounting Process Instructions for completing handout and quiz on D2L 1) Enter transactions to the appropriate journals (Sales, Purchases, Cash Receipts, Cash Disbursements or General...

all the following questions and show work. There should be three assignments (Three files) when completed. Tip will be added depending on grade achieved. Questions are listed below: Assignment 3:...

What was the worst experience you ever had with conflict? What was so bad about it? What are some of the things that caused the conflict? What are some suggestions you would have to mitigate or...

Suppose the model of Exercise 22 is replaced by the equations dx/dt = 0.4 x(1 - 0.000005x) - 0.002xy dy/dt = -0.2y + 0.000008xy (a) According to these equations, what happens to the insect population...

Lenders use your credit score to indicate your Creditworthiness Collateral Payment history Profitability

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...