Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

Details: 1) Based on the feedback received on your Topic 2…

Customer Question
Details:1) Based on the feedback...
Details:1) Based on the feedback received on your Topic 2 assignment Database Schema, provide SQL statements to create the (revised) database and populate it with sample data (at least four rows per table).2) Modify the database by adding an additional column ("Deleted_Date") to those tables that represent entities that could contain data which can be deleted and justify your rationale in a short paragraph. In addition, explain what the tradeoffs are in using a marker-column for deletion, as opposed to actually deleting a row from a table?
Submitted: 9 months ago.Category: Homework
Show More
Show Less
Ask Your Own Homework Question
Answered in 2 minutes by:
8/2/2017
Tutor: LogicPro, Engineer replied 9 months ago
LogicPro
LogicPro, Engineer
Category: Homework
Satisfied Customers: 13,458
Experience: Expert in Java C++ C C# VB Javascript Design SQL HTML
Verified

Hi

Ask Your Own Homework Question
Customer reply replied 9 months ago
hello, how do I see my results?
Tutor: LogicPro, Engineer replied 9 months ago

In order to let me work on it, you need to provide me your previous work, previous requirements and feedback.

Zip all files, upload to wikisend.com and post download link or file id here

Ask Your Own Homework Question
Customer reply replied 9 months ago
I am unable to download my file to get an answer to my question. the site you sent me to keeps saying download unavailable or expired,
Tutor: LogicPro, Engineer replied 9 months ago

Just type any text, highlight it and use paper clip icon while you reply to attach

Here are the steps: http://ww2.justanswer.com/help/how-do-i-send-photo-or-file-expert-0

Ask Your Own Homework Question
Customer reply replied 9 months ago
Database Schema
A database schema is a significant element for maintaining data integrity in any database management system. A database schema can be used to demonstrate a robust logical relational data arrangement, which may include part or all (Dumbill, 2012). A database schema can sometimes occur in two forms. These may include a visual representation or even sets of formulas (data integrity checks) (Lee, Tang, & Choi, 2013; Jarke, Lenzerini, Vassiliou & Vassiliadis, 2013). Most of these formulas are often represented in certain data definition language such as SQL. Note that the database schemas also include a database dictionary. The main objective of the database dictionary is often to demonstrate how different entities that constitute the database communicate to one another (Goyal & Vohra, 2012). To address the study topic in a better manner, the essay includes a basic contextual health care database for a proper demonstration. Some of the entities for consideration in the study topic include:
 Doctor
 Room
 Guardian
 Patient
 Test and Diagnosis
 Medication
These entities can be mapped into a database schema as illustrated below.
Figure 1. Representation of the database schema
The database schema dictionary may be represented as shown below
DATABASE DICTIONARY
Column Mandatory? Presentation Length of Field Summary
Patient
Attributes
Patient ID YES NUMBERS 16 Patient’s unique ID
Last Name YES VARCHAR 64 Patient’s first name
First Name YES VARCHAR 64 The patient’s last name
Middle Name YES VARCHAR 64 The patient’s middle name
Birthday YES DATE 8 Actual date of birth of the patient
Age YES NUMBER 8 The patient’s date of birth
Gender YES VARCHAR 16 sexual orientation of the patient
Height YES NUMBER 16 Patient’s height Measurement
Weight YES NUMBER 16 measurement of Patient’s weight
Marital Status NO VARCHAR 64 Marital status of the patient
Address YES NUMBER 16 physical location of the patient
Contact Number YES NUMBER 16 Patient’s phone contact
Test and Diagnosis
Attributes
Patient ID YES NUMBER 8 Patient unique ID
Test ID YES N/A 8 Unique ID of test results
Body temperature YES NUMBER 8 The patient’s body temperature
Blood pressure YES NUMBER 8 the patient’s Measure of levels of blood flow
Blood type YES VARCHAR 8 blood group of the patient
X-ray Result YES 8 patient’s scan of the internal body organs
Urine examination YES 8 urine test of the patient
Other results YES 64 Miscellaneous tests
Diagnosis YES VARCHAR 8 Overall tests outcomes
Medication
Attributes
Patient ID YES NUMBER 16 Patient unique ID
Medication ID YES NUMBER 16 Medication unique ID
Medicine1 Name VARCHAR 8 Patient medication name
Medicine1 Description YES VARCHAR 64 A brief explanation of a patient’s prescriptions
Medicine1 Dosage YES VARCHAR 8 A brief explanation of a patient’s dosage
Medicin2 Name YES VARCHAR 8 the patient’s other dosage name
Medicin2 Description YES VARCHAR 64 2nd group of the patient’s other dosage explanation
Medicin3 Dosage YES VARCHAR 8 3rd group of the patient’s other dosage
Medicin3 Name YES VARCHAR 8 3rd group of the patient’s other dosage name
Medicin3 Description YES VARCHAR 64 3rd group of the patient’s other dosage description
Doctor
Attributes
Doctor ID YES NUMBER 16 The doctor’s Unique ID
Patient ID YES VARCHAR 16 The patient’s unique ID
First Name YES VARCHAR 64 The first name of the doctor
Last Name YES VARCHAR 64 The second name of the doctor
Middle Name YES VARCHAR 64 The third name of the doctor
Specialization YES VARCHAR 16 field of specialty of the doctor
Years of experience NO NUMBER 8 medical practice period of the doctor
Degree NO VARCHAR 16 educational qualification of the doctor
Contact Number YES NUMBER 16 doctors phone contacts
Room
Attributes
Room ID YES NUMBER 16 Patient room unique ID
Patient ID YES NUMBER 16 Patient’s unique ID
Floor Number YES NUMBER 16 Floor number where room is located
Room Number YES NUMBER 16 Room number where the patient is located
Room Type NO NUMBER 16 Room type (grounded on diagnosis results)
Room Description NO VARCHAR 250 A brief explanation of the room
Status NO VARCHAR 64 A brief explanation of the basic appearance of the room
Date Admitted YES DATE 16 Date of admission of the patient
Date Released YES DATE 25 Patient’s clearance date
Guardian
Attributes
Patient ID YES NUMBER 10 Patient’s Unique ID
Guardian ID YES NUMBER 10 The Gordian’s unique ID
First Name YES VARCHAR 64 The first name of the Guardian
Last Name YES VARCHAR 16 The last name of the guardian
Middle Name YES VARCHAR 16 The middle name of the guardian
Age YES NUMBER 10 Display of the age of the guardian
Address YES NUMBER 10 Physical location of the Guardian
Contact Number YES NUMBER 10 The phone contact of the Guardian
Table 1: Illustration of the Database schema dictionary
Areas of Difficulty, Rationale for Design and Probable Exte
Tutor: LogicPro, Engineer replied 9 months ago

Can you provide formatted document. THis editor removed formatting

zip all files, Just type any text, highlight it and use paper clip icon while you reply to attach

Here are the steps: http://ww2.justanswer.com/help/how-do-i-send-photo-or-file-expert-0
Ask Your Own Homework Question
Was this answer helpful?
Ask Scott Your Own Question
Scott
Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3,040
3,040 Satisfied Customers
Experience: MIT Graduate (Math, Programming, Science, and Music)

Scott is online now

A new question is answered every 9 seconds

How JustAnswer works:

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

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

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!!!!

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

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, 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.

EstherWoodstock, 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.

RobinElkton, 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.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

LogicPro

LogicPro

Engineer

13,458 satisfied customers

Expert in Java C++ C C# VB Javascript Design SQL HTML

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,551 satisfied customers

More than 5000 online tutoring sessions.

Linda_us

Linda_us

Finance, Accounts & Homework Tutor

3,138 satisfied customers

Post Graduate Diploma in Management (MBA)

Chris M.

Chris M.

M.S.W. Social Work

2,636 satisfied customers

Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

F. Naz

F. Naz

Chartered Accountant

2,161 satisfied customers

Experience with chartered accountancy

Bizhelp

Bizhelp

CPA

1,887 satisfied customers

Bachelors Degree and CPA with Accounting work experience

Seanna

Seanna

Tutor

1,781 satisfied customers

3,000+ satisfied customers, all topics, A+ work

< Previous | Next >

Related Homework Questions
Write a main function that asks the user for four floats and
Write a main function that asks the user for four floats and then outputs the minimum, maximum, their sum and mean value. Use the functions from (a) – (d) to implement this. (a) Take two floats as arg… read more
Satchi
Satchi
Bachelor\u0027s Degree
2,102 satisfied customers
A dear friend has written a series of three words which she
Hi. A dear friend has written a series of three words which she has used as the title of an essay and in the body of an essay and in a published book. The book is available as a paper version and also… read more
Olivia Kent
Olivia Kent
Managing Partner
Doctoral Degree
3,209 satisfied customers
Statistics question. Just a couple of question
statistics question JA: The Tutor can help you get an A on your homework or ace your next test. Tell me more about what you need help with so we can help you best. Customer: just a couple of question … read more
Brad Summers
Brad Summers
Bachelor of Education
9 satisfied customers
Submit your spreadsheet work (along with this summary answer
Submit your spreadsheet work (along with this summary answer sheet) for the problems below Indicate your “bot***** *****ne” answers in the space provided below for each question (which require a sprea… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
In C Program. Write functions for the four basic
In C Program. Write functions for the four basic mathematical operations addition, subtraction, multiplication and division. Each function has two numbers as parameters and returns the result. Use int… read more
Satchi
Satchi
Bachelor\u0027s Degree
2,102 satisfied customers
I need help with my Marketing course but I do not see
I need help with my Marketing course but I do not see Marketing in the Category below. This assignment is due by May 25, 2018. This assignment has 20 questions. Select the best answer to each question… read more
Chris M.
Chris M.
M.S.W. Social Work
Master's Degree
2,636 satisfied customers
A friend gives you a metal cube that measured 2.0cm on each
A friend gives you a metal cube that measured 2.0cm on each side and has a mass of 27.5g.what can be deduced from the cube and the table(the table has the density of aluminum 2.7) I planed to find the… read more
Brad Summers
Brad Summers
Bachelor of Education
9 satisfied customers
Need help with IT Project Management assignment. The
Need help with IT Project Management assignment. The assignment information is attached.TASK: 1. Do a risk management plan: list of risks involved, level of the risk, the likelihood of the risks of oc… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
I need help, Psychology, Right know just this
I need help JA: The Tutor can help you get an A on your homework or ace your next test. Tell me more about what you need help with so we can help you best. Customer: Psychology JA: Is there anything e… read more
Chris M.
Chris M.
M.S.W. Social Work
Master's Degree
2,636 satisfied customers
A screening examination was performed on 250 persons for
A screening examination was performed on 250 persons for Factor X, which is found in disease Y. A definitive diagnosis for disease Y among the 250 persons had been obtained previously. The results are… read more
Chris M.
Chris M.
M.S.W. Social Work
Master's Degree
2,636 satisfied customers
The death rate per 100,000 for lung cancer is 7 among
The death rate per 100,000 for lung cancer is 7 among non-smokers and 71 among smokers. The death rate per 100,000 for coronary thrombosis is 422 among non-smokers and 599 among smokers. The prevalenc… read more
GLENN
GLENN
Master of Mathematics
409 satisfied customers
I'm in the process of writing a story and am second-guessing
Hello. I'm in the process of writing a story and am second-guessing the structure of the following paragraph. Is it acceptable as is, or do I need to precede the last quoted sentence by a blank line. … read more
GLENN
GLENN
Master of Mathematics
409 satisfied customers
An epidemiologic survey of roller-skating injuries in
An epidemiologic survey of roller-skating injuries in Metroville, a city with a population of 100,000 (during the midpoint of the year), produced the following data for a particular year:Number of ska… read more
Brad Summers
Brad Summers
Bachelor of Education
9 satisfied customers
I need help writing a Transportation project case study that
Hello, i need help writing a Transportation project case study that was completed within the last 3 years in the Wilson N.C. area or in the eastern part of N.C. It needs to describe the background of … read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
The death rate per 100,000 for lung cancer is 7 among
The death rate per 100,000 for lung cancer is 7 among non-smokers and 71 among smokers. The death rate per 100,000 for coronary thrombosis is 422 among non-smokers and 599 among smokers. The prevalenc… read more
Dr. Jon
Dr. Jon
Attending Physician
MD
142 satisfied customers
I need help with my Marketing course but I do not see
I need help with my Marketing course but I do not see Marketing in the Category below. This assignment is due by May 25, 2018. This assignment has 20 questions. Select the best answer to each question… read more
Chris M.
Chris M.
M.S.W. Social Work
Master's Degree
2,636 satisfied customers
N a study to determine the incidence of a chronic disease,
n a study to determine the incidence of a chronic disease, 150 people were examined at the end of a three-year period. Twelve cases were found, giving a cumulative risk of 8%. Fifty other members of t… read more
GLENN
GLENN
Master of Mathematics
409 satisfied customers
I need help with my Marketing course. Both assignments are
I need help with my Marketing course. Both assignments are due by May 25, 2018. Both assignments are 20 questions. Select the best answer to each question. Note that a question and its answers may be … read more
Chris M.
Chris M.
M.S.W. Social Work
Master's Degree
2,636 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x