Assignment: Database Design Project Proposal
Review the 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.
Use the following questions to guide you as you plan the needs and features for your database.
• What is the purpose of the database? Why is it needed? What should it do?
• Who are the users and what are their information needs?
• What are the questions that the system should answer?
• What type of input data is going to be available to the database?
• What kind of information should be stored in the database?
Then, write a one-page, proposal that addresses the following:
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.
Project Description
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.
Examples for your 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.
Format your assignment according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.