1. Not finding help here? Sign up for a free 30min tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Please Review Database Tables for Advanced Database Class

  1. Aug 1, 2012 #1
    After you have analyzed the existing material used by the company for their day-to-day duties, the current Access database, and the additional requirements that the current system does not meet, the following requirements entity/attributes have been compiled:

    Customer information is tracked using ‘standard’ attributes.
    A customer may purchase products or services; if they purchase products or services, the following is tracked:
    Product purchased
    Date of purchase
    Total of purchase

    A supplier may sell products or services; if they sold products or services, the following is tracked:
    Product sold
    Date of sale
    Total of sale
    Is item purchased available for resale

    Your company wants to keep the number of tables storing address information to a bare minimum (read this as 1).

    Customers can be both a "supplier" and "someone that purchased services," and it is not required that they be either.

    Employee information is tracked using standard attributes.

    An employee will either be considered customer interfacing or internal support.

    If the employee is customer facing, the following information is tracked:
    Customer for interaction (note that a customer will only interface with a single employee)
    Product specialty
    Hours of training
    Commission rate

    If the employee is internal support, then the following is tracked:
    Salary
    Support area

    An employee can be either customer facing or internal support, but not both.

    Your company wants to keep the number of tables storing generic employee information to a bare minimum (read this as 1).

    Finally, the company wants to track products or services offered. This should be a single table with typical attributes that describe inventory.

    Every customer that either makes a purchase or sells goods to the company must be associated with an employee.

    Every transaction that a customer makes with the company is stored/tracked, A customer may buy or sell many products, and a product is sold to more than one customer.

    Create an enhanced ERD to meet these requirements. Ensure that entities are properly defined and appropriate attributes are listed for each entity. Also, ensure that all entities are properly related.

    Tables show All Tables with Table Name, Foreign Keys, and Primary Keys. Basic Relationships are also indicated.

    I have been graded on this assignment already, and I think I have fixed my tables, but am not confident I am ready to move on to the next phase which is to provide the SQL code that would actually build the tables. Could someone review the tables I have created and let me know if everything is right, or point out what is wrong so that I can fix it. Any advice would be greatly appreciated. The next assignment due date is Monday 8/13, but the sooner I fix my tables, the better!


    Logical_Data_Model.jpg
     
  2. jcsd
  3. Aug 4, 2012 #2

    CWatters

    User Avatar
    Science Advisor
    Homework Helper

    Is this really a physics question?
     
  4. Aug 4, 2012 #3
    No, it is not a physics question. That is why I placed this question in the "Engineering, Comp Sci, & Technology" discussion board, inside the "Homework & Coursework Questions" board.

    This is a Comp Sci Engineering Coursework/Homework question.

    Please do not post trash responses just to get your post number up. Either help, or don't help, but don't be a jerk.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Please Review Database Tables for Advanced Database Class
Loading...