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

Info icon This 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
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern