Question: Task 1 (2 marks) Create tables based on the schema given below: Table Name: PASSENGER Column-name Datatype PASSENGERID PK PASSENGERNAME ARCHAR2(20) ATE HAR 16) ERDOB

Task 1 (2 marks) Create tables based on the schema given

Task 1 (2 marks) Create tables based on the schema given below: Table Name: PASSENGER Column-name Datatype PASSENGERID PK PASSENGERNAME ARCHAR2(20) ATE HAR 16) ERDOB PASSENGERPHONE PASSENGERNATIONALITY VARCHAR2(15) able Name: Aircraft DATATYPE CHAR(2) VARCHAR2(10) VARCHAR2(10) NUMBER(3) COLUMN-NAME RCRAFTID (PK) AIRCRAFTMAKE AIRCRAFTMODEL ACITY

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Task 1 (5 marks): Create the above tables based on the list provided above: booking, cruise, model, qualifications, roster, schedule, staff, tour, and vessel. Insert at least five records into each...

Mini Exercise 1: Create a Java class named MiniExercise 1 (1 mark deduction if not). It is to have a main method that calls each of the static methods below ( 2 marks deducted if not) Task 1: 12...

Instructions: Perform all of the requested tasks given below. Description: You are required to build a Game of Chance which mirrors the Jamaican childhood game 'Ship Sail! Ship Sail! 'Ow much man deh...

Mini Exercise 1: Create a Java class named MiniExercise1 (1 mark deduction if not). It is to have a main method that calls each of the static methods below (2 marks deducted if not) Task 1: 12 marks...

This Assessment asks you to input data into a computerized accounting package and produce documents and reports. There are 5 tasks and it is important that you attempt all tasks. After each Task make...

Assignment 1 Create a Java class named Assignment1 (1 mark deduction if not). The package name should be assignment1. *Please note the case sensitivity. The class name should start with an uppercase...

Using CLIPS create a template for storing information of 3 patients in the hospital records. Use the following credentials for creating database of patients. Name Age Weight Height Blood-Sugar...

Exhibit 10.2 presents a partial balance sheet for Comerica Mills, Inc., a consumer foods processing company, for its fiscal years ending May 28, 2012, and May 27, 2013. a. Comerica Mills is not in...

Textcon Inc. has the following financial information for 2013 and 2014 a) Construct a balance sheet for Textcon Inc. for 2013 and 2014. What is shareholders? equity? b) Please construct an income...

Your German friend has decided to come visit you in the U . S . You estimate the cost of her trip will be $ 4 , 2 7 5 . What is the cost of her trip in euros if the U . S . dollar equivalent of the...

Why would a company go through the work of preparing a Flexible Budget if it already has a Static or Planning Budget in place? Multiple Choice Because the Flexible Budget will show the actual revenue...

2. Go to www.sabrehq.com, the Web site for Sabre Corporate Development. Click on Team Building Events. Choose one of the activities and events found on this page, and review it. Discuss what you...

4. Review one of the following Web sites, which feature simulations: www.incomeoutcome. com or www.celemi.com. Describe the situation that the simulation is designed to represent. What elements in...

3. Divide into teams of two students. One student should be designated as a trainer, the other as a trainee. The trainee should briefly leave the room while the trainer reads the instructions for...