Database Assignment 2 PDF

Preview

Summary

This is an Database Assignment BTEC Level 3...

Description

Database Assignment 2 Ethan

User Requirements:     

Two tables with appropriate attributes. Validation and verification processes. Input and output screens. Two data entry forms for patients and appointments. Test plan.

Purpose: There is an established doctors’ surgery in my local county, and they have asked me to develop a new appointment system for them. They want me to make a database for over 600+ people.

How will it help the client? It will help them a lot because I will be making something for them which they will need and is very important to them.

What type of database will be made? - The database I will be creating a relational database which will contain entities, relationships, and attributes. The advantages of this type of database is that the database itself will have reduced redundancy and consistency. It will also allow me to link specific tables to each other, allowing for a more detailed database for the doctor’s surgery. - A relational database is more expensive and time consuming to develop.

How will users utilize the database? - A webpage to view current appointments that are available including times and specific dates. - A user input form to enter their name, date of birth, address, and their phone number.

Hardware and software resources that will be used? - A working computer to develop and create the database. - A server to run the database. - Microsoft Access to develop and create the database. -

Book an Appointment First Name

Surname

Phone Number

Date of birth

We will get back to you as soon as possible with a date for your appointment! We will give the best dates we can.

Register First Name

Surname

Phone Number

Date of birth

Address

We will get back to you as soon as possible with a date for your appointment! We will give the best dates we can.

Database Testing: Database Test

Does the database work correctly?

Does it meet user requirements?

Does all data on database display correctly?

Is everything on the database formatted correctly?

Is the field size character working? Does it not have overflow?

Yes No

- This table will be complete once the database has been fully completed.

Example 2: Data Dictionaries of the table:

Date Full Name Date of Birth

Patient

Appointment

Time

Phone Number History Address

This is a one to many relationships, the patients entity is related to the appointment entity, this can be because one patient can be eligible for multiple appointments...