Penn Health Supplies want to use a relational database to keep track of its PPE mask shipments. They need to know what is in each shipment, the price charged, who made the shipment, and who it is going to. The fields below need to put into a schema that is consistent with 3NF and properly formatted.
Item description
Item Price (Which can vary on every sale, depending on what is
negotiated)
Shipping clerk #
Customer #
Customer name
Customer address
Shipment #
Shipment Date
Shipped Quantity
Unorganised Data of Penn Health Supplies
Item Desription | Item Price | Customer ID | Customer Name | Customer Address | Shipping Clerk ID | Shipment ID | Shipment Date | Shipped Quantity |
The following effect will be given effect after normalisation to to create a realational database to be put under schema consistent with 3rd Normal Form where 2 non key attribute is transitively depend on the Primary Key. Let's take a detailed look:
1. Customer (ID, Name, Address, Shipment ID) This means Customer Name, Customer Address and Shipment ID is functionally Dependent on Customer ID.
Customer ID__> Customer Name, Customer Address, Shipment ID. The Table will be produces as:
Customer
Customer ID | Customer Name | Customer Address | Shipment ID |
2. Shipment (ID, Item Description, Item Price, Shipped Quantity). This means Item Description, Item Price, Shipped Quantity is functionally dependant on Shipment ID.
Shipment ID__> Item Description, Item Price, Shipped Quantity
Item
Shipment ID | Item Desription | Item Price | Shipped Quantity |
3. Shipment (ID, Shipping Clerk ID, Shipping Date) This means Shipping Clerk ID, Shipping Date is functionally dependent on Shipment ID.
Shipment ID__> Shipping Clerk ID, Shipping Date
Shipment
Shipment ID | Shipping Clerk ID | Shipment Date |
Penn Health Supplies want to use a relational database to keep track of its PPE mask...
Use case diagram for Mail Order System Requirements(draw by use case diagram) This software system is developed to support mail order business operations. In particular software shall: - Keep track of sales (including orders, payments, and shipments). For each order a record shall be kept identifying the customer, the ZIP code, the salesperson, item ordered, the quantity, and amount due. - Record shall be kept for each customer who made a purchase in the past year. Such record shall include...
Cloud 9 - Continuing Case Sharon Gallagher and Josh Thomas have assessed the internal controls at Cloud 9 as being effective at an entity level. This means that, at a high level, the company demonstrates an environment where potential material misstatements are prevented or detected. Answer the following questions based on the information presented for Cloud 9 in the appendix to this text and the current and earlier chapters. You should also consider your answers to the case-study questions in...
Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...