Question
Can you explain to me how to create tables in mariadb by following these instructions? You will now implement the schema from the previous task
Can you explain to me how to create tables in mariadb by following these instructions?
You will now implement the schema from the previous task in your MariaDB database and fill it with test data before we in the next task will try to optimize the performance.
Fill the database with data from the attached file carpassingdb.txt. The fields are separated with ; with each row on a separate line. The fields are:
1.Car registration number
2.Data and time for passing a toll station
3.Id of toll station
4.Name of toll station
5.Name of car owner
6.Id of car tax-class
7.Description of tax class
8.Whether the car has a subscription, yes or no
9.Regular fee for cars passing a toll station
10.Fee for cars with a subscription
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 2Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started