LAB6 WIP

docx

School

Pennsylvania State University *

*We aren’t endorsed by this school

Course

210

Subject

Mechanical Engineering

Date

Apr 3, 2024

Type

docx

Pages

1

Uploaded by spencergross15

Report
a. Write the relational schema and draw the dependency diagram for the table structure. Make sure that you label all dependencies. CHAR_PAX indicates the number of passengers carried. The CHAR_MILES entry is based on round-trip miles, including pickup points. (Hint: Look at the data values to determine the nature of the relationships. For example, note that employee Melton has flown two charter trips as pilot and one trip as copilot.) Relational Schema NF( CHAR_TRIP , MODEL_CODE , CUST_NUM , CHAR_DATE, CHAR_CITY, CHAR_MILES, CHAR_PAX, CHAR_CARGO, PILOT, COPILOT, FLT_ENGINEER, LOAD_ENGINEER, AC_NUMBER, MODEL_SEATS, MODEL_CHG_MILES, CUST_LNAME) (composite primary key) (All diagrams on other named files)
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help