ISM3201_304_GroupAssignment5_Spr2016 - Example a Write a...

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

View Full Document Right Arrow Icon
ISM 3201 – Data Files and Database Management Group Assignment #5 (worth 100 pts) DUE: Tues. Mar. 15 @ 1:59 p.m. (use class time on Tues. Mar. 15 to complete this assignment) Load ONE SOLUTION PER PAIR in the ASSIGNMENTS on Blackboard (DO NOT email) Pre Assignment Instructions Find a partner to work with in the course ( minimum of 2 people per group, no more than 3 people per group ) Submit a COVER SHEET with each member’s name on it (failure to do so WILL result in 15% point deduction) Instructions: For this assignment, you are to complete the following tasks with your partner: Chapter 4 – Lab Exercise Examine the following ER diagram, which appears in the exercise section of Chapter 4:
Image of page 1

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

View Full Document Right Arrow Icon
Figure 4.9 : (copy) E-R Diagram for CustomerOrder
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: Example a) Write a relational schema for this E-R diagram in a Word file. Underline primary keys and indicate foreign keys. b) Using Access, create the database to correspond to the schema. Name the database YourLastNames.acdb c) Insert several records (at least 3) into each table. d) In the Word file, write out (in English) five questions that could be used as queries (i.e., what would you look for in these tables?). e) In Access, using Query-by-Example (QBE), design the queries, and execute them. Refer back to previous exercises to see how to do this. Save your database. f) Save the Word document as YourLastNames_Lab4.doc and submit with the database file (the .acdb file) by the deadline....
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