There are 4 constraint types, Entity, Referential, Column, and User Defined. Ide
ID: 3601150 • Letter: T
Question
There are 4 constraint types, Entity, Referential, Column, and User Defined. Identify and describe 5 constraints - provide variety.
CONFERENCE ld (Pw) Description specifie by PARTICIPANT TEAM GAME SCHOOL (PKI plays as / played by Teamld (PFK)plays in /played by Stadiumld (PFK) id Stadiumld (PFK) Date HomeTeam Scorc (PK) PK) (PFK) specifies specified by Conferenceld (FK) Schoolid(FK) TickctPrice Attendance Description location of hold in omployoin omployed by holds /held by Coachld (PFK) StartingDate (PK) COACH ld (PK) Name SSN STADIUM ld (PK) JOB TITLE ld (FK) Teamld (FK) City Stato Capacity Description types typed by PITCHER member of consists of Playerld (PFKlys as is Preference PLAYER ld SSN (PK) OUTFIELDER Playerld (PEKPlays as Preference Errors Wcight Classificationid (FK) Typeld Teamld (FK) (FK) OTHER Playerld (PFK Preference Comment plays as / is PLAYER TYPE ld types /typed by (PK) Description PLAYER CLASSIFICATIOclassifies classified by ld (PK) DescriptionExplanation / Answer
Column Constraints in given tables: Primary key in each table which ensures unique and not null values in column
Referential constraints in given tables:
- The referential integrity constraint is specified between two tables and it is
used to maintain the consistency among rows between the two tables
- A Foreign key in the tables which refers the primary key of another table. This ensures that
a foregin key must refer a primary key on another table.
User-defined constraints in given tables: It could be a primary key , foreign key in tables.
entity integrity constraint in given tables:
-The entity integrity constraint states that primary keys can't be null.
-The entity integrity constraints assure that a specific row in a table can be identified.
A relationship among relations is an example of entity constraint. example- one to one, many to one etc..
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.