Question

1.An E-R diagram with all of the entities, attributes, identifiers and relationships. Be sure all relationships...

1.An E-R diagram with all of the entities, attributes, identifiers and relationships. Be sure all relationships are labeled appropriately with verb phrases and the diagram includes an appropriate legend (Name of the Model, Created by, Date/Time, Your Name and Course information, etc.)

2.A set of “Relationship Sentences”

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Solution 1:

As you didnt mention for what ER diagram have to made. So I am making ER diagram for order placing by customer.

Solution 2:

A set of “Relationship Sentences”:

Each ORDER must be issued for one or more ITEMs.

Each ITEM may be bought via one or more ORDERs.

Each ORDER must be originated by one and only one CUSTOMER.

Each CUSTOMER may be the originator of one or more ORDERs.

Each ITEM must be stored in one and only one WAREHOUSE.

Each WAREHOUSE may be the repository for one or more ITEMs.

Please give thumbsup, if you like it. Thanks.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Using the Entities and Attributes you created for your business from the week 1 discussions. Show...
Using the Entities and Attributes you created for your business from the week 1 discussions. Show the tables and relationships resulting from your model in the form of an E/R diagram. You can use PPT, VISIO or any other graphical modeling tool to create your ER diagram. Some of the entities and attributes that I believe my company should have would be: Employees: First Name, Last Name, Employee Address, Employee Phone Number, Employee ID Number, Date of Birth, Social Security...
You have learned some database components such as entities (tables) with attributes (columns/fields) and keys in...
You have learned some database components such as entities (tables) with attributes (columns/fields) and keys in previous lessons such as Relational Databases, Database Fields and Field Specifications, and Establishing Keys. Now based on the examples in those lessons, you will design a database for CTU, which includes three entities (tables): Students, Faculty, and Classes. Note a class refers to a particular class section. For example, the current CS253 you are taking is one class instance (i.e. CS253-01), and another CS253...
Design an E-R diagram to model a college described below: ● There are several departments in...
Design an E-R diagram to model a college described below: ● There are several departments in a college, and each of them has a unique name, one or more telephone numbers, and an address. ● Each department gives some number of courses. Each course has a course number which can be used to identify a course only inside of the same department. Each course has its schedule and a certain number of credits. Each course is held in some location...
Create a relational model and ER diagram based on the following info. Emerald Realty Group, Inc....
Create a relational model and ER diagram based on the following info. Emerald Realty Group, Inc. is a local real estate company that is specialized in leasing office space to businesses. The company does not own all the properties it leases. The company has its own suppliers and customers. We refer to the person or the company that owns the office space as a supplier. A customer is the person or the company that rents the office space. Emerald Realty...
Prepare an entity-relationship diagram for the database in a following company: Holiday Travel Vehicles sells new...
Prepare an entity-relationship diagram for the database in a following company: Holiday Travel Vehicles sells new recreational vehicles and travel trailers. When new vehicle arrives at Holiday Travel Vehicles, a new vehicle record is created. Included in a new vehicle record are a vehicle serial number, name, model, year, manufacturer, and base cost. When a customer arrives at Holiday Travel Vehicles, he or she works with a salesperson to negotiate a vehicle purchase. When a purchase has been agreed to,...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in 3rd normal form. Please indicate any assumptions that you have made. Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers, and employees. After an initial meeting with Wally, you have developed a list...
A certain airport authority wants to organize some of the data associated with the airport. The...
A certain airport authority wants to organize some of the data associated with the airport. The relevant information is as follows: Every airplane has a registration number and each airplane is of a specific model The airport accommodates a number of airplane models and each model is identified by a model number and has a capacity and weight Each airplane has an owner identified by name and contact phone number. A number of technicians work at the airport. You need...
MySQL data model: Netflix would like for you to build them a data model that tracks...
MySQL data model: Netflix would like for you to build them a data model that tracks the following information: Netflix would like to track the television shows that are watched by subscribers to the service. Subscribers of the service may watch more than one TV show. Shows may be watched by more than one subscriber. For television shows, they would like to track the episodes that comprise the show. Subscribers to the Netflix service watch episodes of various shows and...
Draw an E-R diagram pls Required Data The data items required for the train reservation database...
Draw an E-R diagram pls Required Data The data items required for the train reservation database can be classified into six categories: trains, stations, train schedules, reservations, customers and employees. The above classification does not imply any particular table arrangement. You are responsible for arranging the data items into tables, determining the relationships among tables and identifying the key attributes. Finally, you should specify and enforce integrity constraints on the data, including referential integrity constraints. You will first create an...
You are tasked to design the ER diagram for the database for the 3S clothing store....
You are tasked to design the ER diagram for the database for the 3S clothing store. Data requirements are as given below. • Information about 3S employees includes a unique employee ID, and his/her name and position. • Each customer of 3S is identified by a customer ID, and has a name. • Information about the suppliers of 3S include a unique name, and a contact phone number. • Clothes stocked by 3S are described by a product code, size,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT