CIS111 Week 5 Discussion.docx

CIS111 Week 5 Discussion.docx - "Database Design and...

This preview shows page 1 out of 1 page.

"Database Design and Implementation" Please respond to the following: Now that you have learned the concepts of database models and you have practiced creating entity relationship diagrams, let us focus on the implementation of that design into a Database Management System (DBMS). Based on the example of the business function / operation that you described within the Weeks 1-3 discussions, describe the queries that you would need to create in order to support the business function / operation in question. On week 1 - 3, my example was the company Carfax. Based on their business function/operation, some of the queries needed would be, for example: CLIENT : LNAME, FNAME, MNAME, SSN, ADDRESS, PHONE, EMAIL VEHICLE : MAKE, MODEL, VIN, LOCATION, CONDITION, MILAGE INVENTORY LOCATION : STORE LOCATION, DISTANCE, TRANSACTION : CASH, FINANCE, BANK, CREDIT, CO-SIGNER, SALE PERSON, VIN PURCHASE ORDER : DATE, FINAL, VIN, CLIENT CONTACT, PURCHASE ID NUMBER etc ....
Image of page 1
You've reached the end of this preview.
  • Summer '09
  • POURCIAU

{[ 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