Reference no: EM132232778
World BMW is a BMW dealership located in Westlake Village, California. World BMW requires a database to manage their inventory of BMW’s. The following is a description of the process.
1. Using a shipping document provided by the BMW manufacturer, the World Sales Manager enters the new autos that are received at the dealership onto World’s BMW Inventory Database and also enters a Target selling price for each vehicle.
2. When a BMW is sold the World Sales Secretary enters the Actual selling price for the auto onto the BMW Inventory Database.
3. Every morning a report is produced from the BMW Inventory Database that lists the BMWs that are “Available for Sale” along with the Target selling price. This report goes to all the World Sales staff.
4. Every month an analysis report is produced from the BMW Inventory Database that lists all the BMWs sold during that month & compares the Actual selling price to the Target selling price ( Target Versus Actual %). This report goes to the World Sales Manager.
5. At the end of the year, all sold BMWs are deleted from the BMW Inventory Database and added to the “Archive Database” which retains the historical records.
Please develop a Context Diagram and Level 1 Dataflow Diagram for the World BMW Inventory Process.
1. Use the proper symbols and labels.
2. Narratives are not required.
3. A description of data in Dataflows & DataStores is not required.