Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Normalize the table into 3NF. The table store information about Bus, Driver and Trip (Non-anonymous question) (25 points) busto plateNum status driverid name DoB triplo

image text in transcribed
Normalize the table into 3NF. The table store information about Bus, Driver and Trip (Non-anonymous question) (25 points) busto plateNum status driverid name DoB triplo departure destination dep time arrivaltime day depdate 2 PP 2V-1002 usable 101 Chan Da 1960-02-01 201 Phnom Penh Sem Reap 07 00 00 13.00.00. Weekday 2010:12:30 3 PP 2W-2384 new 101 Chan Da 1960-02-01 201 Phnom Pern Sam Reap 07.00.00 13.00.00 Weekday 2016-1221 2 PP 2V-1002 usable 101 Chan Da 1060-02-01 202 Phnom Penn Siem Reap 07 30.00 13.30.00 weekend 2017.01.01 3 PP 2W-2384 103 Keo Chan 90 00 19 203 Phnom Penn preah ianu O 3000 12.30.00 weekday 2016-12 20 5 PP 22-0988 new 102 Sok Dara 1990-09-23 203 Phnom Penh proah siano 0730.00 123000weekday 2011 01.10 4 PP 2W.2385 new 103 B C l 90 | 0 Pom Pom prea sau 08 00.00 13.00.00 weekend 2011-01-01 4 PP 2W-2385 new 104 Sok San 1981-09-30 204 Prom Pern preah shanouk 08.0000 130000 wend 2010-11

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

Database Concepts

Authors: David M. Kroenke, David J. Auer

7th edition

133544621, 133544626, 0-13-354462-1, 978-0133544626

More Books

Students also viewed these Databases questions