Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Normalization table of hospital management system

19/11/2021 Client: muhammad11 Deadline: 2 Day

Instructions

1. In this file, you will find a list of database project ideas. You must choose one of them to design and implement

1. This project worth 10 marks, will be distributed as in the following:

1. Design the database, following an ER model. (4 marks)

1. Normalize the tables ( each table should be in 3NF at least) (2 marks)

1. Use MySQL or any other database to create the normalized tables and populate your tables with at least 5 rows. (2 marks)

1. Execute the sample requested queries. (2 marks)

1. Each student has to submit one report about his/her chosen Project via the Blackboard , containing the following:

2. ER Diagram.

2. All schemas before and after normalization.

2. All SQL statements of:

2. creating tables

2. inserting data in tables

2. queries.

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

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, and 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) are also stored.

SQL Queries:

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

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

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

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

1. 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.

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

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

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

1. 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.

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

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

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

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

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

2. Blood:

1. Blood is tracked by a unique ID.

1. BloodType is how the blood is categorized: (A+/A-, B+/B-, AB+/AB-, O+/O-, N/A).

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

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

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

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

1. Blood specimens must have a donor.

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

1. Blood specimens must be stored at one clinic.

1. DonateDate is the date the blood sample was received.

3. Clinic:

1. Clinics are tracked by unique clinic ID.

1. Each clinic has a name and location.

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

4. Employees:

1. Employees are tracked by unique Employee ID.

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

1. Employees must work at a single Clinic.

1. Personal information includes Fname, Lname and sex.

1. 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+.

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

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

1. 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

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Homework Guru
Custom Coursework Service
Professor Smith
Online Assignment Help
ECFX Market
Maths Master
Writer Writer Name Offer Chat
Homework Guru

ONLINE

Homework Guru

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$33 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$38 Chat With Writer
Professor Smith

ONLINE

Professor Smith

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$24 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$24 Chat With Writer
ECFX Market

ONLINE

ECFX Market

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$34 Chat With Writer
Maths Master

ONLINE

Maths Master

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$28 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Brian herbert net worth - Action linking and helping verbs ppt - Research - Infosys campus connect study material ppt - Windshield Survey - Psy 410 week 5 programmatic assessment - Stute logistics ag & co kg - 10-1.5 tap drill size - Discussion - The unconscious is best defined as ideas, thoughts, and feelings ________. - DISCUSSION - The good earth characters - A well insulated heat exchanger is to heat water - Connect accounting chapter 8 homework answers - Brene brown tasc - 0.4 is 10 times as much as - When a merchandising company sells inventory it will - Certificate 4 in plumbing - Dynisco pressure transducer manual - Ashdown ingram coffs harbour - Ethics - Research paper - Ensure 'audit account lockout' is set to 'success and failure' - Why was moshe the beadle important to elie wiesel - Food Safety Discussion - Before you know it john bargh pdf - Gcu mission and general education competencies - Vermont teddy bear case study - People and culture rmh - Bouncing ball experiment lab report - Abiotic factors in the grand canyon - Management - General tenancy agreement pdf - What is the formula for percent deviation - Questions to ask about pop art - PS490 Assignment 8 Research Proposal - Parts of a sewing machine worksheet - Difference between intrinsic and extrinsic motivation ppt - David cheesewright net worth - BusinessEthics: JOurnalARticlAnalysis 5:Pick one of the following terms for your research: Moral philosophy, justice, white-collar crime, differential association, or powe - Classics of western philosophy 7th edition - Iron jawed angels will the circle be unbroken lyrics - Comin thro the rye analysis - Titration of vinegar and sodium hydroxide - Redesign and re-warding PPT - Assignment 1 reviewing research and making connections - Why does judge taylor appoint atticus - Bibl 104 bible dictionary project - Culture Connection and Patient Safety - Operational acceptance testing explain with example - What does friedman say lincoln's toughest decision was as president - Does bianca die in othello - The subpolar low polar front is - Argument essay - Student project evaluation form - Uk driving licence template photoshop free - Evidence-Based Project - Floreat dental stefan kolm - Paper on COSO framework - Marketing - Icity bcu ac uk - Fundamentals of computer Science (learning Java) - Onlinenationaledu - Bell case interview - Cass pennant net worth - Example of a 4 mat review paper - Gartner news and insights - How to predict lotto numbers - How to increase customer accessibility in capsim - PR detail outline - Van gogh's paintings are very controlled - Australian variety theatre archive - Tennant street surgery stockton on tees - Solving ac circuits with complex numbers - Reasons why students should not have phones in school - Psyc 354 liberty university - Prewriting techniques definition - Parkinson aquatic centre opening - Final draft vs adobe story - Difference between cpk and ppk ppt - Extended star topology - What is mental computation - Powerpoint - Vortex company operates a retail store with two departments - The assistant lighting designer is responsible for - Tweak growing up on summary - Resultant force on pipe bend - I Need 1500 words on solution an International Management (BUSS 1006)-CW3-Fall-19-QP - Broward wind load chart - Juror 11 12 angry men - The namesake quotes about identity - Cosi louis nowra quotes - How to calculate outright quotes for bid and ask - Irony in romeo and juliet - Graves and corcoran model of nursing informatics - Erikson eight stages of psychosocial development ppt - How to play chuck a luck - 4th generation language example - Greenwich village society for historic preservation - Toughness jay bilas chapter summary