Create the database in oracle using ddl, Database Management System

Assignment Help:

The Assessment page has a link to download a conceptual model, and a list of data.

You are to map this conceptual model, and create the database in Oracle using your own DDL. Then load your database with the list of data on the assessment page.

Then you are required to write SQL statements to perform the objectives listed below:

What is the total value of all consignments
List out the Consignment Number, Agent Name and Destination of every consignment.
List out the total value of all Consignments handled by Agent "Jane Doe".
List out the commission for each Agent, assuming that Commission is calculated at 2% of the total value of the consignments that the Agent handles.
List out the agents not currently handling any consignments
List out any consignment numbers that will travel on more than one voyage
List out any consignment numbers that have not yet been scheduled for transport
List out the total number of consignments allocated to each vessel name

You will need to hand in ONE script which:

Creates the required physical tables, indexes etc in Oracle
Loads the data,
Performs the SQL queries above

Related Discussions:- Create the database in oracle using ddl

Clinic, Need a sample of a clinic database relationships

Need a sample of a clinic database relationships

Define the terms entity set and relationship set, Define the terms i) Entit...

Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela

Describe the relational model, a) Distinguish between ‘database' and ‘Data...

a) Distinguish between ‘database' and ‘Database Management Systems (DBMS)'. b) List and briefly describe five potential benefits of the database approach compared to conventio

Relation instance or relation state, A relation instance indicates as r is ...

A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....

boyce codd normal form relations, Create centralized relational database u...

Create centralized relational database using bottom up method. (a) Recognize a single un-normalized relation for the above scenario. (b) Recognize the primary key for

Differentiate between a subquery and a join, Differentiate between a subque...

Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t

What are advantages of object models, What are advantages of object models?...

What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p

Join operation, The JOIN operation is applied on two relations. When we wan...

The JOIN operation is applied on two relations. When we want to choose related tuples from two given relation join is used. The join operation need that both the joined relations m

Calculate the record size r in bytes, An employee record has the following ...

An employee record has the following structure struct employee { int eno; char name[22]; float salary; char dept[10];}; (i) Calculate the record size R in bytes.

File and system structure, Hierarchical

Hierarchical

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages