Determine the data requirements for the oracle database

Assignment Help Database Management System

Reference no: EM131860836

Objectives:

• Create an Entity-Relationship Diagram (ERD) using Oracle Data Modeler (see below)

• Generate DDL from an ERD mode using Oracle Data Modeler

• Export the ERD from Oracle Data Modeler

• Implement database - execute the DDL in the Oracle Database(just instructions on how to implement)

Business situation

Your company has a Microsoft Access Contacts database. Your company wants to create an in-house Oracle version of this database. You can get familiar with an Access Contacts database from this video or download a copy by opening Microsoft Access and then search for Contacts.

Review the information that follows to determine the data requirements for the Oracle database. Use your findings to create an ERD, and the relational schema using Oracle Data Modeler.

The business analyst provided following details about company and the new database requirements

• The company has more than one department

• An employee is assigned to only one department

• A department has at least one employee

• Warehouse "Order assembler" team members share the same mobile phone

• Each employee has a job title

• Employees have a sequential employee ID number that isn't shown on the sample output

• Each Sales employee is assigned his own office and mobile phone number

1. Review the business analyst's requirements and sample output.

a. Describe any additional requirements and/or assumptions you make.

2. Review the definitions: entity, attribute and relationship and create a preliminary ERD for your contacts database.

a. Insert a screen clipping of your preliminary ERD in the space that follows. Show entity names, attributes, primary keys and relationships.

3. Assume that your company plans to expand its operations. There is also a possibility that the company will integrate your contact database with HR's employee database.

a. Suggest some future requirements could influence the preliminary design of your contacts database.

4. Develop the Relational Model from your logical model.

a. Insert a screen clipping of your relational model in the space that follows.

5. Generate the DDL of your relational model.

a. Export the DDL and save it to your computer. What is name of your DDL file?

Reference no: EM131860836

Questions Cloud

Why have some historians labeled the thirty years : Why have some historians labeled the Thirty Years' War the "last of the religious wars", while others have called it the "first modern war"?

How did the instability of politics at the turn : How did the instability of politics at the turn of the century show itself in daily life and art? How did this set the stage for the coming war?

Point of view of a person from ancient china : Chose one of the above Chinese belief systems and make narrative, in first person, from the point of view of a person

What is the optimal capital structure for an organization : What is the optimal capital structure for an organization, or does it vary from industry to industry?

Determine the data requirements for the oracle database : Your company has a Microsoft Access Contacts database. Your company wants to create an in-house Oracle version of this database.

What is the present value of all future payments : What is the present value of all future payments?

Means of governing-medical treatments : Choose a theme that is relevant across the 3 chosen cultures. Possible themes include: Ethical Codes for Living, Humans Relationship to the Natural

Find the terminal payoffs of the call option in up state : Find the terminal payoffs of the call option in the “up” state and in the “down” state; that is, find cu and cd.

Describe the influence of the confucian revival : Describe the influence of the Confucian revival during the Song Dynasty on Chinese Civilization.

User Account

All Pages