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

Project, project on dbms

project on dbms

Data cube, Data slice explanation

Data slice explanation

Tables, does tables are called relations

does tables are called relations

Unrepeatable reads-problems of concurrent transactions, Unrepeatable reads ...

Unrepeatable reads : Assume T7 reads X twice during its implementation. If it did not update X itself it could be very disturbing to see a dissimilar value of X in its next read. B

State the functional approach of object oriented methods, State the functio...

State the functional approach of object oriented methods Moving from a functional approach to an object oriented one needs a translation of functional model elements into objec

Define deadlock prevention, Define deadlock prevention. Deadlock preven...

Define deadlock prevention. Deadlock prevention is a set of methods for ensuring that at least one of the four essential conditions like mutual exclusion, hold and wait, no pre

Assign, #quesDefine a job scheduling strategy that will meet business requi...

#quesDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pi

What are stored-procedures, What are stored-procedures? And what are the ad...

What are stored-procedures? And what are the advantages of using them? Stored procedures are database objects that perform a user defined operation. A stored procedure can have

Example of transaction? , Example :; transfers transfer_amount from x's acc...

Example :; transfers transfer_amount from x's account to y's account ; Supposes x&y both accounts exist TRANSACTION (x, y, transfer_amount) Start transaction IF X AND Y

When are two schedules said to be view equivalent, When are two schedules s...

When are two schedules said to be view equivalent? Ans: Two schedules that is denoted as S and S' are said to be view equivalent if the subsequent three conditions are met

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages