How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John Your Own Question

John
John, Engineer
Category: Homework
Satisfied Customers: 766
Experience:  Bachelors Degree
Type Your Homework Question Here...
John is online now
A new question is answered every 9 seconds

The Database design project carries a weight of 20%. After

Customer Question

The Database design project carries a weight of 20%. After thoroughly understanding the principles and methods of designing a database, you should select a specific area/topic for your database. Database project is due on or before December 10, 2013.

Design a database using MS Access with the following specifications (at least):

1. Create appropriate tables (you should have at least 5 tables) and identify relationships.
2. Identify clearly the primary and foreign key (s).
3. Data should be entered using a data entry form.
4. Design queries that ask for user input (i.e., ask for a patient id to retrieve patient information.)
5. Generate a report on your database to answer questions (for example, how many patients were hospitalized due to cardiac problems)
6. Design queries to retrieve information from multiple tables.
7. After any update or manipulation, you database should maintain referential integrity.



Example database project:

Scenario: Assume you are a new person hired to create and maintain a small hospital patient database. The hospital has the following scenario:

Patient visits the hospital. First, patients have to register with the registration clerk, where the clerk records patient demographics (name, id, address, gender, race etc.). Then they are called by an assigned nurse to record information such as body temperature, blood pressure etc. After that they will see assigned doctor. Depending on situation, doctors may or may not admit patients for inpatient services. Doctor provides new prescriptions for patients and records all the medications that a patient is currently taking. Each medication has start date as well as end date and physician information who prescribes the medication. Doctor may also order laboratory works for the patient. Laboratory attendant updates the lab test results for each of the patients with proper order and information.

Design a hospital patient management database with tables for each of the proper entities (patient, medications, hospital staff, lab test, hospitalization of patients, doctor information, prescriptions etc.). For each patient’s visit, patient should have a primary diagnosis (reason for visit) also. Populate your tables with appropriate dummy data (make up your own data).

This is just a sample to give you an idea about how your database project should be. You can choose this for your project if you want to. You are welcome to choose your own project for different settings (other than patient management). Please let us know about what you choose and a brief description of what you are going to do for the project.

What to submit (Due: on or before December 10, 2013):
- A detail description of your project
- Diagram of your database including tables with attributes and relationships.
- SQL for queries.
- Screen shots of the queries and results (at least for specifications 4,5 and 6 mentioned above)
- Your database project in MS Access (the .mdb file)
Submitted: 9 months ago.
Category: Homework
Expert:  John replied 9 months ago.
hi

thanks for your question

upload all details in a Word document to www.wikisend.com
send me the Download link or File ID
Customer: replied 9 months ago.

http://wikisend.com/download/656510/Database Project.docx


 


Database Project.docx

Expert:  John replied 9 months ago.
hi

when do you need this
Customer: replied 9 months ago.

By the end of the week.

Expert:  John replied 9 months ago.
hi

ok then
Customer: replied 9 months ago.

Thanks!


 


Would you be able to gear it towards healthcare? Here is an example that she sent us.


 


http://wikisend.com/download/761664/TS001228997.accdt


 


TS001228997.accdt


 

Expert:  John replied 9 months ago.
hi

ok
Expert:  John replied 9 months ago.
hi

i have sent an underpriced report
check it and please raise the price
Customer: replied 9 months ago.

is it possible to see some screen shots of what you have done?

Expert:  John replied 9 months ago.
hi

i will send it on thrusday
Customer: replied 9 months ago.

I will increase the price based on what I see. I will tentatively raise the amount to $23. If I am satisfied I will increase. I also need to be assured that you are not sending me something which another student has used.

Expert:  John replied 9 months ago.
hi

ok no problem , i will do this as new one

check it on thursday
Customer: replied 9 months ago.

Good day, I was wondering if the project is available?

Customer: replied 9 months ago.

John,


 


Is the project ready?

Expert:  John replied 9 months ago.
hi

by tonight
Customer: replied 9 months ago.
Hey John,

Do you have an update for me?
Expert:  John replied 9 months ago.
hi

not yet finished,

please wait until tonight,
Customer: replied 9 months ago.
Sure no problem take your time I do need it by Monday we have an extension. I appreciate your help
Expert:  John replied 8 months ago.
hi

ok then thanks
Expert:  John replied 8 months ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.



Customer: replied 8 months ago.

Hey John,


 


I submitted the Project to the teacher and she came back with the comments below.


 


Why there is no relationship in between tables? Which is the master table and which one is the child table? How each tables are related to each other?


 


Can you please address her changes and resend and I will compensate you accordingly after she is satisfied with the critera.


 


Thanks,


 


Ganesh

Expert:  John replied 8 months ago.
i will check it again, get back soon
Customer: replied 8 months ago.
Hey John,
Did you get a chance to make the changes?
Expert:  John replied 8 months ago.
do you need the relationship between the tables
Customer: replied 8 months ago.

Yes, she is asking why there isn't any relationships between tables. Which table is the parent and child table and how each table is related to each other.


 


Why there is no relationship in between tables? Which is the master table and which one is the child table? How each tables are related to each other?

Expert:  John replied 8 months ago.
ok
Expert:  John replied 8 months ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.



Customer: replied 8 months ago.

Thanks, I sent it to her lets see what she say's. The screen shot you sent is how you initially set it up or do I need to make those changes?


 


 

Expert:  John replied 8 months ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.



Expert:  John replied 8 months ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.



Customer: replied 8 months ago.

Hey John,


 


Thank you for following up, She has yet to get back to me, I'll make sure to inform you if she has any add'l comments.

Expert:  John replied 8 months ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.



Customer: replied 7 months ago.

Hey John,


 


Happy Thanksgiving


 


She claims that there isn't any relationships between the tables and


 


she wants to know which is the master table and which is the child table


 


and how each table is related to each other.


 


 


 


 

Expert:  John replied 7 months ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
Customer: replied 7 months ago.

yea I saw that but I guess she's a bit crazy...she's an Adjunct so I expect that.

Expert:  John replied 7 months ago.
ok i will try to change

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
< Last | Next >
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg Linda_us's Avatar

    Linda_us

    Finance, Accounts & Homework Tutor

    Satisfied Customers:

    3121
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3035
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/lanis/2009-4-1_233717_phput9xef_c1pm.jpg Lani S.'s Avatar

    Lani S.

    Tutor

    Satisfied Customers:

    2457
    Registered Nurse, Internet Researcher, Private Tutor
  • http://ww2.justanswer.com/uploads/chooser77/2009-08-18_162025_Chris.jpg Chris M.'s Avatar

    Chris M.

    M.S.W. Social Work

    Satisfied Customers:

    2341
    Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Chartered Accountant

    Satisfied Customers:

    1975
    Experience with chartered accountancy
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    1873
    Bachelors Degree and CPA with Accounting work experience