Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

3 Pages
Customer Order Databases

And the instructions given to us by unit coordinator are as follows Hi All As you may know there will be test on coming Thursday 4 -6pm. It is a Mylo quiz based test. Test will start exact ...

Course

KIT712

Subject

Database

University

University of Tasmania

Season

Fall

24 Pages
B6IS106-Information Systems and Databases

Assessment Task Read the following case study and then carry out the required tasks. Midlands Technological University (MTU) is a 3rd level provider of Level 6,7,8 and 9 QQI recognised programs serv ...

Course

B6IS106

Type

Programming

Subject

Database

University

Dublin Business School

17 Pages
COMP6210 Big Data

Questions: Section A: 5 Questions Variety, Veracity and Variability are important characteristics of big data. Explain each of them. Compare the ACID properties in traditional data systems ...

Course

COMP6210

Type

Home Work

Subject

Database

University

Macquarie University

29 Pages
6557 Database Systems PG

For Canberra Health Insurance (CHI) scenario in the problem below: Identify and list all entities, attributes, primary and foreign keys for the scenario below (in 3NF Third Normal Form). (10 Marks) ...

Course

6557

Type

Programming

Subject

Database

University

Australian Catholic University

INSS651 Database Management System

Question

Answered

Questions:

Part A

Redesign the database including Children table, note you may have to modify existing table(s) and create some new ones.
  1. Select ONE accountas main account from your group
    1. Owner of the account should give privileges to other group members so all can work on it.
    2. Give the syntax for it.
  1. Modify and create any new tables
  1. remove following redundancies as discussed in assignment 1 (Do not create NEW tables from scratch but use create table from existing table statement, see Page 288

(create table part as select  P-_code etc.. from product;) This creates a new table PART from existing table Product

  • Redundancy related to insurance company

  • Redundancy related to APPOINTMENT table
  1. Develop tables in ORACLE and load the data
  2. Give the structureand content of Each Table
  3. Draw the ERD
  4. If there were different charges by doctor for a given treatment, (ex Dr Jones charge different amount for X-ray then Dr. Betty, etc), explain how will your database change.

Part B

All queries MUST be based SOLELY on the information provided and each question must use a SINGLE query..no views or separate queries, unless otherwise stated. You should have one single composite query for each question. As always all queries should be data independent.

Use ORACLE to answer the following:  (All relate to new design that you have developed)

  1. Which doctor has the maximum children?
  2. Give the names of doctors that have exactly two “l” in their name
  3. Give the names of doctors that do not have any children
  4. Give the names of doctors who have exactly two children  
  5. Give the names of patients that had x-ray AND CT scan treatment
  6. Each treatment in appointment table has treatment followed by patientid; ex:

CT340 consists of t_ID and Patient_IDs ex: CT (treatment)  for patient 340;
BD 340 is blood test for patient 340 etc.

Give treatment id and treatment description but remove patientId from treatmentID. For treatment ID only give the first 2 characters; see below

ex: your output should be (hint see page 368)

  code                                     description                         price

CT

   CT scan

535

BD

 blood Test

 45

RA

X-ray

135

Etc.

 

 
 
 

INSS651 Database Management System

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

15 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com boasts a team of talented and highly skilled coursework writers based in UK who assist students in the best possible manner. Students, who need coursework help, find our services fulfilling and effective because we provide high quality help at affordable price. So, students who often search can someone do my coursework cheap or can experts Write my coursework for cheap get perfect solution at MyAssignmenthelp.com. They pay for best coursework and get it from us.

More INSS651 INSS651 Database Management System: Questions & Answers

Q
icon

We aren't endorsed by this University

Customer Order Databases

And the instructions given to us by unit coordinator are as follows Hi All As you may know there will be test on coming Thursday 4 -6pm. It is a Mylo quiz based test. Test will start exactly at 4.10pm and end after 1 hour 5minutes. In other words, no extra time will be given even if y ...

View Answer
Q
icon

We aren't endorsed by this University

B6IS106-Information Systems and Databases

Assessment Task Read the following case study and then carry out the required tasks. Midlands Technological University (MTU) is a 3rd level provider of Level 6,7,8 and 9 QQI recognised programs serving principally the counties of the midlands area of Ireland. MTU Students Union (MTU SU) is the rep ...

View Answer
Q
icon

We aren't endorsed by this University

COMP6210 Big Data

Questions: Section A: 5 Questions Variety, Veracity and Variability are important characteristics of big data. Explain each of them. Compare the ACID properties in traditional data systems with the BASE properties in NoSQL databases. Big Data and Cloud Computing (1) Explain SaaS, Paa ...

View Answer
Q
icon

We aren't endorsed by this University

6557 Database Systems PG

For Canberra Health Insurance (CHI) scenario in the problem below: Identify and list all entities, attributes, primary and foreign keys for the scenario below (in 3NF Third Normal Form). (10 Marks) Draw the E-R of the system below based on entities, attributes, primary and foreign keys you have ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?