Question: Overview: An early part of the relational database design process is identifying entities. For each entity, you must identify its attributes. From this list of

Overview: An early part of the relational
Overview: An early part of the relational database design process is identifying entities. For each entity, you must identify its attributes. From this list of attributes, you will choose a unique attribute or set of attributes as the entity's identifier. Case Study You are designing a database application for an online grocer. Customers place orders over the internet, and the orders are delivered to the customers' homes. Customers must live within 50 miles of a delivery warehouse. The company has 12 delivery warehouses in Florida. Each employee has an employee ID. You also need to track the employee name and address, manager, and warehouse location at which the employee works. Each warehouse is identified for tracking purposes by a four-digit code. The application will use a mapping program to automatically qualify customers and assign the nearest warehouse for customer deliveries. A customer is assigned an ID when first registering at the grocer's web site. The customer must provide a contact name and phone number, address, and billing information. Restocking orders are placed daily. Each vendor sells a wide range of items, and each inventory item can usually be ordered from at least two different vendors. Assignment: List the entities described in the case, including attribortes and the best identifier

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!