MGT4058 Spring 2024 Project Instructions

docx

School

University Of Georgia *

*We aren’t endorsed by this school

Course

4058

Subject

Management

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by MagistrateTeamZebra24

MGT 4058 Project Description Spring 2024 This group project will simulate the system design and implementation experience of a typical software consulting firm. Assume that you have been hired to "build a solution" for a client's pressing business problem. During the project, you will analyze user requirements, develop and document a database and data warehouse design to support the user requirements, and implement the project in MySQL. This document provides a full description of the project. I may add a few extra clarifications for deliverables as the class progresses. PROJECT OPTIONS You can select your own topic (within reason). Obviously, a database system for managing a teacher's grade book is too trivial; a simple spreadsheet would be a much more logical tool. At the other extreme, a database to track everything in the Department of Defense is too ambitious for the scope of this course. A few possible ideas are: 1. Trip Scheduling Target Client: A travel agency. System Users: Multiple employees working with potential customers. Agency owner interested in the financial performance of individual agents as well as the entire agency. Key Tasks: Flight, cruise and hotel searches and bookings. Billing/commissions from airlines, etc. Payroll. Customer billing. 2. Production Scheduling Target Client: Manufacturing or construction firm. System Users: Project leader. Manufacturing crew. Key Tasks: Inventory control including re-ordering, lead times, etc. Project cost analysis (actual versus budget). Quality control. Crew scheduling. 3. Home Sales Target Client: MLS (Multiple Listing Service) providing a database of all available homes in a city market to the real estate agents representing either the home sellers or buyers. System Users: Data entry personnel. Company manager. Real estate agents. Key Tasks: Management of property inventory. Billing. Payroll. 1

4. Apartment Finders Target Client: Middleman company that attempts to match tenants with available apartments (or other rental properties). System Users: Employees. Tenants (self-directed search of property database). Key Tasks: Property search. Property inventory management. Billing. Employee timesheets. Payroll, including commissions. 5. Create Your Own You are not required to build your database for a real client, but you are certainly free to do so if you wish. The advantages of having a real client are: (1) the project may lead to a summer internship, a long-term job offer, or another potential job; (2) the client will likely be willing to write you a letter of recommendation that will be of great value during your job search; (3) it is very educational to see firsthand how clients view business problems and systems solutions; (4) it is inspiring to see a happy client when you deliver the results; and (5) it is always easier to debug a database at 3:00 a.m. if you know that a real person will appreciate your efforts. The greatest disadvantage of building your database for a real client is that you must adjust to accommodate their system needs and expectations. With a hypothetical client, you can be as creative as you want to be. PROJECT COMPLETENESS I hope this project will provide you with an enjoyable framework for learning about database design/implementation and the basics of data warehousing. I do not expect your database to be as complex as the real database can be. Instead, I would like you to focus on a core piece of the database (e.g. 5-7 entities ) that can be developed as fully as possible within the limited time we have. At the same time, I want you to think through what additional features your project can benefit from long-term and what you think is needed to implement them in practice. PROJECT GRADING Your grade will be calculated using the formula below: Final Grade for Deliverable # = = Project grade x 70%+ Project grade x 30% x (TOTAL STUDENT PEER SCORE/ TOTAL SCORE) Deliverable 1 Proposal 40% Deliverable 2 SQL Database 20% Deliverable 3 Data Warehouse 20% Class Presentation 20% Total 100% 2

DELIVERABLES Note:  Your file name for all your submissions must be in the following format on Canvas (unless other requirements are specified): Team x – Project Name . For example, Team 1 – XYZ Bookstore.  Please submit your work for every Deliverable on Canvas under Assignments. The exact due date will be announced in class and on Canvas in the Announcements section as the course progresses.  Each student must submit a confidential evaluation of the other members of his or her group as a part of each Deliverable submission. This requires an individual submission from each team member in addition to each Deliverable submission. DELIVERABLE 1 PART 1 Create a one/two-page description of your project. Your description should contain: 1. Brief introduction of the project organization (please clearly state if it’s a real project or an imaginary project); 2. Scope of your project: What kinds of business functions are you going to cover? 3. Goals of your project: Who are the intended end-users? What benefits does the organization obtain by implementing the system? 4. Thinking about a name (e.g., XYZ Bookstore) for your project, and use this name as the title for your project description. PART 2 1. Prepare Business Requirements that you will use as a base to develop Conceptual model for your database. 2. Create a conceptual model for your project idea Your conceptional model should include the ER-diagram for your project completed in ERDPlus. This is a critical design step in your database project. 3. Include at least 5 entities in your ER-diagram. PART 3 1. Develop a relational schema based on the ER-diagram. 2. You must create a relational schema using ERDPlus. 3. Critique: Present any problems or weaknesses with your current design or database. DELIVERABLE 2 PART 1 1. Attach your updated ER-diagram and relational schema. Use the instructor’s feedback on Deliverable 1 to make all necessary corrections in the ER-diagram. You can get points back on Deliverable 1 if you address all comments by instructor and make all necessary corrections to ER-diagram and Relational Schema. 2. Generate codes to create all tables for your database based on your updated relational schema for the Deliverable 1 before you start working on the code. 3

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

3. Submit all the code that you used to generate your tables as a part of the Deliverable 2 submission. This should include all create table and insert into statements (5-6 rows per table should be enough). PART 2 1. Each team is required to develop 6-8 SQL queries designed to solve real business questions for the organization you chose as your project idea. The query should demonstrate your knowledge of SQL. 2. Each query should be accompanied by a business justification. You should be able to explain how this query is aligned and helps you to accomplish database project goals stated in your proposal. 3. Copy the texts of your codes in part 2 of the Deliverable 2 . DO NOT submit screenshots of the codes. We should be able to copy-paste and re-run the queries you created to evaluate the performance. DELIVERABLE 3 PART 1 1. This is the final part of the project. As a part of this deliverable, you will need to make all necessary changes to the previous Deliverables based on the instructor’s feedback. Your submission should contain the final version of your project. PART 2 2. Discuss the subject of analysis for the data warehouse. 3. Include the dimensional schema (created using ERDplus). 4. Explain the aggregation level for each fact table of the dimensional schema. 5. Discuss ETL steps needed to implement the data warehouse: Provide one example of extract/ transform/ load activity applicable to your data warehouse (e.g. we will need to extract data from table A and B to create dimension Z). The actual data warehouse implementation is NOT required for this deliverable. 6. Please be very precise in your answers. Use bullet points for the steps if needed. 7. Keep your answers short. PROJECT PRESENTATION 1. Create a short presentation (15 minutes in total : 10-minute presentation plus 5-minute Q&As) of your project to the class. You are expected to have an interactive demonstration of your SQL codes prepared in Deliverable 2 based on your SQL database and a short overview of the data warehouse design that you consider using. The order of presentations will be determined by a drawing done in-class. 4

MGT4058 Spring 2024 Project Instructions

Related Documents