Question: can anyone help me to make 3NF Relational Schema based on this ERD? 10.0 INITIAL ENTITY RELATIONSHIP DIAGRAM (ERD) CUSTOMER TICKET ROUTE PK Cust ID

can anyone help me to make 3NF Relational Schema based on this ERD?

10.0 INITIAL ENTITY RELATIONSHIP DIAGRAM (ERD) CUSTOMER TICKET ROUTE PK Cust ID PK Ticket_ID PK Route ID Name #FK1 Cust_ID Date BUS IC_num FK2 Route_ID Time PK BusNO Birtdate FK3 Pay_ID Origin FK1 Route_ID Time Destination FK2 Driver_ID Phone_num Date Fee Email Ticket_fee Seat_ID DRIVER PK Driver ID SEAT Driver_name PAYMENT PK Seat ID Driver_phone PK Pay_ID FK1 BusNO Driver_hiredate Payment_time Class

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

database management system COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI AHMI DR. MOHD...

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

Check Lay Check ou Cum ID Cut Nane Cast Phone Cust Type Cite A ID NE Nane A TVO Ante Guest Count son Num Rais TYD Rate TV Desc Aum 1001 W2020 1/2000 B Wesley Tanner 1759 3191 COM 125 20 Mega Smith FO...

please help me answer this question, I promise to upvote on the right answer 01 J14-rroject 1 Due 3/12 Cunho Cum Art ER 2 c 2200 Core SUS 1003 10 RE Bere . 1 2 3 20 Me 14 - > ne Business Rules: Each...

Case Study: Public Bus Ticket Management System Executive Summary This paper presents the design and development of a comprehensive Public Bus Ticket Management System, aimed at addressing the...

Hi expert, this question is for my Information Systems class (database management systems). If you could explain what to do and show examples that would be greatly appreciated.. Thank you Business...

Database ER Model & Normal Forms (Right Click on the Image -> Then Click on "Open Image In New Tab" for full resolution image) Business Rules: Each reservation belongs to a specific customer;...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

5. Exchange rates and the demand for domestic goods Piano Palace Co. produces electronic keyboards in the United States. Its most popular keyboard sells for $1,500. KeySharp Co., Piano Palace's...

Let p be the population proportion for the following condition. Find the point estimates for p and q. Of 939 children surveyed, 96 plan to join the armed forces in the future. The point estimate for...

50. Are you in favor of the ruinous economic policy of the Democratic Platform Committee? Identify the fallacies of relevance, weak induction, presumption, ambiguity, and grammatical analogy...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...