Write sql to implement the relational database

Assignment Help Software Engineering

Reference no: EM131509688

Discussion- Topic 1

Review the three different data models for a database described in the reference given below. The three models are a relational schema, a network model and a Hierarchical model

• Relational schema

EMPS (ENAME, SALARY)
MANAGERS (ENAME)
DEPTS (DNAME, DEPT#)
SUPPLIERS (SNAME, SADDR)
ITEMS (INAME, ITEM#)
ORDERS (O#, DATE)
WORKS_IN (ENAME, DNAME)
MANAGES (ENAME, DNAME)
CARRIES (INAME, DNAME)
PLACED_BY (O#, CNAME)
CUSTOMERS(CNAME,CADDR,BALANCE)
SUPPLIES (SNAME, INAME, PRICES)
INCLUDES (O#, INAME, QUANTITY)

• Network model
• Hierarchical model

Part I

Construct an ERD of the database based on your understanding of the requirements shown in the graphical model.

• Post the ERD to the discussion and provide a brief description of the ERD.

1. Include in the description business rules and integrity details.

1. Entity types and relationships.
2. Primary keys and foreign keys.

Part II

Write SQL to implement the relational database based on your ERD in Part I and execute the SQL in Oracle.

Reference no: EM131509688

Questions Cloud

Variety of commercially available : Briefly desribe how you would design an experiment to test how much vitamin C is actually in a variety of commercially available products.

Write a program that will ask a user for their entire name : Write a program that will ask a user for their entire name as a single input. Example: If the input wast John Roe Doe, the output would be DOE, John R.

Evaluate online tools for business collaboration : Create an online meeting presentation to evaluate online tools for business collaboration.

Create a scenario in an interview setting : Create a scenario in an interview setting based on your previous professional or personal experience. Respond to each scenario

Write sql to implement the relational database : Write SQL to implement the relational database based on your ERD in Part I and execute the SQL in Oracle. Construct an ERD of the database.

Explain the egocentrism or sociocentrism : Provide an example from your own experience where you acted in accordance with one or more of the patterns of irrational or unethical decision making.

What is verbal and nonverbal communication : What is verbal and nonverbal communication? What is an example of a verbal, nonverbal, and body message

Carbon dioxide play a critical role in process : Explain how oxygen and carbon dioxide play a critical role in this process.

Why strategic plans are more effective : Using at least two examples, illustrate why strategic plans are more effective when HR plays a role in creating them

User Account

All Pages