CP5633 Database Modelling: Relational Database

CP5633 Database Modelling: Relational Database

$20 Bonus + 25% OFF

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

Students Who Viewed This Also Studied

CP5633 Database Modelling

Questions:

This assignment has been designed to give students experience using Structured Query Language (SQL) and other database management systems (DBMS) facilities to create/alter a relational database and to query the DBMS. This assignment addresses the following learning objectives for this subject:

• Develop and implement a database model using the E-R model and facilities provided by a DBMS

• Formulate queries using a database query language.

This assignment consists of two main tasks:

1. Creating the database (by following three subtasks):

o Create a relational database for a given conceptual model (ERD) using MySQL Workbench

o Create a physical database model on MySQL Workbench by applying the forward engineer process

o Import raw data from the external file to a table using the MySQL Workbench facility or using SQL queries

2. Writing SQL queries for given problems.Further details about each task are presented in the following pages.

Submission

• An MySQL Workbench file containing the ERD you created (.mwb)

• A database dump file built and exported on MySQL Workbench (.sql)

• A WORD or text file containing all SQL query codes and result tables (.doc, .docx,or .txt)

Task 1: Creating the database [42 marks]

1. Use MySQL Workbench to create an ERD to present a relational database model supplied as below. This is a sample ERD for a simplified University Enrolment Database.

• A faculty means an academic member who usually runs (teaches) courses (subjects).

• A course means a subject run by University

• A course is offered by the schedule set by University

• A student make a registration for each term by enrolling to a number of courses offered PKs should be correctly specified. All necessary attributes should be specified by setting appropriate data types and appropriate field lengths. [Save the completed model as a uniEnrolDB.mwb file].

The final ERD you create should correctly correspond with the ERD provided above in terms of structure, though the way to present components (PK or FK) in the ERD created using MySQL Workbench is not exactly same as what is presented in the ERD

provided above

2. Create a physical database model using the forward engineering process on MySQL Workbench.

3. Insert the data (provided for this assignment) into the database. You may choose to use either the SQL INSERT syntax or the import facility provided by MySQL Workbench. (Caution: The name or order of attributes in the raw data files provided may not

exactly match with those shown in the ERD. You will have to be careful to check it when you import data from Excel files to each table of your database)

4. Finally, dump the database into one integrated file on MySQL Workbench. [Save the file as uniEnrolDB.sql file]

Task 2: Creating queries [40 marks]

Using the database you constructed in Task 1, create the following SQL queries in MySQL Workbench For each question, the sample result table is provided to help you get an idea of what the table head and data format of your query result should look like.

Note: This updated document shows the correct result expected by the correct query for each question. Please note that this result will be generated as it is, only if your database is developed correctly as specified in this assignment. If your database is not built up fully or incorrectly, the result may be different even if your SQL code is correct and ideal.When your marker does marking on your SQL submission, the marker will test your code in their own correct database and also will assess your SQL codes by checking if the code has correct logic and syntax.

Notes:

– Queries should be written so that they would work with all reasonable sets of test data, not just that which has been supplied as a sample data.

– Marks may be deducted if your SQL is excessively (or unnecessarily) complicated.

– Full marks will be awarded where the solution provided is correct in all respects.

– Partial marks may be allocated where students are deemed to have provided a significant effort toward a correct result, but the solution contains some error.

– No marks are awarded where either no solution is provided, or the solution provided is deemed to be mostly incorrect.

CP5633 Database Modelling

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.

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

Students from UK, US and Australia receive top-class service along with high-end online assignment help. Online web chat, direct email and telephonic conversation are three flexible communication modes to connect with MyAssignmenthelp.com. Whether you are fresh in college or about to finish the doctorate degree, we have solution for all subjects. We give our clients the liberty to chat and instruct guidelines to our writers directly. We cater college homework help and university coursework help to students worldwide. We never win our customers with false hope; rather we strive to offer you the best assignment help services ever. Getting services from MyAssignmenthelp.com is easy and safe! Visit our page, place your order, make the payment, and you are all set to receive the complete assignment.

More CP5633 CP5633 Database Modelling: Questions & Answers

Humanities

From Resources under Main Menu in Interact 2 go to Assignment 5 FolderThe ‘assignment5’ database file will be made available on Interact2 Resources under Assessments folder.Use MySQL software to complete this assignment.Follow the instructions on ‘how to import a database into MySQ …

View Answer

INFO321 Database Management System

Questions:
For this assignment, you will pick a research topic related to database systems. Then, you will gather five high-quality sources on this topic (peer-reviewed journal/conference articles in this case, see below), and write an annotated bibliography based on those sources.
 
What is …

View Answer

Management

Provide a brief summary of the use case, ideally in ‘user story’ format. Don’t go into details, just identify the actor, what is intended to be achieved, the benefit that confers, and hit the absolute high points of the normal flow – you don’t need more, the rest of the …

View Answer

Data Base Management

The following course learning outcomes are assessed by completing this assessment:•    A1.design and implement a relational database using a database management system•    A2.utilise a query language tools and techniques to obtain data and information from a d …

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





Noah Lyons

PhD in Biology with specialization in biological psychology

745 – Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

38983 Genuine Reviews With a Rating of 4.9/5.

Supply Chain

Programming: 3 Pages, Deadline:
9 days

Outstanding work. I will work with you again and again soon. I really appreciate your help; thank you so much.

User ID: 8***71 Riyadh, Saudi Arabia

Property Law

Course Work: 1 Page, Deadline:
20 days

all work is done very well, i think i will ask more help from you in future. Thanks

User ID: 8***63 Riyadh, Australia

Management

Assignment: 12 Pages, Deadline:
10 days

Credit to the expert who did a great job with this assignment! Covered most of the requirements! Thank you!

User ID: 3***95 Riyadh, Singapore

Business Law

Home Work: 4 Pages, Deadline:
9 days

Solution was provided in a timely manner. Expert managed to meet my expectation. Have yet to receive my result yet

User ID: 8***16 Riyadh, Singapore

Statistics

Programming: 4 Pages, Deadline:
4 days

This company has taken their work seriously and did a great job in producing a top quality assignment. highly recommended.

User ID: 7***37 Riyadh, Singapore

Assignment

Essay: 5 Pages, Deadline:
3 days

The writer did an awesome job with my assignment. This is my third time with them and they have kept to their quality of work.

User ID: 7***37 Riyadh, Singapore

Management

Assignment: 12 Pages, Deadline:
19 days

I am very happy to get my 100% Grade in my assessment. I wish say thank you so much.

User ID: 4***18 Riyadh, Australia

Project Management

Assignment: 4 Pages, Deadline:
9 days

Well written with sheer creativity. Always on time. Well done. I surely will recommend.

User ID: 1***16 Bella Vista, Australia

Healthcare

Essay: 2 Pages, Deadline:
15 days

Nice work! Thanks for the revision. It meets the requirement now. I am very satisfied with the work.

User ID: 7***67 Bella Vista, United States

Marketing

Home Work: 1 Page, Deadline:
23 days

Good job. Will use expert again. Thank you for your help and time that I needed on this assignment.

User ID: 5***56 San Francisco, United States

Accounting

Essay: 2 Pages, Deadline:
8 days

Received a 90/90 on my assignment, thank you to the professionals for completing this in a timely manner.

User ID: 8***75 San Francisco, United States

Assignment

Home Work: 1 Page, Deadline:
5 days

This service is an exquisite one. Answers came out early, accurate work was done and all

User ID: 8***17 Accra, Ghana

Assignment

Home Work: 1.2 Pages, Deadline:
7 hours

So far the papers were before time. The is not graded yet but overall i like the personal opinion. I did do little amend. I like the paper.

User ID: 7***0 Castro Valley, United States

Assignment

Home Work: 1.2 Pages, Deadline:
7 hours

So far there was 2 places where it was note quotes correctly with critiques, but i fixed it. overall the paper was very good

User ID: 7***0 Castro Valley, United States

Psychology

Essay: 2 Pages, Deadline:
1 day

Great job on working on this paper that allowed me to get a good mark. Would recommend this service

User ID: 6***81 Castro Valley, Canada

Nursing

Essay: 5 Pages, Deadline:
26 days

I am satisfied with the assignment. Prof. commented excellent job and i got good grades. Thank you.

User ID: 7***90 Castro Valley, Canada

Civil Law

Assignment: 10 Pages, Deadline:
15 days

My marks 15/20 thank you very much. and well done! My lecturer is veteran person he loves long essay 😉

User ID: 1***1 Bintulu, Malaysia

Business Law

Home Work: 12 Pages, Deadline:
7 days

OMG my marks 18/20 luckily im so worry at first but at the end it’s coming out nicely, thank you very much and well done! 😉

User ID: 1***1 Bintulu, Malaysia

Business Law

Assignment: 18 Pages, Deadline:
8 days

OMG just received marks today 28/30 thank you so much 😉 the way writing follow as what i need, well done!

User ID: 1***1 Bintulu, Malaysia

Management

Essay: 15 Pages, Deadline:
10 days

All learning outcomes achieved.Fair discussion of PESTLE/SWOT/Porter forces. But can evaluate by prioritizing the factors in the order of its impact a …

User ID: 6***76 Bintulu, Hong Kong

Supply Chain

Programming: 3 Pages, Deadline:
9 days

Outstanding work. I will work with you again and again soon. I really appreciate your help; thank you so much.

User ID: 8***71 Riyadh, Saudi Arabia

Property Law

Course Work: 1 Page, Deadline:
20 days

all work is done very well, i think i will ask more help from you in future. Thanks

User ID: 8***63 Riyadh, Australia

Management

Assignment: 12 Pages, Deadline:
10 days

Credit to the expert who did a great job with this assignment! Covered most of the requirements! Thank you!

User ID: 3***95 Riyadh, Singapore

Business Law

Home Work: 4 Pages, Deadline:
9 days

Solution was provided in a timely manner. Expert managed to meet my expectation. Have yet to receive my result yet

User ID: 8***16 Riyadh, Singapore

Statistics

Programming: 4 Pages, Deadline:
4 days

This company has taken their work seriously and did a great job in producing a top quality assignment. highly recommended.

User ID: 7***37 Riyadh, Singapore

Assignment

Essay: 5 Pages, Deadline:
3 days

The writer did an awesome job with my assignment. This is my third time with them and they have kept to their quality of work.

User ID: 7***37 Riyadh, Singapore

Management

Assignment: 12 Pages, Deadline:
19 days

I am very happy to get my 100% Grade in my assessment. I wish say thank you so much.

User ID: 4***18 Riyadh, Australia

Project Management

Assignment: 4 Pages, Deadline:
9 days

Well written with sheer creativity. Always on time. Well done. I surely will recommend.

User ID: 1***16 Bella Vista, Australia

Healthcare

Essay: 2 Pages, Deadline:
15 days

Nice work! Thanks for the revision. It meets the requirement now. I am very satisfied with the work.

User ID: 7***67 Bella Vista, United States

Marketing

Home Work: 1 Page, Deadline:
23 days

Good job. Will use expert again. Thank you for your help and time that I needed on this assignment.

User ID: 5***56 San Francisco, United States

Accounting

Essay: 2 Pages, Deadline:
8 days

Received a 90/90 on my assignment, thank you to the professionals for completing this in a timely manner.

User ID: 8***75 San Francisco, United States

Assignment

Home Work: 1 Page, Deadline:
5 days

This service is an exquisite one. Answers came out early, accurate work was done and all

User ID: 8***17 Accra, Ghana

Assignment

Home Work: 1.2 Pages, Deadline:
7 hours

So far the papers were before time. The is not graded yet but overall i like the personal opinion. I did do little amend. I like the paper.

User ID: 7***0 Castro Valley, United States

Assignment

Home Work: 1.2 Pages, Deadline:
7 hours

So far there was 2 places where it was note quotes correctly with critiques, but i fixed it. overall the paper was very good

User ID: 7***0 Castro Valley, United States

Psychology

Essay: 2 Pages, Deadline:
1 day

Great job on working on this paper that allowed me to get a good mark. Would recommend this service

User ID: 6***81 Castro Valley, Canada

Nursing

Essay: 5 Pages, Deadline:
26 days

I am satisfied with the assignment. Prof. commented excellent job and i got good grades. Thank you.

User ID: 7***90 Castro Valley, Canada

Civil Law

Assignment: 10 Pages, Deadline:
15 days

My marks 15/20 thank you very much. and well done! My lecturer is veteran person he loves long essay 😉

User ID: 1***1 Bintulu, Malaysia

Business Law

Home Work: 12 Pages, Deadline:
7 days

OMG my marks 18/20 luckily im so worry at first but at the end it’s coming out nicely, thank you very much and well done! 😉

User ID: 1***1 Bintulu, Malaysia

Business Law

Assignment: 18 Pages, Deadline:
8 days

OMG just received marks today 28/30 thank you so much 😉 the way writing follow as what i need, well done!

User ID: 1***1 Bintulu, Malaysia

Management

Essay: 15 Pages, Deadline:
10 days

All learning outcomes achieved.Fair discussion of PESTLE/SWOT/Porter forces. But can evaluate by prioritizing the factors in the order of its impact a …

User ID: 6***76 Bintulu, Hong Kong

Have any Query?

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