Database Design Project Proposal

Database Design 

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.

Use the following questions to guide you as you plan the needs and features 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?

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.

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.

Order a Unique Copy of this Paper

Essay Creek is an academic writing service provided to you by, a London-based company.

  • Experience
    Helping students successfully for 11 years.
  • Confidentiality & Security
    Be sure your information will be kept confidential due to our secure service.
  • Quality & Reliability
    8.5 out of 10 average quality score according to our customers' feedback. 97.45% of orders delivered on time.
  • Versatility
    478 active writers in 68 disciplines.
  • 100% money back guarantee
    You can always request a refund if you are not satisfied with the result.

Read more about us

Our team of writers is comprised of people with necessary academic writing skills and experience in various fields of study.

  • Skilled writers only
    We carefully choose writers to employ, paying attention to their skills and abilities.
  • Competence
    Your order will be assigned to a competent writer who specializes in your field of study.
  • In-depth knowledge
    Our writers know both peculiarities of academic writing and paper formatting rules.
  • Motivation
    We keep updated on results our writers show, motivating them to constantly improve their performance.

Read more about our writers

  • Testimonials
    Our clients' testimonials prove we're doing everything right.

Check for yourself

  • Sample essays
    The best way to understand how well our writers do their work is to view sample essays written by them.

View samples

  • Our Free Essay Tools
    Even more opportunities to improve your academic papers.

Bibliography Generator
Words to Pages Converter
Words to Minutes Converter
College GPA Calculator
Thesis statement generator