Question: An logical database schema is given on the next page, and DDL for the database is found in the the attached file model.sql.For the model
An logical database schema is given on the next page, and DDL for the database is found in the the attached file model.sql.For the model on the next page, answer the following (explain why, not just yeso):
1.Is this schema in 1NF?
2.Is it in 2NF?3.

Is it in 3NF?
Passing regno timestamp station TollStation idTollstation name Car regno taxclass owner TaxClass idTaxClass description Fee idFee taxclass type costPerPassing Subscription regno Illustration 1: Logical database schema Tollstation 123 id Tollstation ABC name Passing Ang regno timestamp 123 tollstation Fee 133 idFee 123 taxclass Aoc type 123 costPerPassing TaxClass 123 idTaxClass ABC description Subscription As regno Car A regno ADC Owner 123 taxclass Illustration 2: EER diagram of the model 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
