Trust dental orthodontics & ComfortableHousing Lease database design & implemenation

There are the following tasks for this project

Database general concepts

In your presentation/report explain the followings:

• What is a database?
• Flat file database, its advantages and disadvantages and the circumstances in which flat file database may be used giving an example
• Relational database, its advantages and disadvantages and the circumstances in which relational database may be used giving an example
• Differences between flat file and relational database
• Entity type and entity giving examples
• Attributes giving examples
• Types of relationships giving examples

Trust dental orthodontics database design ERD & implementation

The table below lists a part of dentist/patient appointment data of Trust dental orthodontics. A patient is given an appointment at a specific time and date with a dentist located at a particular surgery. On each day of patient appointments, a dentist is allocated to a specific surgery for that day. There are 5 surgeries under the management of Trust dental orthodontics. Each surgery has a surgeryNo, Address, and contactNo. TDO has more than 500 registered patients and 25 staff members. When a patient register, TDO collects patient’s personal details including medical history and allergies. TDO keeps staff personal details including NI number and qualification. Staff is allocated to a surgery however they may have to work in other 4 surgeries as well. Same applies to patients.

staffNo	dentistName	patNo	patientName	Appointment Date      time	surgeryNo
S100	Tony Smith	P100	Gillian White	12-Sep-17       10:00	S15
S100	Tony Smith	P105	Jill Bell	12-Sep-17       12:00	S15
S124	Helen Pearson	P108	Ian MacKay	12-Sep-17       10:00	S10
S124	Helen Pearson	P105	Jill Bell	14-Sep-17       14:00	S10
S103	Robin Plevin	P108	Ian MacKay	14-Sep-17       10:00	S15
S103	Robin Plevin	P110	John Walker	15-Sep-17       18:00	S13
S105	Sheena Shah	P101	Anu Mathew	17-Sep -17      11:30	S10

When the receptionist book appointments for patients appointment date has to be the date appointment booked or a future date. Patients cannot register without a valid address and a valid visa status. Ex: Patients who are on holiday visa cannot join the surgery

ComfortableHousing Lease database design ERD & implementation

A small part of ComfortableHousing Lease records are given below. The clients have to register first by giving their personal details to rent a property via ComfortableHousing Lease. A client can rent a registered property more than once but cannot rent more than one property at any one time. The lease is for a period of one year and if a client wants to rent the same property for another year they record it as a new lease. The company keeps records of the properties as well as owners. Some owners may have more than one property.

ClientNo	ClientName	PropertyNo	PropertyAddress	PropertyType	RentStart	RentFinish	Rent	OwnerNo	OwnerName
CR10	John Kay	PG4	6, Honeypot Lane, Kingsbury	3 bed Semi Detached	01/07/2015	30/06/2016	1550	PO01	Tim Murphy
CR10	John Kay	PG16	34b, College Road, Hayes	3 bed Flat, 2nd Floor	01/07/2016	31/06/2017	1200	PO02	Tony Shaw
CR56	Aline Stewart	PG4	6, Honeypot Lane, Kingsbury	3 bed Semi Detached	01/08/2013	31/07/2014	1500	PO01	Tim Murphy
CR56	Aline Stewart	PG36	357, Kenton Road, Harrow	3 bed Semi Detached	01/08/2014	31/07/2015	1550	PO02	Tony Shaw
CR56	Aline Stewart	PG16	34b, College Road, Hayes	3 bed Flat, 2nd Floor	01/08/2016	31/07/2017	1250	PO02	Tony Shaw
CR 20	Frank Stolte	PG4	6, Honeypot Lane, Kingsbury	3 bed Semi Detached	01/09/2017	31/08/2018	1650	PO01	Tim Murphy
CR 18	George Goldston	PG16	34b, College Road, Hayes	3 bed Flat, 2nd Floor	01/08/2017	31/07/2018	1350	PO02	Tony Shaw

ComfortableHousing Lease has certain rules to follow:

• Clients have to be over 19 to register and rent properties
• They should have an income such as a permanent job or a business
• The properties should have a gas safety certificate as well as Energy Proficiency certificate (EPC)

Get Project Solution by contacting us

- via WhatsApp: +92-324-7042178

- via email: codelogixstudio@gmail.com