Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop a relational schema (textual representation) consisting of 3NF relations. In your relational schema, make sure to show entity integrity and referential integrity constraints properly.

  1. Develop a relational schema (textual representation) consisting of 3NF relations. In your relational schema, make sure to show entity integrity and referential integrity constraints properly.
  2. List all (partial, full, and transitive) functional dependencies for this relational schema.
  3. Comment in 1-2 sentences on why this relational schema is in the third normal form

image text in transcribed

REQUIREMENT PK Req Num Req_Desc FK1 Rank_Num includes i I ATTAIN RANK STUDENT u earns earned PK Rank Num PK Stu Num Stu_ FName PK, FK1 Rank Num> PK, FK2 Stu Num Attain_Date Rank Name Rank_Belt Stu_LName Stu_DOB Stu_Join_Date Stu_ls_Inst has completes 0 ATTENDANCE PK, FK1 Meet Numo PK, FK2 Stu Num Att Role MEETING -HPK Meet Num Meet Date FK1 Class ID Stu_ls_Inst O " generates i I CLASS is assigned H----- - - - - - - - - - - - - - INSTRUCTOR - PK, FK1 Stu Num Inst_Hire_Date Inst_status PK Class ID Class_Weekday Class_Time Class_Location Class_Level FK Stu_Num

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Solaris 11.2 System Administration (oracle Press)

Authors: Harry Foxwell

1st Edition

007184421X, 9780071844215

More Books

Students also viewed these Databases questions