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: 1 year ago.Category: Homework
Show More
Show Less
Ask Your Own Homework Question
Answered in 2 minutes by:
8/2/2017
Tutor: LogicPro, Engineer replied 1 year ago
LogicPro
LogicPro, Engineer
Category: Homework
Satisfied Customers: 13,507
Experience: Expert in Java C++ C C# VB Javascript Design SQL HTML
Verified

Hi

Ask Your Own Homework Question
Customer reply replied 1 year ago
hello, how do I see my results?
Tutor: LogicPro, Engineer replied 1 year 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 1 year 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 1 year 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 1 year 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 1 year 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?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tutorLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
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,507 satisfied customers

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

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,556 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,699 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,194 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
Please Pass To LogicPro I have previously completed project
Please Pass To LogicPro I have previously completed project 1 attached also for your ref... Would like this completed by Wed of this week. In this project you will perform the physical design and impl… read more
LogicPro
LogicPro
Engineer
13,507 satisfied customers
Assignment 2: Dropbox AssignmentEntity-Relationship
Assignment 2: Dropbox Assignment Entity-Relationship Model To complete this assignment, you will need both MySQL Workbench and a local installation of MySQL Server. Both are available for free downloa… read more
Expert
Expert
Part : Answer the following questions with a narrative response
Part B: Answer the following questions with a narrative response in complete sentences. Note: You will need to submit responses to the questions including all the SQL scripts that you may have created… read more
Mr. Wilson
Mr. Wilson
Teacher
Master\u0027s Degree
200 satisfied customers
1) Based on the feedback received on your Module 2 assignment
1) Based on the feedback received on your Module 2 assignment Database Schema, provide SQL statements to create the (revised) database and populate it with sample data (at least four rows per table). … read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
To Carla Only:Based on the feedback you have received with
To Carla Only: Based on the feedback you have received with respect to your data model and DDL, now is your chance to implement the final changes. Make any needed changes to your ERD and Physical Data… read more
C.Martin
C.Martin
IT Consultant
Bachelor's Degree
453 satisfied customers
You will need to start by creating an ER model, including both
You will need to start by creating an ER model, including both Entity Classes and attributes. This is to be done in MySQL Workbench. Then, using both MySQL Workbench and MySQL Server, create a schema … read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
Using the attached word document I need the following done.
Attachment: 2014-10-13_085956_mom_and_pop_version_2.docx In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating th… read more
Expert
Expert
I have a 2 part project that I need completed. It must be
I have a 2 part project that I need completed. It must be original. It includes a entity relationship diagram and detailed documentation. This is similar to what you did three months ago. I'll tel you… read more
Expert
Expert
can you help me with these sql questions. Using the Northwind
can you help me with these sql questions. Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the following questions: 1. Display the character constant 'Greetin… read more
John
John
Software Engineer
509 satisfied customers
Hello, Is there anyway you can help me with this assignment?
Hello, Is there anyway you can help me with this assignment? I can't even log into Oracle to do it myself. I am extremely frustrated and need to complete this assignment. The instructions are below: I… read more
LogicPro
LogicPro
Engineer
13,507 satisfied customers
In this project you will perform the physical design and implementatio
In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manip… read more
John
John
Software Engineer
509 satisfied customers
In this project you will perform the physical design and implementation
In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manip… read more
LogicPro
LogicPro
Engineer
13,507 satisfied customers
Can you re-create a projected I saw that you worked on for a
Can you re-create a projected I saw that you worked on for a different customer? (Original URL: http://www.justanswer.com/question/qa-guest-expert.aspx?TID=11662296) Project Part 1 Details: In this pr… read more
jatechexpert
jatechexpert
Master\u0027s Degree
1 satisfied customers
You will develop an ER diagram for the given scenario.You
You will develop an ER diagram for the given scenario. You have been hired by the sales department of ABC Manufacturing. XXXXX XXXXX, the sales manager has requested that you develop an ER model for h… read more
LogicPro
LogicPro
Engineer
13,507 satisfied customers
**FORTHEDOCTOR** Hello one more time...:) Entity-Relationship
**FORTHEDOCTOR** Hello one more time...:) Entity-Relationship Model To complete this assignment, you will need both MySQL Workbench and a local installation of MySQL 5.5. Both are available for free d… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
(TCO 3) When designing a database, you should ____. (Points
(TCO 3) When designing a database, you should ____. (Points : 2) make sure entities are in normal form before table structures are created create table structures then normalize the database only norm… read more
active1065
active1065
Bachelor
82 satisfied customers
Part 1 Using the DBMS you chose in the previous Discussion
Part 1 Using the DBMS you chose in the previous Discussion Board assignment, download and install that software to prepare for the Database and Data Model to be created. Once the software is running a… read more
LogicPro
LogicPro
Engineer
13,507 satisfied customers
Ex 3 Question 1 4 points Save Denormalization produces
Ex 3 Question 1 4 points Save Denormalization produces a lower normal form. True False Question 2 4 points Save Normalization is a process that is used for changing attributes to entities. True False … read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,131 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