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
how to make an e r diagram?


explain the steps for reduction of er model into relational model?

Objectives  After reading this unit you should be able to: Explain storage of databases on hard disks; Discuss the execution of various file Organisation techniques;

Lack of standards and experience: The lack of standards has considerably limited the potential of distributed DBMSs. As well, there are no tools or methodologies to help users cha

What it creates while a primary key is combined with a foreign key? It creates Parent-Child relation ship between the tables that connect them while a primary key is combined w

What is the archtetype/instance pattern? The archetype/instance pattern happens when one entity tracks occurrences of another entity. A common example is the relationship among

Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs

in case of functional dependencies how we get the higher normal form.

What Command You Use What Day of the week were you born