Database Assignment | Homework Help Websites

a. ER Diagram.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

b. All schema before and after normalization.

c. All SQL statements of:

· creating tables

· inserting data in tables

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

· queries.

5. Screenshots from MySQL (or any other software you use) of all the tables after population and queries results.

6. You are advised to make your work clear and well-presented, marks may be reduced for poor presentation. This includes filling your information on the cover page.

7. You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.

8. Late submission will result in ZERO marks being awarded.

9. The work should be your own, copying from students or other resources will result in ZERO marks.

10. Use Times New Roman font for all your answers.


II. Project Ideas:

Project 1

Online Library Management system

This is supposed to develop a database to manage online library management system (A student and faculty can issue books). Your product should contain information about courses, students, teachers, Departments Book Id, book names, authors, No. of copies, number of days and Details of Fine.

Each Book has id, title, author, number, submission date and time, duration, issue date

You should store an id, name, E-mail for each student & teachers.

Each teacher has id, name, department name.

For new students enrolled to university and you have to store information like Name and ID.

Database should also store who issues that book and when and duration. Details of Fine (when the book is not returned at a due date) is also stored.

SQL Queries:


1. Write a query to find which student has issued the Book Id =1011 in the last 3 months.

2. Find the students who submitted a book after the deadline in “computer science” course.

3. List the name and email for all students who supposed to return the book, but they did not.

4. Show the total book of each course that a student has taken.

5. Show the students who has issued that book and when and duration. Detail of Fine (when the book is not returned at a time).


Project 2

Online Hospital Management System (OHMS)

The project “Online Hospital Management System” is aimed to develop to maintain the day-to-day state of admission/discharge of patients, list of doctors, reports generation etc. It is designed to achieve the following objectives:

1. To computerize all details like patient details & hospital details.

1. Scheduling the appointment of patient with doctors to make it convenient for both.

1. Scheduling the services of specialized doctors and emergency properly so that facilities provided by hospital are fully utilized in effective and efficient manner.

1. If the medical store issues medicines to patients, it should reduce the stock status of the medical store and vice-versa.

1. It should be able to handle the test reports of patients conducted in the pathology lab of the hospital.

1. The inventory should be updated automatically whenever a transaction is made.

1. The information of the patients should be kept up to date and their record should be kept in the system for historical purposes.


SQL Queries:

1. Find all the patients who are admitted in the hospital on a particular date.

2. Find the patient who did not pay for the test report.

3. Find the list of doctors who has specialization in Surgery.

4. Show the total number of doctors in each department of the hospital.

5. Show the total amount each department of hospital received on a particular date.


Project 3

Database System for a Blood Bank Organization

Consider a database system for a Blood Bank Organization. The data requirements are summarized as follows:


1. Donors

1. Donors are tracked by a unique donor ID.

2. Personal information includes first name, last name, phone number, Date of Birth and sex.

3. The combination of the Donor’s first and last name must be unique.

4. Donor’s sex is not a mandatory field.

5. Donors must be at least 17 years of age.

6. Donors can donate at any clinic any number of times.


2. Blood:

1. Blood is tracked by a unique ID.

2. Blood Type is how the blood is categorized: (A+/A-, B+/B-, AB+/AB-, O+/O-, N/A).

3. N/A refers to blood that has not been processed yet.

4. Status refers to the state of the blood: (pure, N/A, impure).

5. N/A refers to blood that has not been processed yet.

6. Donor_id is a FK which references the ID of the Donor.

7. Blood specimens must have a donor.

8. Clinic_id is a FK which references the ID of the Clinic that stores the blood.

9. Blood specimens must be stored at one clinic.

10. Donate Date is the date the blood sample was received.


3. Clinic:

1. Clinics are tracked by unique clinic ID.

2. Each clinic has a name and location.

3. The combination of the clinic’s name and location must be unique.


4. Employees:

1. Employees are tracked by unique Employee ID.

2. Clinic_id is a FK which references the Clinic ID which they work at.

3. Employees must work at a single Clinic.

4. Personal information includes Fname, Lname and sex.

5. The combination of an employee’s first and last name must be unique.


SQL Queries:

1. List the first and last name of all donors whose blood type is O+.

2. List names and location of clinics that store a blood of type B+.

3. Find the names of donors whose age is above 30 years and have donated since 1/1/2000.

4. List the names of employees who are working in clinics which do not have a blood of type A-.


III. Your Project:


Title of Your Project

A. Design & ER Model

B. Normalize the Tables (in 3NF at least)

C. Create the Normalized Tables and Populate them with at least 5 Rows

D. Write the sample requested Queries & Execute them


Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Excellent work. Looking forward to working with your in the future.
Customer 463467, November 11th, 2022
Customer 463001, June 21st, 2022
Business and administrative studies
Good work.
Customer 462275, June 5th, 2022
well done
Customer 452441, April 14th, 2022
Thank you!
Customer 454299, April 21st, 2020
Business and administrative studies
Outstanding work!!
Customer 460073, August 4th, 2022
Great work
Customer 463995, April 3rd, 2023
Good work. Looking foward to future contributions.
Customer 463463, October 29th, 2022
Business and administrative studies
Good work.
Customer 458115, May 24th, 2022
Good work.
Customer 459817, June 16th, 2022
Instructions followed.
Customer 462823, April 13th, 2022
English 101
Good paper.
Customer 458101, April 4th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat