Using the table structure shown in Table P6.4, do the following, computer science homework help

User Generated

TKVNBLHNA

Computer Science

Description

Using the table structure shown in Table P6.4, do the following:

1.Write the relational schema, draw its dependency diagram, and identify all dependencies, including all transitive dependencies.

2.Write the relational schema and draw the dependency diagram to meet the 3NF requirements to the greatest extent possible. If you believe that practical considerations dictate using a 2NF structure, explain why your decision to retain 2NF is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions.

3.Draw the Crow’s Foot ERD.

Unformatted Attachment Preview

Attribute Name STU NUM STU LNAME STU_MAJOR DEPT_CODE DEPT_NAME DEPT PHONE COLLEGE NAME ADVISOR_LNAME ADVISOR OFFICE ADVISOR BLDG ADVISOR_PHONE STU_GPA STU_HOURS STU CLASS Table P6.4 Sample STUDENT Records Sample Value Sample Value Sample Value Sample Value Sample Value 211343 200128 199876 199876 223456 Stephanos Smith Jones Ortiz McKulski Accounting Accounting Marketing Marketing Statistics ACCT ACCT MKTG MKTG MATH Accounting Accounting Marketing Marketing Mathematics 4356 4356 4378 4378 3420 Business Admin Business Admin Business Admin Business Admin Arts & Sciences Grastrand Grastrand Gentry Tillery Chen T201 T201 T228 T356 0331 Torre Building Torre Building Torre Building Torre Building Jones Building 2115 2115 2123 2159 3209 3.87 2.78 2.31 3.45 3.58 75 45 117 113 87 Junior Sophomore Senior Senior Junior
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Running head: DATABASE SYSTEMS

1

Name
Institution
Course name

DATABASE SYSTEMS

2

1. Dependencies
Part A
Partial dependency

STU_NUM

STU_LNAME

STU_MAJOR

STU_GPA

STU_HOURS

STU_CLASS

Transitive dependency

STU_NUM -> STU_LNAME, STU_MAJOR, STU_GPA, STU_HOURS, STU_CLASS

Partial ...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags