Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

image text in transcribed

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 2

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_2

Step: 3

blur-text-image_3

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

Accounting And Auditing Research And Databases Practitioner's Desk Reference

Authors: Thomas R. Weirich, Natalie Tatiana Churyk, Thomas C. Pearson

1st Edition

1118334426, 978-1118334423

More Books

Students also viewed these Databases questions

Question

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

Answered: 1 week ago