1 / 12

Homework 7 Partial Key Populating the original PP tables with new data

Homework 7 Partial Key Populating the original PP tables with new data. BCIS 4660 Dr. Nick Evangelopoulos Spring 2012. Premiere Products, Star Diagram from ex. #6. Steps for HW7:. Delete all old records from OrderDetail. This will allow you to delete records in dimension tables.

liko
Download Presentation

Homework 7 Partial Key Populating the original PP tables with new data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Homework 7 Partial KeyPopulating the original PP tables with new data BCIS 4660 Dr. Nick Evangelopoulos Spring 2012 DO NOT COPY --CONFIDENTIAL

  2. Premiere Products, Star Diagram from ex. #6 DO NOT COPY --CONFIDENTIAL

  3. Steps for HW7: • Delete all old records from OrderDetail. This will allow you to delete records in dimension tables. • Delete all old records in the 5 original tables: Rep, Customer, Part, Order, OrderLine. • Modify the design of some tables to make them ready for new data entry. • Enter new data into Rep, Customer, Part, Orders, and OrderLine, as instructed according to your team #. • Generate table views, printouts, and diagrams as explained in the assignment. DO NOT COPY --CONFIDENTIAL

  4. Delete all old records • Delete all records from OrderDetail first. • Delete data in Customer, Rep, Part, Orders, OrderLine. • Do not delete records in Time table DO NOT COPY --CONFIDENTIAL

  5. Modify the REP design • Open REP table in design view and add a new field called Territory. Eventually you will have to reflect this change on a modified make-table query that produces an OrderDetail fact table that includes territory information, but you can postpone this for exercise #8. DO NOT COPY --CONFIDENTIAL

  6. Modify the design of other tables • You may have to modify the design of other tables. For example, PartNum used to be a text field of size 4; This size is inadequate to accommodate the new part numbering scheme, if you decide to adopt a format such as HWC001, etc. Changing the size to 6 will allow you to enter part numbers of this new format. DO NOT COPY --CONFIDENTIAL

  7. Enter new transactional data following your team’s instructions • The data shown below are an example of the first row of each table for Team #1. Make sure you follow your team’s range of values. Populate Rep, Customer, Part, Orders, and OrderLine. DO NOT COPY --CONFIDENTIAL

  8. Example data entry: Part • The data shown below are an example of how to populate the Part table. The example assumes you are team #13. Please apply the data that correspond to your own, real team number!!! Enter part numbers as instructed on slide 25 of the assignment PowerPoints. For team #13, follow an HWR000 pattern as shown here Make up prices For team #13, all parts are located in Warehouse M Make up on-hand quantities Make up part descriptions For team #13, all parts belong to Class HW DO NOT COPY --CONFIDENTIAL

  9. Example data entry: Customer • The data shown below are an example of how to populate the Customer table. The example assumes you are team #13. Please apply the data that correspond to your own, real team number!!! Make sure the reps are the two reps you are entering in the Rep table Enter customer numbers as instructed on slide 25 of the assignment PowerPoints. For team #13, follow a 1300 pattern as shown here Make up 20 addresses Make up 20 customer names For team #13, all addresses should be in TX DO NOT COPY --CONFIDENTIAL

  10. Modify your query that selects Fact Table attributes • This task is part of assignment #8 DO NOT COPY --CONFIDENTIAL

  11. Modified Star Diagram • Your modified Star Diagram that shows dimension Rep having a Territory attribute is shown here. You may report this as your Star Diagram for Ex #7 OR… DO NOT COPY --CONFIDENTIAL

  12. Final Star Diagram(ready for Exercise #8) • …you may decide to be proactive and prepare the Star Diagram you need for exercise #8. • Delete all relationships between Fact and Dimensions • Update your Make-Table query to include attribute Territory • Run the Make-Table query • Rebuild the Star schema relationships DO NOT COPY --CONFIDENTIAL

More Related