fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
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.

Stuck on Your Question?

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

250 words

Error goes here

Students Who Viewed This Also Studied

4 Pages
Business Management

Prepare the following:  a) An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein&n ...

Type

Programming

Subject

Database

2 Pages
Management

Identification and discussion of the theory and concepts relevant to the selected article Analysis and demonstrated level of understanding of key issues and theory presented in the article Identificat ...

Type

Programming

Subject

Database

9 Pages
ITC556 Database Systems

Task: Subject Overview This subject will provide a solid grounding in database design . It will show the importance of database design in the development of applications that meet business needs. Th ...

Course

ITC 556

Type

Programming

Subject

Database

University

Charles Sturt University

8 Pages
ER diagram

CRICOS Provider No. 00103D ITECH 1006 Assignment Summer Semester 2016.docx Page 3 of 3 Marking Criteria/Rubric Assessment Criteria and Marking Overview Tasks Marks 1. Presentation Cover page indicatin ...

Type

Programming

Subject

Database

COMP2350 Database Systems

Question

Answered

Question:

This assignment concerns database Database Design and Manipulation.

Problem Context

The context of this Assignment is the same as for Assignment 1, namely The Magic Ale (MA). 

We pretend that your firm had an agreement with MA to design and implement the Database, and the job fell on your lap. You in turn assigned that task to an intern you are mentoring. The intern has gone through the specification and designed some relational schemas for this purpose. You had a quick look at them, and one of them particularly stood out since it had quite a number of attributes that you suspected should best belong to different relations. The suspect relation schema in question is:

Abnormal_Rel(   ProductID,   BranchID,   campaignID,   MemberID, ProductType,  PackageType,  YearProduced,  Price,

Brand, StockLevel, CampaignStartDate, CampaignEndDate, FirstName, LastName, eMail, MembershipLevel, MemberExpDate, Discount

)

Upon discussion with the intern you gathered that different branches can have the same product (ProductID) in different quantities. Also, in different campaigns, the same product may be given different discount rates for the same membership level.

You took upon yourself to explain to the intern the issue at hand, and how the issue should be addressed. Complete the following tasks in that context.

Task Specifications

Task 1

Identify the non-trivial FDs on the relation Abnormal_Rel. Then identify the Candidate key(s) of Abnormal_Rel.

Task 2

Determine for each update anomaly whether or not the relation Abnormal_Rel is susceptible to that anomaly. Support your determination with adequate explanation and a small example.

Task 3

Determine the highest normal form that the relation Abnormal_Rel is in. Then:

  1. Normalize/decompose it until you get relations that are in 3NF. Use appropriate illustration to aid the understanding of your work.
  1. Check if the resultant relations are in BCNF. If not, decompose them as necessary until you get all of them in BCNF.

Task 4

Now (at the end of completing Task 3) you have a set of relation(s) in BCNF, derived from the relation Abnormal_Rel.

  1. Create an appropriate table for each of these relations (in BCNF), keeping the key constraints in mind. Copy and paste into your .doc document the SQL code you used for this purpose. Also paste into your Assignment2Codetext file the same.
  2. Insert five rows of (made-up) data into each table. Make surethat the data you enter in these tables should be sufficient to return at least one row for each query in Task 5. For instance, MA should hold at least 5 bottles of Penfold Grange 2010 in some branch or other. Copy and paste into your .doc document the SQL code you used for this purpose. Also paste into your Assignment2Code text file the same.
  1. Display the content of each table using a SELECT * query. Copy and paste into your.doc document the result that was displayed.

Task 5

Write SQL queries to answer the following four questions (Q1-Q4). With respect to each,

  • Copy and paste into your .doc document the SQL query you used for this purpose. Also paste into your Assignment2Codetext file the same.
  • Display the result of running this query. Copy and paste into your .doc document the result that was displayed.

COMP2350 Database Systems

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.

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

MyAssignmenthelp.com is an internationally recognized legit online coursework help provider in USA. With a team of experienced and qualified coursework writers, we provide the highest quality products that are free from plagiarism. Our experts work round the clock to satisfy students demands like can experts Write my coursework assignments or can anyone do my coursework assignments and provide them the best writing solutions.

More COMP2350 COMP2350 Database Systems: Questions & Answers

Q

Prepare the following:  a) An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein  methodology as per the study book and tutorials.   (15 Marks)  b) A list of rela ...

View Answer
Q

Identification and discussion of the theory and concepts relevant to the selected article Analysis and demonstrated level of understanding of key issues and theory presented in the article Identification and analysis of strengths and weaknesses of the article leading to conclusive identification of ...

View Answer
Q
icon

We aren't endorsed by this University

Task: Subject Overview This subject will provide a solid grounding in database design . It will show the importance of database design in the development of applications that meet business needs. There will be an emphasis on modeling a database using Entity Relationship Diagrams (ERDs), optimising ...

View Answer
Q

CRICOS Provider No. 00103D ITECH 1006 Assignment Summer Semester 2016.docx Page 3 of 3 Marking Criteria/Rubric Assessment Criteria and Marking Overview Tasks Marks 1. Presentation Cover page indicating student name and number and tutor name. 2 Page numbers included in report 2 Index giving page numb ...

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

expert
student rating student rating student rating student rating student rating
Lise Blomgren

Masters in Health Management

221 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Kimberley Chen

MPA in Accounting

2115 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Carter Baker

MBA with specialization in Marketing

210 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Geoffrey Morris

LLM in Business Law

285 - Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
02 Dec 2021

English

Essay: 4 Pages, Deadline: 9 days

Very good paper, included everything and helpful. I got a grade on the essay, received a 100 on my paper. I highly recommend this website!

flag User ID: 6***89 United States

student rating student rating student rating student rating student rating
02 Dec 2021

Marketing

Assignment: 10 Pages, Deadline: 11 days

Excellent job. Very timely. Customer service was top-notch. Even my lecturer was impressed.

flag User ID: 8***83 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 7 Pages, Deadline: 9 days

I am very happy when I get marks I feel very verry good I got good marks thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Project Management

Essay: 9 Pages, Deadline: 1 day

was a part of my programme management curs level 5 i passed it with 85% and that is soo good for me, thank you

flag User ID: 7***04 Birmingham, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Thesis: 1.8 Pages, Deadline: 6 days

Very good job I am very happy when I get marks I very very happy thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Mechanical Engineering

Programming: 6 Pages, Deadline: 15 days

was in time good experience, hope would have scored good grades. Good maintained and very much friendly service.

flag User ID: 6***39 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Essay: 6 Pages, Deadline: 5 days

excellent work thank you i will always use this website and tell and advise my friends and colleagues about you guys but there must be more discounts ...

flag User ID: 7***75 Kuwait

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Programming: 2 Pages, Deadline: 4 days

all work done well with good referencing and proper words i got a very good score for this particular course and i am happy about that. thank you so ...

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Assignment: 3.6 Pages, Deadline: 3 days

submitted my work and the lecture acknowledge my work saying that it was good and i did a very good work.

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 16 Pages, Deadline: 16 days

Very supporting and helpful, I am happy to express that the assignment and writing is very good and helped me to achieve good achievement in study.

flag User ID: 4***58 Malaysia

student rating student rating student rating student rating student rating
02 Dec 2021

English

Essay: 4 Pages, Deadline: 9 days

Very good paper, included everything and helpful. I got a grade on the essay, received a 100 on my paper. I highly recommend this website!

flag User ID: 6***89 United States

student rating student rating student rating student rating student rating
02 Dec 2021

Marketing

Assignment: 10 Pages, Deadline: 11 days

Excellent job. Very timely. Customer service was top-notch. Even my lecturer was impressed.

flag User ID: 8***83 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 7 Pages, Deadline: 9 days

I am very happy when I get marks I feel very verry good I got good marks thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Project Management

Essay: 9 Pages, Deadline: 1 day

was a part of my programme management curs level 5 i passed it with 85% and that is soo good for me, thank you

flag User ID: 7***04 Birmingham, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Thesis: 1.8 Pages, Deadline: 6 days

Very good job I am very happy when I get marks I very very happy thank u so much for helping me

flag User ID: 5***67 Canada

student rating student rating student rating student rating student rating
02 Dec 2021

Mechanical Engineering

Programming: 6 Pages, Deadline: 15 days

was in time good experience, hope would have scored good grades. Good maintained and very much friendly service.

flag User ID: 6***39 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Essay: 6 Pages, Deadline: 5 days

excellent work thank you i will always use this website and tell and advise my friends and colleagues about you guys but there must be more discounts ...

flag User ID: 7***75 Kuwait

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Programming: 2 Pages, Deadline: 4 days

all work done well with good referencing and proper words i got a very good score for this particular course and i am happy about that. thank you so ...

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

HRM

Assignment: 3.6 Pages, Deadline: 3 days

submitted my work and the lecture acknowledge my work saying that it was good and i did a very good work.

flag User ID: 8***18 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
02 Dec 2021

Management

Assignment: 16 Pages, Deadline: 16 days

Very supporting and helpful, I am happy to express that the assignment and writing is very good and helped me to achieve good achievement in study.

flag User ID: 4***58 Malaysia

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?