INFO20003 Database Systems: Computing And Software Systems

INFO20003 Database Systems:  Computing And Software Systems

$20 Bonus + 25% OFF

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

Students Who Viewed This Also Studied

INFO20003 Database Systems

Questions:

Task Specifications

You will submit two files on moodle:

1. Assignment2. pdf. You will first put all your answers to the tasks below (including copying and pasting any SQL code) into a file Assignment2. doc (carefully following the instructions provided), then generate a .pdf file called Assignment2.pdf.

2. Assignment2 Code.sql. [If you already know how to extract an .sql file, you need not follow the relatively convoluted process described below. This description is meant for students who do not know how to generate an executable file of SQL codes.] First open a new file called Assignment2Code.txt employing a text editor such as Notepad or vi. Then copy and paste as text the required SQL codes into it. When completed, save it, exit, and replace the suffix .txt by the suffix .sql. 

Task 1 (20 marks)

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

Task 2 (20 marks)

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 (20 marks)

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.

2. Check if the resultant relations are in BCNF. If not, decompose them as necessary until you get all of them in BCNF.

Task 4 (20 marks)

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 Assignment2Code text file the same.

2. Insert five rows of (made-up) data into each table. Make sure that 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.

3. Display the content of each table using a SELECT query. Copy and paste into your .doc document the result that was displayed.

Task 5 (20 marks)

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 Assignment2Code text file the same.

• Display the result of running this query. Copy and paste into your .doc document the result that was displayed.

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

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

Get over with your struggling assignment sessions with MyAssignmenthelp.com. Any complex task or university coursework from UK, US and Australia is treated with intricate research work. Attain highest grade with our premium quality and well-referenced assignments. We make sure that the assignments are delivered long before the stipulated deadline. Unclear tasks and clashing assignments are solved with ease by the proficiency of our PhD writers. MyAssignmenthelp.com is the leading academic assignment help that offers 100 percent plagiarism-free assignments written by hand-picked writers from renowned universities. Discuss with our expert team or avail the best quote directly through email. Getting our services is easy and employs three simple steps. Get the quote, make your payment and receive your assignment!

More INFO20003 INFO20003 Database Systems: Questions & Answers

MITS4003 Database Systems

ConstructanE-Rdiagramforacarinsurancecompanywhosecustomersownoneormorecarseach.Eachcarhasassociatedwithitzerotoanynumberofrecordedaccidents.Eachinsurancepolicycoversoneormorecars,andhasoneormorepremiumpaymentsassociatedwithit.Eachpaymentisforaparticularperiodoftime,andhasanassociatedduedate,andtheda …

View Answer

Business Research and Report

You are an analyst, and you are asked to design and build an information system to automate a currently manual operated car parking business.Before you get involved in the software analysis and design you are required to research and analyse the situation and provide solutions report. This report sh …

View Answer

ACS2916 Business Application Systems

1. Consider a business process that you have experienced at work, as a customer, or as a student. Examples might include any process in a work setting, such as payroll and purchasing, or any process with which you have interacted, such as ordering from a Web site, obtaining a loan, eating at a resta …

View Answer

CC6001 Advanced Database Systems


Question:
You are reminded that there exist regulations concerning plagiarism.  Extracts from these regulations are printed below.  Please sign below to say that you have read and understand these extracts:
Extracts from University Regulations on Cheating, Plagiarism and Collusion
“Th …

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





Dodge Vaughan

I have earned my doctorate credential on quantum physics from the University of Bristol.

200 – Completed Orders

Hire Me





Zaiden Garza

I have acquired my PhD degree from the National University of Singapore in the field of Psychology.

800 – Completed Orders

Hire Me





Monica Shannon

I have received my Master’s in Psychology from James Cook University in Singapore.

800 – Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

Statistics

Assignment: 3 Pages, Deadline:
4 days

Well done, sent detailed explanation of each part from your side, though you missed output of first task got 74 out of 100. Thank you

User ID: 8***63 United Kingdom, Great Britain

Marketing

Assignment: 3 Pages, Deadline:
2 days

The solution is legendary. Thank you, thank you, thank you, and thank you for your cooperation and patience with me, and I am sorry for any actions. …

User ID: 9***3 United Kingdom, Kuwait

Marketing

Programming: 6 Pages, Deadline:
2 days

Thank you so much Professor Thomas Lee. i got 21/30 for my assignment, definitely will ask for you to do the part two

User ID: 2***37 Sydney, Australia

Statistics

Home Work: 1 Page, Deadline:
6 days

Second writer did a great job to complete the task… Thank must go to the second writer and my assignment help group.

User ID: 8***32 Sydney, Sri Lanka

Maths

Home Work: 1 Page, Deadline:
3 days

The assignment was done with complete details showing all the essential steps. I am very happy with the work.

User ID: 4***77 Sydney, United States

Management

Assignment: 0 Pages, Deadline:
5 days

Great work on this assignment and I will definitely be returning for additional help

User ID: 6***02 Sumter, United States

Psychology

Essay: 1 Page, Deadline:
15 hours

Perfect job and a quick job done by the writer. Thanks for the help. Grammar and sentences was great

User ID: 7***54 Sumter, Spain

Assignment

Essay: 8 Pages, Deadline:
13 days

Good work but cloud be better, hope next work is better sadasdasdasdasdasasdsadsadsadas

User ID: 5***28 United Kingdom, Great Britain

HRM

Assignment: 6 Pages, Deadline:
22 days

I am really happy with the result, even though I had to make adjustments, and I got a good grade for it.

User ID: 5***20 United Kingdom, France

Marketing

Home Work: 1 Page, Deadline:
3 days

Thank you so much! taking a time to do Thank you so much! taking a time to do my assignment my assignment

User ID: 6***98 United Kingdom, United States

Assignment

Essay: 4.8 Pages, Deadline:
10 days

A very well presented assignment, all the ideas were very well explained, easy to understand. Definitely will recommend .

User ID: 8***07 United Kingdom, Denmark

Business Law

Home Work: 0.9 Pages, Deadline:
1 day

Thank you, very much ????????????! I’m looking forward to working with you guys again.

User ID: 8***94 United Kingdom, Canada

Medical

Essay: 1.6 Pages, Deadline:
3 days

This assignment was good I got a really good grade on this assignment so who complete this one great job.

User ID: 8***56 United Kingdom, United States

Pharmacy

Assignment: 1 Page, Deadline:
3 days

This assignment was okay but I felt that it could have gotten a better grade but assignment was good.

User ID: 8***56 United Kingdom, United States

Marketing

Home Work: 1 Page, Deadline:
11 days

Very reliable work. I liked the quality of assignment. They delivered two days before the day of commitment.

User ID: 8***50 United Kingdom, Australia

Management

Assignment: 6 Pages, Deadline:
5 days

Good work and very fast turn around. Happy with the quality of assignment. Definitely would recommend.

User ID: 8***50 United Kingdom, Australia

Assignment

Essay: 2 Pages, Deadline:
3 days

Very quick done and professional job. Helped me to gain good marks. Easy to read as answers given very clear.

User ID: 5***21 Blanchardstown, Ireland

Statistics

Home Work: 3 Pages, Deadline:
11 hours

Thank you very much… YOU ARE A GREAT WRITER ! You provide this answer and saved my life !

User ID: 8***32 Blanchardstown, Sri Lanka

Civil Law

Home Work: 3.6 Pages, Deadline:
4 hours

Thanks for the time response and helped me in successfully submitting the assignment. Thanks for this time

User ID: 8***31 United Kingdom, Great Britain

Economics

Home Work: 1.2 Pages, Deadline:
2 hours

Thanks for helping at short notice. Great quality, in the short time provided. All the best

User ID: 8***61 United Kingdom, Great Britain

Statistics

Assignment: 3 Pages, Deadline:
4 days

Well done, sent detailed explanation of each part from your side, though you missed output of first task got 74 out of 100. Thank you

User ID: 8***63 United Kingdom, Great Britain

Marketing

Assignment: 3 Pages, Deadline:
2 days

The solution is legendary. Thank you, thank you, thank you, and thank you for your cooperation and patience with me, and I am sorry for any actions. …

User ID: 9***3 United Kingdom, Kuwait

Marketing

Programming: 6 Pages, Deadline:
2 days

Thank you so much Professor Thomas Lee. i got 21/30 for my assignment, definitely will ask for you to do the part two

User ID: 2***37 Sydney, Australia

Statistics

Home Work: 1 Page, Deadline:
6 days

Second writer did a great job to complete the task… Thank must go to the second writer and my assignment help group.

User ID: 8***32 Sydney, Sri Lanka

Maths

Home Work: 1 Page, Deadline:
3 days

The assignment was done with complete details showing all the essential steps. I am very happy with the work.

User ID: 4***77 Sydney, United States

Management

Assignment: 0 Pages, Deadline:
5 days

Great work on this assignment and I will definitely be returning for additional help

User ID: 6***02 Sumter, United States

Psychology

Essay: 1 Page, Deadline:
15 hours

Perfect job and a quick job done by the writer. Thanks for the help. Grammar and sentences was great

User ID: 7***54 Sumter, Spain

Assignment

Essay: 8 Pages, Deadline:
13 days

Good work but cloud be better, hope next work is better sadasdasdasdasdasasdsadsadsadas

User ID: 5***28 United Kingdom, Great Britain

HRM

Assignment: 6 Pages, Deadline:
22 days

I am really happy with the result, even though I had to make adjustments, and I got a good grade for it.

User ID: 5***20 United Kingdom, France

Marketing

Home Work: 1 Page, Deadline:
3 days

Thank you so much! taking a time to do Thank you so much! taking a time to do my assignment my assignment

User ID: 6***98 United Kingdom, United States

Assignment

Essay: 4.8 Pages, Deadline:
10 days

A very well presented assignment, all the ideas were very well explained, easy to understand. Definitely will recommend .

User ID: 8***07 United Kingdom, Denmark

Business Law

Home Work: 0.9 Pages, Deadline:
1 day

Thank you, very much ????????????! I’m looking forward to working with you guys again.

User ID: 8***94 United Kingdom, Canada

Medical

Essay: 1.6 Pages, Deadline:
3 days

This assignment was good I got a really good grade on this assignment so who complete this one great job.

User ID: 8***56 United Kingdom, United States

Pharmacy

Assignment: 1 Page, Deadline:
3 days

This assignment was okay but I felt that it could have gotten a better grade but assignment was good.

User ID: 8***56 United Kingdom, United States

Marketing

Home Work: 1 Page, Deadline:
11 days

Very reliable work. I liked the quality of assignment. They delivered two days before the day of commitment.

User ID: 8***50 United Kingdom, Australia

Management

Assignment: 6 Pages, Deadline:
5 days

Good work and very fast turn around. Happy with the quality of assignment. Definitely would recommend.

User ID: 8***50 United Kingdom, Australia

Assignment

Essay: 2 Pages, Deadline:
3 days

Very quick done and professional job. Helped me to gain good marks. Easy to read as answers given very clear.

User ID: 5***21 Blanchardstown, Ireland

Statistics

Home Work: 3 Pages, Deadline:
11 hours

Thank you very much… YOU ARE A GREAT WRITER ! You provide this answer and saved my life !

User ID: 8***32 Blanchardstown, Sri Lanka

Civil Law

Home Work: 3.6 Pages, Deadline:
4 hours

Thanks for the time response and helped me in successfully submitting the assignment. Thanks for this time

User ID: 8***31 United Kingdom, Great Britain

Economics

Home Work: 1.2 Pages, Deadline:
2 hours

Thanks for helping at short notice. Great quality, in the short time provided. All the best

User ID: 8***61 United Kingdom, Great Britain

Have any Query?

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER