Assignment 2 Solutions - d Order delivered to customer...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment 2 Solutions Project Manual: Project 3.2, Part A: Case #1 only. Read the description of the online grocer. Identify and  list the following  items 1. User/Owner –  Any one of the following  a. Owner of online grocery store b. Customer c. Employees filling order 2. Entities with identifiers any four a. Vendor, Vendor-id b. Employee,  Employee-id c. Inventory or Product, Inventory-id or Product-id d. Warehouse, Warehouse-id  e. Delivery, Delivery-id f. Customer, Customer-id g. Order, Order-id 3. Business Rule(s) – Customer has to live within 50 miles  of a delivery warehouse 4. Process(es) any three of the following a. Order products b. Customer creates order online c. Order filled in warehouse
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: d. Order delivered to customer Textbook: 1. Page 99-100, Summary Questions answers 2 D 3 B 4 A 5 C 8 C 2. Applying This Chapter, Page 103 Creating a Data Model . Using Visio, create an ERD for Lucky Rent-A-Car . Draw and name each entity, include the attributes for each entity, and include the lines to connect each entity to its related entities (relationships). For this problem, use lines only for relationships--not necessary to include cardinality / modality. Since cardinality was not required, arrows would be enough and foreign keys are also not required...
View Full Document

This note was uploaded on 09/21/2011 for the course CGS 2545 taught by Professor Markllewellyn during the Summer '10 term at University of Central Florida.

Page1 / 3

Assignment 2 Solutions - d Order delivered to customer...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online