Scribd Logo
Upload

Welcome to Scribd!

  • 133 views

    Chapter 7 12 Answer

    Uploaded by

    Leng Hour leng
    Jim Smith's car dealership keeps information on the manufacturers it works with including vehicle models and pricing, and it tracks customer and sales details like names, vehicles purchased, and amounts paid to allow for future contact. The dealership stores this data in an entity relationship diagram with tables for Manufacturers and their vehicle information, Customers, and Sales transactions.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd

    Chapter 7 12 Answer

    Uploaded by

    Leng Hour leng
    133 views4 pages
    Jim Smith's car dealership keeps information on the manufacturers it works with including vehicle models and pricing, and it tracks customer and sales details like names, vehicles purchased, and amounts paid to allow for future contact. The dealership stores this data in an entity relationship diagram with tables for Manufacturers and their vehicle information, Customers, and Sales transactions.

    Original Title

    100273067-Chapter-7-12-Answer

    Copyright

    © © All Rights Reserved

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Jim Smith's car dealership keeps information on the manufacturers it works with including vehicle models and pricing, and it tracks customer and sales details like names, vehicles purchased, and amounts paid to allow for future contact. The dealership stores this data in an entity relationship diagram with tables for Manufacturers and their vehicle information, Customers, and Sales transactions.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    133 views4 pages

    Chapter 7 12 Answer

    Uploaded by

    Leng Hour leng
    Jim Smith's car dealership keeps information on the manufacturers it works with including vehicle models and pricing, and it tracks customer and sales details like names, vehicles purchased, and amounts paid to allow for future contact. The dealership stores this data in an entity relationship diagram with tables for Manufacturers and their vehicle information, Customers, and Sales transactions.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    of 4
    At a glance
    Powered by AI
    The document discusses an ERD for a car dealership and the process GSC uses to fulfill purchase orders from government agencies.

    The dealership keeps information such as the address, phone number, and contact person for each manufacturer so employees can easily contact them. It also keeps information on the models, list price, price paid, and details of cars it carries from each manufacturer.

    When GSC receives a purchase order, the contracting officer enters the contract number into the database and reviews the terms and conditions to determine if the purchase order is valid based on whether the contract has expired, the equipment ordered is listed, and the cost does not exceed the limit. An invalid purchase order is returned with a letter explaining why it cannot be filled.

    Fully-attributed ERD

    Jim Smith’s dealership sells Fords, Hondas, and Toyotas.


    The dealership keeps information about each car
    manufacturer with whom it deals so that employees can get
    in touch with manufacturers easily. The dealership also keeps
    information about the models of cars that it carries from each
    manufacturer. It keeps such information as list price, the price
    the dealership paid to obtain the model, and the model name
    and series (e.g., Honda Civic LX). The dealership also keeps
    information about all sales that it has made (for instance,
    employees will record the buyer’s name, the car the buyer
    bought, and amount the buyer paid for the car). To allow
    employees to contact the buyers in the future, contact
    information is also kept (e.g., address, phone number).
    Manufacturer Cars
    -Primary Key------------ -Primary Key------------
    Make [PK] VIN # [PK]
    -Non-Key Attributes---- -Non-Key Attributes----
    Address Make Make [FK]
    Phone Model
    Contact person Series
    List price
    Price paid

    Make

    Customer Sales
    -Primary Key------------ -Primary Key------------
    Cust ID [PK] Sales order # [PK]
    -Non-Key Attributes---- -Non-Key Attributes----
    First Name Make Cust ID [FK]
    Last Name VIN # [FK]
    Address Price
    Phone
    DFD Problem
    Government Solutions Company (GSC) sells computer equipment to federal
    government agencies. Whenever a federal agency needs to purchase
    equipment from GSC, it issues a purchase order against a standing contract
    previously negotiated with the company. GSC holds several standing contracts
    with various federal agencies. When a purchase order is received by GSC’s
    contracting officer, the contract number referenced on the purchase order is
    entered into the contract database. Using information from the database, the
    contracting officer reviews the terms and conditions of the contract and
    determines whether the purchase order is valid. The purchase order is valid if
    the contract has not expired, the type of equipment ordered is listed on the
    original contract, and the total cost of the equipment does not exceed a
    predetermined limit. If the purchase order is not valid, the contracting officer
    sends the purchase order back to the requesting agency with a letter stating
    why the purchase order cannot be filled, and a copy of the letter is filed. If the
    purchase order is valid, the contracting officer enters the purchase order
    number into the contract database and flags the order as outstanding. The
    purchase order is then sent to the order fulfillment department. Here the
    inventory is checked for each item ordered. If any items are not in stock, the
    order fulfillment department creates a report listing the items not in stock and
    attaches it to the purchase order. All purchase orders are forwarded to the
    warehouse where the items in stock are pulled from the shelves and shipped to
    the customer. The warehouse then attaches to the purchase order a copy of
    the shipping bill listing the items shipped and sends it to the contracting officer.
    If all items were shipped, the contracting officer closes the outstanding
    purchase order in the database. The purchase order, shipping bill, and
    exception report (if attached) are then filed in the contracts office.
    Purchase Order Contract Terms
    Government Verify
    Contract Database
    Agency Purchase
    Invalid P.O. Order Outstanding P.O.

    Valid P.O.

    Availability
    P.O. Letter File Check Inventory
    Inventory

    PO & Out-of-stock

    Closeout Info

    Items Shipped Pull & Ship PO, Shipping Bill


    Contracts File
    Items & Exceptions

    You might also like