Reference no: EM133043700
CS312 DATABASE
DISCOUNT AUTOPARTS
Discount AutoParts is a small auto parts supplier with locations in several Accra-Tema metropolitan areas. The business is based on the idea of discount prices for auto parts that are always in stock or can be delivered within hours. The owners have decided to computerize their operations to allow them to better track their business and manage their inventories for just in time deliveries for sales. Data to be gathered for each customer sale includes invoice number, date, parts number, cost, retail price. Customer data is collected that includes basic contact information and vehicles owned, which includes vehicle make and model. For parts that must be delivered to the store to fulfill a customer purchase, a transfer request is created. Data associated with these transfers include tracking number, invoice number, date, parts number, origination location (store or warehouse) number, destination store number.
Discount AutoParts has contracted you as a Database Architect to assist in the computerization of their business. A Systems Analyst hired earlier had completed all assignments and at the data analysis stage.
You are to complete the database design by implementing Oracle 18c.
MINIPROJECT
1. Create fully normalized 3NF table designs for the system.
2. Populate tables with your data.
3. Suggest ways AutoParts Warehouse can use codes to simplify output, input, and data formats.
|
Significance of effective communication
: Please provide me with good research and detailed analysis on the following to include many in text citations / references.
|
|
Present all journal entries to be prepared
: Present all journal entries to be prepared, in proper format, in 20X2 in order to record all of the transactions related to the extended warranties of 20X1
|
|
Outline the potential causes of conflict
: Outline the potential causes of conflict that existed at WorldCom during Bernard Ebbers administration?
|
|
Management elements of volvo new production approach
: 1. Describe the management elements of Volvo's new production approach in human resource management perspective. What do you think might be positive or negative
|
|
Create fully normalized 3NF table designs for the system
: Create fully normalized 3NF table designs for the system - Suggest ways AutoParts Warehouse can use codes to simplify output, input, and data formats
|
|
What are the per unit manufacturing overhead costs incurred
: If 20,000 units are produced, what are the per unit manufacturing overhead costs incurred? If required, round final answer to two decimal places
|
|
Prime candidates for inclusion in the new selection
: Based on the materials you have compiled as part of the selection plan, you will determine which KSAOs are not being measured adequately in the current system.
|
|
Research stress reduction methods for workers
: Research stress reduction methods for workers as implemented in two different companies. For example, some companies have naptime or encourage its workers to le
|
|
How should Highland Laboratories account for its investment
: One of the other accountants disagrees, stating that the equity method is appropriate. How should Highland Laboratories account for its investment
|