Write SQL CREATE TABLE statements to create all the tables. Add t

Home / Questions / Write SQL CREATE TABLE statements to create all the tables. Add these statements to the...

Write SQL CREATE TABLE statements to create all the tables. Add these statements to the...

Write SQL CREATE TABLE statements to create all the tables.
Add these statements to the appropriate location within the script file.
Note:
• All tables must have primary keys.
• All tables must have appropriate foreign key constraints.
• Each foreign key column must have identical column name, data type and size of the
primary key that it refers to
• Add any NOT NULL constraints as dictated by the ERD
• The following columns data types and sizes must be used

Attachments:

manish jayant 06-Jul-2020

Answer (Solved)

question Get solution

Qantas Airways is the flag carrier airline of Australia Qantas Airways is the flag carrier airline of Australia. Qantas' headquarter is located at the Qantas Centre in the Mascot suburb of Sydney, New South Wales. The Qantas G...
Qantas has a centralised operational database to capture Qantas has a centralised operational database to capture their day-to-day ticket sales. Qantas provides online ticket sales and promotion agents for ticket sales. Promoti...
Qantas management is to ensure the successful completion Qantas management is to ensure the successful completion of around 300,000 flights every year to 57 airports around Australia and to 86 destinations in 36 countries that ...
Each service and the in charge engineer Each service and the in charge engineer, the parts used, the problem fixed and service log for an aircraft will be recorded in the database. The management must make sure...
To promote the better services to VIP members and award customers To promote the better services to VIP members and award customers’ loyalty, Qantas provide the airline lounge with airport locations around Australia and the world. Those...
Customers can pay their purchased tickets by cash Customers can pay their purchased tickets by cash, cheque, bank card, visa card, master cards and frequent flyer point. The payment by American express card will be charg...
There are hundreds Qantas flights transporting passengers from different airports There are hundreds Qantas flights transporting passengers from different airports to over 50 domestic and international destinations every day. Qantas flight operational...
The class of Qantas frequent flyer membership The class of Qantas frequent flyer membership is based on flying more for higher-level class. The types of memberships are based on distance flown, with bonuses that vary...
Each flight maintains an inventory table for consumable products Each flight maintains an inventory table for consumable products. The inventory will be refilled at end of each trip. The management wants to analyze the high costs of pr...
All Qantas Line Maintenance Stations can communicate with inbound aircraft provides All Qantas Line Maintenance Stations can communicate with inbound aircraft provides 24 hours per day for advice on incoming defects, facilitating the preparation of appro...

Service

Write SQL CREATE TABLE statements to create all the tables. Add these statements to the...

Write SQL CREATE TABLE statements to create all the tables. Add these statements to the...

Answer (Solved)

Ask Homework Question

Writing Help

Have a language expert improve your writing

Instant response from experts on your writing help queries

Find your question's answer instantly in our Q&A bank