Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone create an ERD with business rules, entities, etc explained below for a company called Dry Cleaning Business Rules : Each business rule must

Can someone create an ERD with business rules, entities, etc explained below for a company called "Dry Cleaning"

Business Rules:

Each business rule must describe a relationship in both directions

Each entity and each relationship used in the database must be described in this section

Each entity and each relationship described in this section must be presented on the ERD

Entities that includes:

Entitys name

Entitys description

List of attributes

Data type of each attribute (numeric, text, or date)

Sample data for each attribute

Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NULL where applicable)

Each entity must be described in the section. You must have a minimum of 4 entities. The total number of entities recommended is 4-5.

Relationships that includes:

A copy of a specific business rule from the Business Rules section for each relationship described here.

Relationships type: 1:1, 1:M, M:N. Use business rules to justify your decision.

Relationship strength: strong or weak. Use business rules to justify your decision.

Optionality for both sides of each relationship: mandatory or optional. Use business rules to justify your decision.

Each relationship must be described in the section. Each M:N relationship must be resolved and described.

Crow's Foot Entity Relationship Diagram:

ERD must be consistent with business rules and descriptions

ERD must show all entities and their attributes, relationships, connectivities, constraints, optionality and cardinalities

Tables and attributes names must follow naming conventions used in class

Each relationship must be properly labeled

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Successful Keyword Searching Initiating Research On Popular Topics Using Electronic Databases

Authors: Randall MacDonald, Susan MacDonald

1st Edition

0313306761, 978-0313306761

More Books

Students also viewed these Databases questions

Question

=+independent, then E[ F(Y)] + E[G(X)] = 1+ P[X=Y].

Answered: 1 week ago