Question

In: Computer Science

Draw the ERD in Chen notation corresponding to the following spec: Sailors are identified by an...

Draw the ERD in Chen notation corresponding to the following spec:

  • Sailors are identified by an sid, having a name, age, and rating
  • Boats are identified by a bid and also have a name and a color.
  • Sailors reserve boats on a given date.
  • Every sailor reserves a boat at some time

Solutions

Expert Solution

ERD in Chen notation

As per the given requirement and provided details, the Entities of Boat Reservation ERD are:

1. Sailors:-

Attributes of Sailors Entity: sid, name, age and rating

Primary key of Sailors Entity is 'sid', as the entity is identified by the attribute 'sid'.

2. Boats:-

Attributes of Boats Entity: bid, name and color

Primary key of Boats Entity is 'bid', as the entity is identified by the attribute 'bid'.

3. Reservation:- This entity is an entity formed by boats and sailors to make reservation. So it is to be considered as a Weak Entity.

Primary key of Reservation entity is named as 'reserveid' which is formed by bid of Boats and sid of Sailors(So bid and sid will be the foreign keys for this Entity).

ERD for Boat Reservation by Sailors

This ERD is created as per Chen notation.  As the Reservation entity is a weak entity it is represented by double rectangle and the discriminator 'reserveid' underlined with a dashed line.  


Related Solutions

Draw the corresponding ERD for the following Employee Database: Employee (emp_id, first_name, middle_name, last_name, date_of_birth) Dept...
Draw the corresponding ERD for the following Employee Database: Employee (emp_id, first_name, middle_name, last_name, date_of_birth) Dept (Dept_id, Dept_name, Building) works (emp_id, dept_id, hours) Emp_phone (emp_id, phone_num) Note: Please I need a short answer only on paragraph and simple words.
Create a Crow’s Foot notation ERD to support the following business operations: Create a Crowsfoot notation...
Create a Crow’s Foot notation ERD to support the following business operations: Create a Crowsfoot notation ERD to support the following business operations: - A friend of yours has opened Marshfield Electronics and Repairs (MER) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business. When a customer brings a device to MER for repair, data must be recorded about the customer, the device, and the repair (also referred...
Create an ERD (using Crow’s Foot Notation) for the following description. Be sure to include all...
Create an ERD (using Crow’s Foot Notation) for the following description. Be sure to include all necessary entities, attributes, and correct cardinality in relationships between entities. You have been asked to build a database for a sportswear company called AthFleet. The company owner needs to keep track of the customers that buy their products, the employees that work at AthFleet, the vendors that provide them with products, and the products themselves. Each vendor has contact with one employee representative and...
ERD Lucid chart with Crow's foot notation for the following. include all entities, attributes, and correct...
ERD Lucid chart with Crow's foot notation for the following. include all entities, attributes, and correct carnality in relationships between entities. primary and foreign keys. You have been asked to build a database for a sportswear company called Ath Fleet. The company owner needs to keep track of the customers that buy their products, the employees that work at Ath Fleet, the vendors that provide them with products, and the products themselves. Each vendor has contact with one employee representative...
2. Draw an entity relationship diagram (ERD) for the following situation: The state of Georgia is...
2. Draw an entity relationship diagram (ERD) for the following situation: The state of Georgia is interested in designing a database that will track its researchers. Information of interest includes researcher name, title, position; university name, location, enrollment; and research interests. Each researcher is associated with only one institution, and each researcher has several research interests. 3. Visit a Web site that allows customers to order a product over the Web (e.g., Amazon.com). Create a data model that the site...
Draw an ERD with the following information: You are a database consultant with Ace Software, Inc.,...
Draw an ERD with the following information: You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Johnson Video Store in town. The owners have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with the owners to...
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The...
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). A company has many divisions. Each division operates many departments, but each department is operated by one division. b). A department employs many employees but not more than 100. c). Each employee is employed...
I need a list of business rules and corresponding ERD for a simple, very basic Pet...
I need a list of business rules and corresponding ERD for a simple, very basic Pet Store. Don’t think Petco or PetSmart, think little shop with only one location. They sell puppies, kittens, fish, and some reptiles. They also sell fancy food, toys, and beds for all these pets. Basically, the store sells things (2 entities), by whom (entity), to who (entity), and how (entity). I need two things: First, information containing the operation and business rules for a simple...
Draw an ERD for a scenario in which patients visit doctors. It is possible that a...
Draw an ERD for a scenario in which patients visit doctors. It is possible that a patient is visited by more than one doctor. Create DOCTOR and PATIENT entities and add at least four attributes to them including a primary key. Create an implementation ready ERD with all appropriate connectivities and cardinalities. Justify your choice of cardinalities with real world examples. In case you need to add any new entities, add at least two attributes apart from their primary keys...
Draw an ERD diagram for Hair Saloon and describe its relationship
Draw an ERD diagram for Hair Saloon and describe its relationship
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT