Revenue Cycle Assignment Part 1 Required: . . Select a company from the list below, or a retail store of your choice. Based on the narrative, your team should construct a comprehensive REA diagram describing your company's database (revenue cycle only). You may repeat a box for an individual entity if necessary to make your drawing neat. The owner would like for you to consider that, eventually, as new stores are opened, he/she will have store managers in each store that will perform the tasks he/she now performs. As a result, the system should be planned to always store information about the employee associated with transactions, whether that employee enters information, performs a task (such as delivery) or formally authorizes the transaction. Prepare the context diagram and the level 0 DFD. Corrections and comments from the first stage should be implemented in subsequent stages. All students are required to equally participate in the project and may be called upon to present any part of the project. If you identify more resources/events/agents then are needed NO points will be deducted! . . about the employee associated with transactions, whether that employee enters information, performs a task (such as delivery) or formally authorizes the transaction. Prepare the context diagram and the level O DFD. Corrections and comments from the first stage should be implemented in subsequent stages. All students are required to equally participate in the project and may be called upon to present any part of the project. If you identify more resources/events/agents then are needed NO points will be deducted! . Davenport Customized Computers, Inc. (DCC) builds customized computers and related equipment for clients throughout the United States. DCC targets small businesses and at-home workers. Customers can order over the Internet and DCC will build and ship the finished product when completed, usually within two working days. DCC keeps up with all of the latest innovations. DCC also offers a variety of pre-built computers ready to ship within one hour of an order. DCC does not produce hardware components; rather, it orders all sub-components from reliable vendors and assembles the electronics at a plant located in Minneapolis, Minnesota. While computers ordered from DCC are noted for their excellent quality, DCC also prides itself in offering the best customer service in the world. Currently, DCC employs approximately 1,800 full-time employees. DCC's five year plan is to increase its workforce to 10,000 full-time employees and build four additional assembly plants across the United States. ORE ". here to search DELL 1 / 2 Part 2 The second stage of the project requires students to convert their REA diagram into tables. 1. In this step you need to convert your REA diagram into tables. 2. You should submit a list of all your tables, the attributes in each table and primary and foreign keys for each table. Example: Table Name Other Attributes Primary Key Sales Number Foreign Key Customer Number, Employee Number Sales Date of Sale, Time of Sale, Total Amount of Sale Customer ORI here to search Revenue Cycle Assignment Part 3 The third stage of the project requires students to implement their logical data model in MS- Access. Please, carefully read the instructions below before you start working on your project. 1. Create the tables from "Project Stage 2" in Microsoft Access. In each table, define the primary key and foreign keys. For each attribute, define the data type. 2. Establish relationships between all the tables you created (based on your design). Make sure that you enforce the referential integrity in all your relationships. 3. Create at least three forms, one of which should be a multiple table form. Describe the function of the form, who would use it and its purpose. For each form, there should be at least one validation rule and a corresponding validation text. I would also like to see some default value entrees and captions in each form. Use the forms to enter data into your database tables. 4. Populate your tables with fictitious data entries; you should sufficiently populate your tables so that you can demonstrate your design (i.e. so that something meaningful appears on your reports). Each event table should have 25 records. Cash table can have 8 records. Inventory table should have 100 records. Employee and Customer tables can have 25 records. Font F Paragraph Styles 5. Create queries and explain why these queries are important for managers/decision makers. You should have enough queries to construct an income statement report and a ratio report. Queries will be multiple-table and perform calculations as necessary. Your queries will be evaluated based on the above requirements. 6. Create three reports for management decision makers; describe what benefits these reports provide for decision makers, and how often they will be used. One of your reports should display a summary value, and a chart illustrating the data. You may include the list that supports the summary value. One report should be an Income Statement. The third report should be a ratio report of 5 ratios related to the Revenue Cycle. The report should include interpretation of the ratio as to business operations. You may use text boxes to include ratio interpretation on the report. 7. Describe any additional (for extra credit) work that you did. 8. Summarize what benefits your company gained from adopting the database approach (for that purpose you can assume that prior to your implementation, your company had a computerized/manual accounting system) Revenue Cycle Assignment Part 1 Required: . . Select a company from the list below, or a retail store of your choice. Based on the narrative, your team should construct a comprehensive REA diagram describing your company's database (revenue cycle only). You may repeat a box for an individual entity if necessary to make your drawing neat. The owner would like for you to consider that, eventually, as new stores are opened, he/she will have store managers in each store that will perform the tasks he/she now performs. As a result, the system should be planned to always store information about the employee associated with transactions, whether that employee enters information, performs a task (such as delivery) or formally authorizes the transaction. Prepare the context diagram and the level 0 DFD. Corrections and comments from the first stage should be implemented in subsequent stages. All students are required to equally participate in the project and may be called upon to present any part of the project. If you identify more resources/events/agents then are needed NO points will be deducted! . . about the employee associated with transactions, whether that employee enters information, performs a task (such as delivery) or formally authorizes the transaction. Prepare the context diagram and the level O DFD. Corrections and comments from the first stage should be implemented in subsequent stages. All students are required to equally participate in the project and may be called upon to present any part of the project. If you identify more resources/events/agents then are needed NO points will be deducted! . Davenport Customized Computers, Inc. (DCC) builds customized computers and related equipment for clients throughout the United States. DCC targets small businesses and at-home workers. Customers can order over the Internet and DCC will build and ship the finished product when completed, usually within two working days. DCC keeps up with all of the latest innovations. DCC also offers a variety of pre-built computers ready to ship within one hour of an order. DCC does not produce hardware components; rather, it orders all sub-components from reliable vendors and assembles the electronics at a plant located in Minneapolis, Minnesota. While computers ordered from DCC are noted for their excellent quality, DCC also prides itself in offering the best customer service in the world. Currently, DCC employs approximately 1,800 full-time employees. DCC's five year plan is to increase its workforce to 10,000 full-time employees and build four additional assembly plants across the United States. ORE ". here to search DELL 1 / 2 Part 2 The second stage of the project requires students to convert their REA diagram into tables. 1. In this step you need to convert your REA diagram into tables. 2. You should submit a list of all your tables, the attributes in each table and primary and foreign keys for each table. Example: Table Name Other Attributes Primary Key Sales Number Foreign Key Customer Number, Employee Number Sales Date of Sale, Time of Sale, Total Amount of Sale Customer ORI here to search Revenue Cycle Assignment Part 3 The third stage of the project requires students to implement their logical data model in MS- Access. Please, carefully read the instructions below before you start working on your project. 1. Create the tables from "Project Stage 2" in Microsoft Access. In each table, define the primary key and foreign keys. For each attribute, define the data type. 2. Establish relationships between all the tables you created (based on your design). Make sure that you enforce the referential integrity in all your relationships. 3. Create at least three forms, one of which should be a multiple table form. Describe the function of the form, who would use it and its purpose. For each form, there should be at least one validation rule and a corresponding validation text. I would also like to see some default value entrees and captions in each form. Use the forms to enter data into your database tables. 4. Populate your tables with fictitious data entries; you should sufficiently populate your tables so that you can demonstrate your design (i.e. so that something meaningful appears on your reports). Each event table should have 25 records. Cash table can have 8 records. Inventory table should have 100 records. Employee and Customer tables can have 25 records. Font F Paragraph Styles 5. Create queries and explain why these queries are important for managers/decision makers. You should have enough queries to construct an income statement report and a ratio report. Queries will be multiple-table and perform calculations as necessary. Your queries will be evaluated based on the above requirements. 6. Create three reports for management decision makers; describe what benefits these reports provide for decision makers, and how often they will be used. One of your reports should display a summary value, and a chart illustrating the data. You may include the list that supports the summary value. One report should be an Income Statement. The third report should be a ratio report of 5 ratios related to the Revenue Cycle. The report should include interpretation of the ratio as to business operations. You may use text boxes to include ratio interpretation on the report. 7. Describe any additional (for extra credit) work that you did. 8. Summarize what benefits your company gained from adopting the database approach (for that purpose you can assume that prior to your implementation, your company had a computerized/manual accounting system)