Create the database in oracle using ddl, Database Management System

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:

  1. What is the total value of all consignments
  2. List out the Consignment Number, Agent Name and Destination of every consignment.
  3. List out the total value of all Consignments handled by Agent "Jane Doe".
  4. 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.
  5. List out the agents not currently handling any consignments
  6. List out any consignment numbers that will travel on more than one voyage
  7. List out any consignment numbers that have not yet been scheduled for transport
  8. List out the total number of consignments allocated to each vessel name

You will need to hand in ONE script which:

  1. Creates the required physical tables, indexes etc in Oracle
  2. Loads the data,
  3. Performs the SQL queries above
Posted Date: 3/2/2013 2:21:32 AM | Location : United States







Related Discussions:- Create the database in oracle using ddl, Assignment Help, Ask Question on Create the database in oracle using ddl, Get Answer, Expert's Help, Create the database in oracle using ddl Discussions

Write discussion on Create the database in oracle using ddl
Your posts are moderated
Related Questions
Data slice explanation


SET concept is used in which type of modelling? SET concept is used in Network Model.

This assignment is worth 45% of your final grade for this module.  Marks will be awarded as follows: Prototypes (wireframe and web based prototype) You are expected

What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.

Write short notes on tuple relational calculus. The tuple relational calculation is anon procedural query language. It defines the desired information without giving a particul

What are the advantages and disadvantages of using a database system. Sol. Advantages of Database System (DBMS) :  (1) Data Redundancy and Inconsistency: Since differen

Insertion Anomaly: Inability to show certain information-The primary key of the over relation be (enrolment number, Cno). Any new tuple to be inserted in the relation should have

What are the Objectives of Advance object design After this unit, you shall be able to: combine three OOAD models to obtain operations on the classes; develop algo

Benefits of heap files 1.   This is a easy file Organisation method. 2.   Insertion is somehow capable. 3.   Good for bulk-loading data into a table. 4.   Best if file