$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?
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
