![](https://www.uberessays.org/wp-content/uploads/2017/12/button-2.png)
Coursework Request and Details
You need to work in teams of 2 or 3 students and use the knowledge and techniques developed in class to plan, analyze, design, and prototype a relational database project.
The students need to create functional Database Prototype using Microsoft SQL Server Express covering most the topics presented during the semester as the following:
• Business Rules and Data Modeling
• The Relational Database Model
• Entity Relationship (ER) Modeling
• Normalization of Database Tables
• Structured Query Language (SQL)
• Database Design
Furthermore, the students should provide with the functional database prototype, a project report describing their project in terms of context, business analysis and functionality, and the SQL code used to produce and test the prototype.
The following is a list of possible projects to choose from. The students are encouraged to peruse ideas that they may generate themselves for the project. However, they need to have equivalent complexities with the projects given below. They need to discuss with the course instructor and have his validation with respect to their choice.
As the course instructor, I shall act as a representative of the company which commissioned the analysis, design and development of the relational database project. Each group shall act as the team from the commissioned company to do the work of database analysis and design. Members of the group may discuss with the instructor, business rules and other requirements of their project, as work progresses.
Suggested projects:
• Banking Record System
• Bookshop Management System
• Bus Reservation System
• Hotel Management System
• Payroll Management System
• Sales Management System
• Purchasing Management System
• Student Database Management System
• Supermarket Cashier System
• Inventory and Batch Production System
• Inventory and Maintenance System
Course Work Deliverables
Note that the project has the following deliverables, with the dates as indicated below. Feedback may be given on deliverables. However, an overall grade shall be attributed for the project, at the end, based on all the deliverables. Please note that deadlines are very important and count towards your final project grade.
• A System Analysis and Proposal Document. This document is due on Thursday March 17th. It needs to be submitted in PDF format on Blackboard (an appropriate assessment item shall be crated for it). Feedback shall be given for this item, but not a grade.
The following is the outline for the document: It needs to be developed and submitted as a mid- way report, to give the specifications for the proposed project and to prove that you have acquired the necessary comprehension to complete the project. Should consist of 10-15 pages.
1. Introduction and Project Context
2. Project Research You need to discuss the problem domain and do research on the Internet for any similar systems.
3. Business Analysis and Specification
4. Describe and discuss the business rules and the roles played by the potential users of the system, their different points of views, ..etc.
5. Describe the applications that are planned to be developed and used in conjunction with the database.
6. 6. Give a detailed Entity Relations Model for the system.
7. Conclusion
Conclude and give an assessment of your progress and discuss any obstacles you
![](https://paperwritings.us/wp-content/uploads/2023/08/B2.png)
![](https://www.paperwritings.us/wp-content/uploads/2020/03/button_we-write-all-papers-from-scratch-to-ensure-plagiarism.png
)