数据库代写 | CSE 581 Project 2: University Medical Center Database

本次美国代写主要为sql数据库设计的project

In this project, you will design, implement, and test a database for a medical center, called University
Medical Center (UMC), which has several healthcare facilities throughout the city. Some of the basic
suggestions of information in this database are given below. You will need to investigate further about
the typical operations in a hospital setting and possibly using the above links, and design your database,
and accordingly consider several base tables such as for medical staff as well as linking tables such as
for patient appointments, physician schedules, nurse schedules, surgery room schedules, inpatient
room schedules, and equipment reservations.
Facility
• location and hours
• room capacity (rooms, beds, …)
• departments (pediatrics, surgery, …)
• care capacity (Level 1 Trauma Center
emergency, ICU, …)
• medical equipment (ventilators, …)
Medical Staff
• name, address, phone, email, etc.
• type (physician, dentist, pharmacists,
RN, …)
• position (attending, PCP, visiting, …)
• active, on leave, retired, etc.
Patient
• name, address, phone, email, etc.
• health insurance info
• primary care doctor
Imaging
• testing (MRI, CAT, …)
Lab
• tests, results
• mandated reporting to county, state
Pharmacy
• medicines
• rental equipment
Employees
• name, address, phone, email, etc.
• salary, benefits, contract type, contract
term, reviews
• department, office, office phone
• work schedule
Patient Medical Records
• weight, height, vitals
• check in/out times
• symptom/diagnostic/procedure codes
• attending physician
• referral doctor
• medication/hospitalization/discharge

Billing
• visits
• medical billing codes (ICD-10, …)
• payor (self, insurance, Medicaid, …)
• payment method
Costs
• medications
• procedures

Insurance Coverage
• health insurance company name,
phone, contact info
• insurance coverages
Visitors
• name, ID number, date of birth, picture
• patient being visited
• entry/exit times

Technical Requirements:
In your design, you will need to determine
1) what information to store (please see above for some suggestions)
2) how to design a descriptive E/R diagram (please use only MS Visio, Untitled Diagram, Visual
Paradigm, Vertabelo, or any similar tool)
3) what kind of business reports would be needed (consider views for a valid reason)
4) possible business logics and transactions to consider, and how to incorporate them into the
design (consider constraints, triggers, transactions, stored procedures, user defined
functions)
In your implementation, you will need to
1) use descriptive naming for all the items in your database using CamelCase naming
standard.
2) normalize your design into its 3rd Normal Form with possibly about 20+ tables.
3) create tables with columns, primary keys, foreign keys, proper data types, nullabilities, and
necessary relationships and constraints.
4) determine potential integrity and security issues.
5) create 4 views, 2 stored procedures, 2 user defined functions, 2 triggers, and 1 transaction.
6) and include 2 scripts to create users with various security levels, passwords, and roles.
Please note that you are expected to code by yourself and no auto-generation of SQL is
accepted!


程序代写代做C/C++/JAVA/安卓/PYTHON/留学生/PHP/APP开发/MATLAB


blank

本网站支持淘宝 支付宝 微信支付  paypal等等交易。如果不放心可以用淘宝交易!

E-mail: itcsdx@outlook.com  微信:itcsdx


如果您使用手机请先保存二维码,微信识别。如果用电脑,直接掏出手机果断扫描。

blank

发表评论