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
Define the step - Rearranging the Execution Order for Efficiency As we know that algorithm and data structure are closely related to one another, but data structure is conside

Should I select imaging software that allows changes? An imaging system should not give features to edit or alter images. Images generally are formed as safe and secure records

You group has been hired by  TrainingrUs.com to keeps track of training revenues. TrainingrUS.com wants you to keep scheduling. COURSE table contains following information:

Describe the two alternatives for specifying structural constraints on relationship kinds? Relationship kinds have certain constraints in which limit the possible combination o

Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order

Project Description: I am updating my Javascript + HTML website with five domains for the same website I would like to know if I want to create site map and submit it in all the

What are axioms? Axioms or rules of inference give a simpler technique for reasoning about

What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

Create Relational Database Model (RDM) for Sailing bed and breakfast club Table_Name( attribute_1, attribute_2, attribute_3, ? ,attribute_x) Primary Key ( attribute_1, attribute_2)

Using Relational Algebra which query finds customers, who have a balance of over 1000 ? Using Relational Algebra Π Customer_name( σ balance >1000(Deposit)) is query to find cu