Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the following ERD, which maps courses to prerequisites. Answer questions COURSE CRS ID VARCHAR(8) PK DEPT-CODE VARCHAR(12) FK CRS_DESCRIPTION VARCHAR(64) CRS_CREDIT FLOAT PREREQ
Refer to the following ERD, which maps courses to prerequisites. Answer questions COURSE CRS ID VARCHAR(8) PK DEPT-CODE VARCHAR(12) FK CRS_DESCRIPTION VARCHAR(64) CRS_CREDIT FLOAT PREREQ CRS_ ID VARCHAR(8) PK FK1 PREREQ-ID VARCHAR(8) PKFK2 tt (TI I F) PREREQ s a weak entity. (T II F)The relationship COURSE:PREREQ is weak. (TII F)All prerequisite courses (crscode) in PREREQ, must link with a valid course in COURSE. (T II F)The foreign key in PREREQ is a composite key (CRS ID, PREREQ ID). (T II F)Upon implementation, table indexes are automatically generated for both tables. What does it mean to say that a database displays both entity integrity and referential integrity? How are each established
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started