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

Ask an Expert

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

Write your message here..

Related Questions

What is predictive modelling, Question : (a) Data mining is one of the... Question : (a) Data mining is one of the best ways to analyse data and using software method, hidden and unexpected patterns and relationships in sets of data can be extracte

Define the basic operations of the relational algebra, Define the basic ope... Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

Define transitive dependencies, What do you understand by transitive depend... What do you understand by transitive dependencies? Define with an example any two problems that can take place in the database if transitive dependencies are available in the datab

The internal or physical level in dbms, The Internal or Physical Level ... The Internal or Physical Level The collection of files permanently stored on secondary storage devices is called as the physical database. The internal or physical level is t

What is message switching, What is Message switching Message switching ... What is Message switching Message switching transmits data units which can be arbitrarily long. Packet switching has a utmost packet size, if any message longer than that, it s

System Analysis and design, Using the questions found at the end of Chapter... Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.

Define mysql_fetch_object(), What are the differences among MySQL_fetch_arr... What are the differences among MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()? Mysql_fetch_object returns the result from the database like objects while mysql

In an e-r diagram how attributes are represented, In an E-R diagram how att... In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

In how many parts events are classified, In how many parts events are class... In how many parts events are classified Events are classified as four types in UML 1.  Signals 2.  Calls 3.  Passing of Time 4.  Change in State

Transaction, .#question. Discuss the problem which may arise during concurr... .#question. Discuss the problem which may arise during concurrency control and recovery in distributed database which are not encountered in controlized database environment.