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

Define a relation schema, A Relation Schema represented by R(A1, A2, ..... A Relation Schema represented by R(A1, A2, ..., An) is made up of the relation name the list of attributes and R Ai that it contains. A relation is described as a set of tuples

Define the query optimisation, Define the Query optimisation The query ... Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica

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

How can you terminate the mysql server, How can you terminate the MySQL Ser... How can you terminate the MySQL Server? Typing the following in Command prompt will shut down the server completely as root user % mysqladmin -u root -p shutdown

Homework, can you resolve this for me please? Database Management Systems ... can you resolve this for me please? Database Management Systems Homework 1 The following relations are given (primary keys are underlined): PLAY-ACTOR(AId, Name, Nationality, Birt

Problems of concurrent transactions-lost updates, Lost Updates : Suppose th... Lost Updates : Suppose the two transactions T3 and T4 run simultaneously and they happen to be interleaved in the following way (suppose the initial value of X as 10000):

What are the objectives of query processing, What are the objectives of que... What are the objectives of query processing?       Ans: The objectives of query processing is to transform a query written in a high level language into a accurate and efficien

What is d command work in the respect of qbe, What is D command work in the... What is D command work in the respect of QBE? D: It is the command inside QBE to delete tuple(s) from the relation.

List out user authorization to modify the database schema, List out various... List out various user authorization to modify the database schema. a)  Index authorization b)  Resource authorization c)  Alteration authorization d)  Drop authorizat

Apriori algorithm-find all frequent large itemsets, Your friend owns a comp... Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t