DBFN212 Database Fundamental: Build Relational Databases

DBFN212 Database Fundamental: Build Relational Databases

$20 Bonus + 25% OFF

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

Students Who Viewed This Also Studied

DBFN212 Database Fundamental

Questions:

Outcomes addressed:

a) Design and build relational databases

b) Formulate efficient queries using a query language and

c) Be knowledgeable about issues relating to data access and retrieval,storage, ethics and privacy.

Students are advised that submission of an Assessment Task past the due date without a formally signed approved Assignment Extension Form (Kent Website MyKent Student Link>FORM – Assignment Extension Application Form – Student Login Required) or previously approved application for other extenuating circumstances impacting course of study, incurs a 5% penalty per calendar day,calculated by deduction from the total mark.For example. An Assessment Task marked out of 40 will incur a 2 mark penalty for each calendar day.

Lawn Mowing Pro provides gardening and yard maintenance services to individuals and organisations.While the company will provide one-time garden services, it specialises in recurring service and maintenance. Many of its customers have multiple building, apartments, and rental properties that require gardening and lawn maintenance services. The owner type of these properties is either Individual or Corporation.Currently the manager uses a spreadsheet to keep records of everything in one table-like company, using the sample data to get started with and the following basic business rules to be maintained.

• Each property is owned by one owner

• An owner can own many properties.

• Each property can have more than one services.

• Each service is provided to one property.

• An employee can do many services

• Each service is done by one employee.

Tasks to be completed:

a. Using the table and data in Figure 1, state assumptions about dependencies among the columns of the table. Justify your assumptions on the basis of the sample data and also on the basis of what you know about service business.

b. Employing the dependencies stated in in (a), write a relational schema and draw a dependency diagram for the table in 1NF. The dependency diagram must have proper labels for all functional, partial and/or transitive dependencies, if there are any.

c. Break up the dependency diagram you drew in (b) to produce dependency diagrams that are in 3 NF and also write the relational schemas for the table in 3NF. Make sure the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure that there are no multivalued attributes,that the naming conventions are met, and so on.)

d. Develop an E-R diagram based on the task done in (c). Use crow-foot style and specify entities,attributes, relationships, and multiplicity. Justify the decisions you make regarding minimum and maximum cardinality. Describe how you would go about validating this model.

e. Using the E-R diagram you developed in(d), convert it to a relational design. Document your design as follows:

• Specify tables, primary keys, and foreign keys.

• Describe how you have represented weak entities, if there are any.

• Document relationship enforcement.

f. Create a database using MySQL, with primary keys, foreign keys, and other attributes mentioned for each table developed in (e) using proper constraints.

g. Create SQL statements to satisfy the following:

• Write SQL statements to insert at least 7 rows of data into each of the table created in task (f).You may use the sample data provided in Figure 1 for this task.

• Write SQL statements to list all columns of all tables.

• Write SQL statements to list the name and mobile phone for all employees.

• Write SQL statements to list the name and email address for all owners.

• Write SQL statements to list the property name, address, state, and post code for all properties.

• Write SQL statements to list all owner names and their property owned.

• Write SQL statements to determine how many times of ‘Lawn Mow’ have been done at ‘Earls Courts’?

• Write SQL statements to list name of employees who have provided ‘Garden Service to a property owned by ‘Individual’.

• Write SQL statements to list total service charge amounts for each property. Note that a service charge is calculated by multiplying the service hour by the service charged per hour.

DBFN212 Database Fundamental

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.

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

Established over a decade ago, MyAssignmenthelp.com has emerged as the leading assignment solutions agency in Australia. We help students compose stellar essays, brilliant dissertations and more. We also provide them with expert proposal essay help. Some of our other popular services are inclusive of nursing essay help, MBA essay help, English essay help, law essay help and many more.

More DBFN212 DBFN212 Database Fundamental: Questions & Answers

Humanities

We want you to write a paper at most 7 pages in this paper: look to a hot topic in advanced database in security. HOT TOPIC, and find a problem. then solve this problem. let me know the title before start. the paper must contain the fallowing instructios: Abstract introduction Literature Review Prob …

View Answer

Professional Skills for System Analysis

Objectives:The assignment’s overall objective is that the students should acquire an overview ofprinciples, methods and techniques of systems development, and gather experience from adevelopment project in which a specific development method is used. On successfulcompletion of this assignment …

View Answer

Systems Engineering and Analysis

This is a group assignment.We have attached the overall requirements of the assignment (Assignment 4.docx)and a rough template (Engg450template.docx).We need to do the preliminary design part mentioned in the rough template. This assignment follows ‘Systems Engineering and Analysis’ book written by …

View Answer

Advanced Databases

The Sakila sample database was initially developed by Mike Hillyer and is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth.Using the MySQL Sakila database students are requested to implement a Data Mart by identifying an importa …

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





Gunner Rocha

Master’s in Statistics from the University of Houston.

950 – Completed Orders

Hire Me





Alexander Frey

I have acquired my Master’s Degree in Economics from the University of Cambridge

100 – Completed Orders

Hire Me





Horton Wolf

Ph.D. in Functional Human Biology from Study Functional Human Biology at Otago

950 – 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