Review the Final Project Description below and begin to plan your database design. The first step to any database design is to determine its purpose and to define how it will be used. This week, you must submit your Database Design Project Proposal that explains what kind of database you will design, the type of information your database will contain, and the type of information output for your database.
1. What is the purpose of the database? Why is it needed? What should it do?
2. Who are the users and what are their information needs?
3. What are the questions that the system should answer?
4. What type of input data is going to be available to the database?
5. What kind of information should be stored in the database?
A description of the problem domain (written using terminology that a user of the system would use; no need for technical database terminology.)
Choose a domain with which you are familiar. Your domain should be different than examples provided in the textbook and in class.
Identify a set of requirements for a system that is appropriate for your domain. If you wish, you may choose an appropriate sub-set of a larger domain.
Final Project Description
Final project is to develop a database from the ground up, including the conceptual modeling design, entity relationship diagram (ERD), logical modeling design, relational schema, physical modeling design, Structured Query Language (SQL), Database Management Systems (DBMS), and implementing the DBMS. Your project should be original work. Any outside sources should be cited in an APA-style reference page. The Gangwish Library Online provides excellent sources.
Examples for your final project
Human Resources (HR) Employee Management System: This system allows HR staff to manage information about each hired employee.
Information Services (IT) Asset Management System: This element allows the IT staff to maintain information about the computer hardware, software, and peripherals owned by the organization.
Departmental Intranet Management System: This system allows a liaison from each department to update the individual departmental information page. This reduces the need for IT staff to make updates to the intranet every time a department makes a change.
College Database Project: A college contains many departments that each offer any number of courses. Each department employs many instructors, but an instructor can only work in one department.
Hospital Management System: A full description of the personal patient detail, phone number, and updated health history records. The doctor handles patients, and one doctor can treat more than one patient. Each doctor has a unique ID. Doctor and patients are related. Patients can be admitted to the hospital and are assigned a hospital room. There are patient rooms, operation theaters, and ICU rooms in the hospital.
Hotel Management System: A hotel is a hive of numerous operations including, front office, booking and reservation, banquet, finance, HR, inventory, material management, quality management, security, energy management, housekeeping, customer relationship management (CRM), and more. The hotel has different categories of rooms that each have different prices. Some hotel employees manage the services offered to customers. The customer can book a room either online or by cash payment at the hotel.