864 Homework 1

.docx

School

San Francisco State University *

*We aren’t endorsed by this school

Course

864

Subject

Information Systems

Date

May 11, 2024

Type

docx

Pages

Uploaded by 24uzmanaeem on coursehero.com

Problem 1 a. List all the entities required in your database 1. Restaurants: - Restaurant License Number, - Street name, - City, - State, - Zip code. 2. Market Firms - Unique identification number - Name, - City, - State, - Zip code. 3. Supplier - Unique identifier - Name, - City - Specialty 4. Employee - Unique employee number, - Employee name, - Number of years employed b. Provide a list of business rules you can derive. 1. Each restaurant may work with many marketing firms . 2. Each marketing firm may work with many restaurants. 3. Each restaurant must get their supply from one or more suppliers. 4. Each supplier must supply to at least one or more restaurants . 5. Each restaurant must have at least one employee. 6. Employee must not work at more than one restaurant .

2) Using the information given and the derived business rules, draw an Entity Relationship Diagram of your database.

Problem 2 Problem 3

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help