Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please using DBMS to design a database. (MS Access) And do specific step by step A relational database system can relate data in one table

image text in transcribedimage text in transcribed

image text in transcribed

Please using DBMS to design a database. (MS Access) And do specific step by step

A relational database system can relate data in one table to another, allowing a user to tie together data from several tables. Create a database called GTDB that consists of four tables, named FMPI OVFF CI IFNT RFSFRVATION FI IFHT and CITV Details of these tables are AIRPORT_NAME AIRPORT_CITY AIRPORT_COUNTRY 2. Identify and create the relationships between the tables. Enforce the integrity constraints. 3. Add data in the tables. - Minimum 5 records in the EMPLOYEE table. - Minimum 10 records in the CLINET table. - Minimum 15 records in the RESERVATION table. - Minimum 20 records in the FLIGHT table. - Minimum 30 records in the CITY table. One sample record for each table is shown below. You need to create your own data for each table. EMPLOYEE table record: EMP_ID EMP_FNAME EMP_LNAME EMP_ADDRESS EMP_CITY EMP_PHONE EMP_EMAIL E001 Peter Jones 1235th Street Vancouver 6042221234 pj@@ galaxy.ca CLIENT table record: CLINET_ID CLIENT_FNAME CLINET_LNAME CLIENT_GENDER CLINET_DOB CLINET_ADDRESS C00001 Tim Smith 3 Male 1992-12-25 234 Nice Ave CLIENT_CITY CLINET_PHONE CLIENT_EMAIL New Westminster 604-222-2345 tim@gmail.com RESERVATION table record: RSERVATION_ID CLIENT_ID DEPARTURE_AIRPORT DESTINATION_AIRPORT DEPARTURE_DATE R00001C00001YVRYYZ20230328 DEPARTURE_FLIGHT RETURN_DATE RETURN_FLIGHT BOOKING_REFERENCE TICKET_NUMBER AC11620230420AC127PKGKMY2345578896556 BOOKING_DATE PRICE EMP_ID 2023-01-15 527.99 E001 FLIGHT table record: FLIGHT_ID FLIGHT_NUMBER DEPARTURE_AIRPORT DEPARTURE_TIME ARRIVAL_AIRPORT F001ACAC116YVR1315 - YYZ ARRIVAL_TIME PLUS_DAYS 2042 - 0 AIRPORT table record: AIRPORT_CODE AIRPORT_NAME AIRPORT_CITY AIRPORT_COUNTRY YVR Vancouver International Airport Vancouver Canada 4. Create a data input form for the CLIENT table and name it Client_YourFirstName_Form. Make any adjustments necessary to the form so that all data display properly. 5. Create a report named YourFirstName_Sales_Report grouped by employee id and booking date. The report should contain the following information in addition to proper headings, subtotals and totals. Employee Name, Booking Date, Booking Reference, Client Name, Price Submission: The following marking scheme will be used for this assignment: Tables, Relationships - Tables 5 tables - Relationships - Relationship Report - Complete and correct data entry - Client form with correct name - Sales Report Total 10 2 2 2 4 20 Submission: 1. Save as database file as GTDG_YourFirstName_FirstLastname_StudentId_A1.accdb 2. Submit in Blackboard before the due date

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

Students also viewed these Databases questions