Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

Homework

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: 6 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 6 months ago
LogicPro
LogicPro, Engineer
Category: Homework
Satisfied Customers: 13,335
Experience: Expert in Java C++ C C# VB Javascript Design SQL HTML
Verified

Hi

Ask Your Own Homework Question
Customer reply replied 6 months ago
hello, how do I see my results?
Tutor: LogicPro, Engineer replied 6 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 6 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 6 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 6 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 6 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,335 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
I was wondering if you had time to write the design and test
Hello I was wondering if you had time to write the design and test document for this code that i have created. I will attach the completed code as well as the blank document. Must be done by 3pm tomor… read more
LogicPro
LogicPro
Engineer
13,335 satisfied customers
Due: 02/24/2018 Chapter: 4-5 Assignment: Create a web page
Due: 02/24/2018Chapter: 4-5Assignment: Create a web page that follows the text, formatting, and graphics of the attached graphic. Use the attached sample photo. Create a folder called "Images" for you… read more
LogicPro
LogicPro
Engineer
13,335 satisfied customers
I want Write a straight-arrow ESA lesson plan for an
Hello i want Write a straight-arrow ESA lesson plan for an elementary level class of adults in which the students would learn the vocabulary for finding places in a town and be able to use it when giv… read more
Writing_Coach1
Writing_Coach1
Master\u0027s Degree
11 satisfied customers
I need to diagram 2:8z11. I need to diagram 2:8-11
I need to diagram James 2:8z11 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: I need to diagr… read more
GLENN
GLENN
Master of Mathematics
359 satisfied customers
Write out how to preform the following all variables are
Write out how to preform the following all variables are char. a is 0x100, b is 0x200, c is 0x300. Set up registers at the beginning using loads and tell me what each register is being used for. Also … read more
GLENN
GLENN
Master of Mathematics
359 satisfied customers
Functions Assignment For this assignment, you need to create
Functions Assignment For this assignment, you need to create a function that implements the Triangle Classification Algorithm. The algorithm has a lot of steps in it, but each step is simple. We have … read more
LogicPro
LogicPro
Engineer
13,335 satisfied customers
What is the maximum amount of money someone can receive for
What is the maximum amount of money someone can receive for financial aid for college? lets say the tuition is $40k a year and the student have no EFC. Please also provide a breakdown of where the fin… read more
NPVAdvisor
NPVAdvisor
CFP Licensee and Practitioner
Master's Degree
180 satisfied customers
It's an Access datasheet: 4-4 Enter Names into a Database In
It's an Access datasheet: 4-4 Enter Names into a DatabaseIn Application 4-2, you practiced using alphabetic indexing rules 5–8 to file names that would appear on physical documentsIn this application,… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,325 satisfied customers
I have a graded project exam national electric code. can you
hello i have a graded project exam national electric code. can you help me get it done?. and how much would you charge?… read more
Chris Parson
Chris Parson
Electrician
20 satisfied customers
I have two more programs thati am looking for help on the
I have two more programs thati am looking for help on the deadline is Thursday by 9pm. Thank you!… read more
LogicPro
LogicPro
Engineer
13,335 satisfied customers
Searching for a latin translation. Found a phrase on
searching for a latin translation. Found a phrase on gravestone. Ran it through Google Translate, but doesn't make sense to me in the context of a gravestone. maybe an expert could explain the phrase'… read more
Olivia Kent
Olivia Kent
Managing Partner
Doctoral Degree
2,238 satisfied customers
In a study of helicopter usage and patient survival, among
In a study of helicopter usage and patient survival, among the 52493 patients transported by helicopter, 294 of them left the treatment center agains medical advice and the other 52,199 did not leave … read more
GLENN
GLENN
Master of Mathematics
359 satisfied customers
I am working on a homework assignment and need answers about
I am working on a homework assignment and need answers about changing articles and adjectives … read more
Cher
Cher
JustAnswer Expert & Mentor;Teacher/Tutor
Masters Degree
1,382 satisfied customers
Subtraction Game, Name the file subtraction_game.py.
Subtraction Game, Name the file subtraction_game.py. ***Modify the below example so it meets the following requirements:**The new program shall present random subtraction questions to the player until… read more
LogicPro
LogicPro
Engineer
13,335 satisfied customers
Need help with the following two python based programs: 1) I
Need help with the following two python based programs:1) I need a program that reads four integer values corresponding to an IP address "a1.a2.a3.a4" (IPv4), and determines whether the values form a … read more
Ingo U
Ingo U
Master\u0027s Degree
358 satisfied customers
12. If the appellate court requires that issues be presented
12. If the appellate court requires that issues be presented in the form of questions, how should the questions be phrased? A. As briefly and broadly as possible, leaving details for the discussion in… read more
Cher
Cher
JustAnswer Expert & Mentor;Teacher/Tutor
Masters Degree
1,382 satisfied customers
Turtle ASCII Table. Name file turtle_ascii.py Using Turtle
Turtle ASCII Table. Name file turtle_ascii.pyUsing Turtle graphics:(Display the ASCII character table) Write a program that displays the characters in the ASCII character table from ! to ~. Display te… read more
Ingo U
Ingo U
Master\u0027s Degree
358 satisfied customers
Writing/listening comprehension (50point), directions, you
Writing/listening comprehension (50point) , directions, you will hear a story in Spanish. In English, summarize the story in a composition of between ten and twenty sentences, the story is on 4L side … read more
Cher
Cher
JustAnswer Expert & Mentor;Teacher/Tutor
Masters Degree
1,382 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