Reference no: EM13334322
Part One
Using the Oracle Developer Data Modeler tool, draw an Entity Relationship Model for the Galle Face Elephants case study above. Explain any assumptions you have made.
Hand-in: The ER model, plus assumptions if necessary.
Part Two
Use the Data Modeler tool to map your Entity Relationship model to a set of relations.
Hand in: the Relational Diagram produced from the Engineering process and a copy of the final generated DDL script (no need to hand in any intermediate scripts you may have generated). Highlight any additional constraints you have added to the tables, other than the primary and foreign keys.
Comment on any changes you made to the Relational diagram before mapping the final DDL script. Discuss why you had to make these changes (1 page maximum).
Part Three -
The final design should be tested to ensure it will meet the requirements for the sanctuaries. You need to produce appropriate test data to populate your tables and devise some queries that would test the design. Think about the type of queries that would be needed by the different types of users, for example, the employees, volunteers, potential volunteers and sponsors.
Give thought to what data should be added. As a minimum, each table should have at least 3 rows in it, but some should be more. Basically, the tables at the many end of a relationship should contain more data than the relation at the one end.
To summarise:
• Implement the DDL script produced by the Data Modeler tool in Oracle.
• Populate the tables with test data
• Produce 5 SQL queries to test your design
These must include at least one query that involves:
• A join
• An aggregate function, such as count, avg, etc.
• A selection (that is not all rows and columns are returned)
Credit will be given to queries that are not trivial, for example, "SELECT * FROM Tablename" is unlikely to gain more than one mark. SQL Developer can be used to produce the queries and populate the tables.
|
An accompanying verbal explanation
: An accompanying verbal explanation.
|
|
What is the average time a customer has to wait
: What is the average number of customers who are at the checkout desk, either waiting or currently being served and What is the average time a customer has to wait in line before getting served by the checkout employee, not including the actual chec..
|
|
What do you think should be the outcome of wooden pallets
: Sony Corp. packed a shipment of videocassette tapes into a 40-foot ocean container for transport to England. Sony put the tapes into 1,320 cardboard cartons, then strapped the cartons onto fifty two wooden pallets.
|
|
Calculate a stock with a beta
: Use the capital-asset pricing model to predict the returns next year of the following stocks, if you expect the return to holding stocks to be 12 perect on average, and the interest rate on three-month T-bills will be two percent. Calculate a stock w..
|
|
Using the oracle developer data modeler tool
: Credit will be given to queries that are not trivial, for example, "SELECT * FROM Tablename" is unlikely to gain more than one mark. SQL Developer can be used to produce the queries and populate the tables.
|
|
The four functions of management theory
: The new chief executive officer (CEO) of your company is a strong believer in the four functions of management theory. In preparation for a management meeting
|
|
Determine what is the risk-free rate of return-rrf
: ZR Corporation's stock has a beta coefficient equal to 1.8 and a required rate of return equal to 16 percent. If the expected return on the market is 10 percent, what is the risk-free rate of return, rRF
|
|
What was the maximum height the projectile reached
: On August 19,1987, Alessandro Andrei set a world record in the shot put with a throw of 22.9 m (75 ft 2 in.). What was the maximum height the projectile reached above the ground
|
|
Test plan for both unit testing and integration testing
: Do a test plan for both unit testing and integration testing, justification why you need this test creating the test case for each individual test must use java language in netbeans IDE to perform each test, screen capture one example to run the ..
|