Category: Databases

ZIP FILE https://we.tl/t-g4QvmVfVJz
Thus far, we have exclusively been working with vector data. In Module 5, you also learned about raster data models. In this lab, we will explore how we use raster data in a GIS, and how we layer different types of data on top of one another to produce a map. Additionally, we will take a closer look at map elements and the design choices that go into them.
In Module 5, we also discussed map analysis. In this lab, you will have the chance to analyze each other’s’ maps and learn from the analyses your peers do of your map.
As we build those skills, we will also be exploring a real-world geographic question:
How is climate change distributed across the US?
In the lab, we will consider how average temperature is changing and where we see particularly pronounced temperature increases and decreases.
The mapping component of this lab should take approximately 2 hours to complete. The map analysis component of this lab should take approximately 1 hour to complete. This lab is worth 60 points.
Evidence of skill development will be assessed on:
Submit one map made using QGIS. (Required – 30 points)
Once you have submitted your map, you are asked to analyze the maps of two of your self-chosen peers. For each map, please consider the map and draft a 150-300 word response that answers the following questions:
What is the argument of this map?
How can you tell?
What map elements/components support the argument?
What doesn’t support the argument? Why?
NOTE: Please try to comment on maps that have not yet been commented on or maps that have fewer comments. Piling up and homogenizing comments can lead to a loss in post-reviewer scores. The deadline for peer reviews is Feb. 8th, 5 pm (two days after the due of the lab 5 map).

Assignment| – Normalization.
1. What is the purpose of normalization in databasedesign?
2. What are the main goals of normalization?
3. Define data redundancy and explain why it isimportant to eliminate or minimize it in a database.
4. What is the First Normal Form (1NF)? Describe the keycharacteristics and requirements of 1NF.
5. How does the Second Normal Form (2NF) differ from1NF? What problem does it address?
6. Explain the concept of functional dependencies andtheir role in normalization.
7. What is the Third Normal Form (3NF)? How does itbuild upon 2NF?
8. What are the potential trade-offs or challenges of over-normalization in database design?
9. Discuss the concept of denormalization and when it is appropriate to use it in database optimization.
10. Explain the importance of striking a balance between normalization and the specific needs of an application.

i have added assignment solve only 1 and 3. for ques 3, i have added screenshots of given tables, u need to add data into the tables as per question

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answerInstructionsLearning Outcome(s):
CLO4: Develop a standard database using DBMS.
CLO3: Analyze algorithms for query processing.
CLO1: Recognize database file organization and indexing.
Suppose you are a database administrator in a large company, and you have been asked to create a new database. Create your database scenario and follow the following instructions.
You should use the same project document to prepare your answer. A word file and a PDF file should be provided.
Each group can have a minimum of 3 and a maximum of 4 students.
You must use MySQL for database creation and manipulation.
Create ONE database scenario. All your answers should be according to the selected scenario.
Support your answer with a detailed explanation and screenshots.
14 Marks
Learning Outcome(s):
CLO4: Develop a standard database using DBMS.
CLO3: Analyze algorithms for query processing.
CLO1: Recognize database file organization and indexing.
Project Description
Part 1: Database Description and Design
1-Describe your database scenario (Don’t select any database which we studied during lab session or lecture) with at least 5 Entities. (1 Mark)
2-Design an Entity Relationship (ER) diagram to capture the scenario requirements. Make sure cardinalities, relationships, and primary keys are clear. State any assumptions that may affect the ER diagram. Your ER should include at least 4 entities and 1 “Many-to-many” relationship.
(2 Marks)
3-Convert the ER diagram to Class diagram. (1 Mark)
Part 2: Create and Populate Relations
1-Map the ER diagram to a relational model and create the relations in MySQL. (1 Mark)
2-Enter at least 20 tuples (records) in each relation/table. Your solution should include the screenshots of your relations with data. (1 Mark)
Part 3: Indexes and Queries
1-Write any retrieval query that includes a selection condition and show how MySQL internally performed this query. (1 Mark)
2-Create an index for the same column used in the previous selection condition. (1 Mark)
3-Repeat the same retrieval query in step (1) and show how MySQL internally performed the query this time. Discuss how the created index improves the performance of your database. (1 Mark)
4-Write any retrieval query that includes at least one join condition and one selection condition and show the result of this query. (1 Mark)
5-Show the Query Statistics and Execution Plan for the above query. (1 Mark)
Part 4: Roles and Privileges
1-Create two roles and assign the following privileges to the roles (1 Mark):
-Give all privileges to the first role.
-Give only insert privileges to the second role who can further assign the same privileges to others.
2-Create two accounts and assign the above roles to the created accounts (each account with a different role). (1 Mark)
3-Verify the privileges assigned to each account. (1 Mark)

hi I have a final exam on database management and i only have an 1 hour to submit the final. there is a sample for the exam but it is not the same as the real one.

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.
Instructions
Learning Outcome(s):
CLO4: Develop a standard database using DBMS.
CLO3: Analyze algorithms for query processing.
CLO1: Recognize database file organization and indexing.
Suppose you are a database administrator in a large company, and you have been asked to create a new database. Create your database scenario and follow the following instructions.
You should use the same project document to prepare your answer. A word file and a PDF file should be provided.
Each group can have a minimum of 3 and a maximum of 4 students.
You must use MySQL for database creation and manipulation.
Create ONE database scenario. All your answers should be according to the selected scenario.
Support your answer with a detailed explanation and screenshots.
14 Marks
Learning Outcome(s):
CLO4: Develop a standard database using DBMS.
CLO3: Analyze algorithms for query processing.
CLO1: Recognize database file organization and indexing.
Project Description
Part 1: Database Description and Design
1-Describe your database scenario (Don’t select any database which we studied during lab session or lecture) with at least 5 Entities. (1 Mark)
2-Design an Entity Relationship (ER) diagram to capture the scenario requirements. Make sure cardinalities, relationships, and primary keys are clear. State any assumptions that may affect the ER diagram. Your ER should include at least 4 entities and 1 “Many-to-many” relationship.
(2 Marks)
3-Convert the ER diagram to Class diagram. (1 Mark)
Part 2: Create and Populate Relations
1-Map the ER diagram to a relational model and create the relations in MySQL. (1 Mark)
2-Enter at least 20 tuples (records) in each relation/table. Your solution should include the screenshots of your relations with data. (1 Mark)
Part 3: Indexes and Queries
1-Write any retrieval query that includes a selection condition and show how MySQL internally performed this query. (1 Mark)
2-Create an index for the same column used in the previous selection condition. (1 Mark)
3-Repeat the same retrieval query in step (1) and show how MySQL internally performed the query this time. Discuss how the created index improves the performance of your database. (1 Mark)
4-Write any retrieval query that includes at least one join condition and one selection condition and show the result of this query. (1 Mark)
5-Show the Query Statistics and Execution Plan for the above query. (1 Mark)
Part 4: Roles and Privileges
1-Create two roles and assign the following privileges to the roles (1 Mark):
-Give all privileges to the first role.
-Give only insert privileges to the second role who can further assign the same privileges to others.
2-Create two accounts and assign the above roles to the created accounts (each account with a different role). (1 Mark)
3-Verify the privileges assigned to each account. (1 Mark)

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.
Instructions
Learning Outcome(s):
CLO4: Develop a standard database using DBMS.
CLO3: Analyze algorithms for query processing.
CLO1: Recognize database file organization and indexing.
Suppose you are a database administrator in a large company, and you have been asked to create a new database. Create your database scenario and follow the following instructions.
You should use the same project document to prepare your answer. A word file and a PDF file should be provided.
Each group can have a minimum of 3 and a maximum of 4 students.
You must use MySQL for database creation and manipulation.
Create ONE database scenario. All your answers should be according to the selected scenario.
Support your answer with a detailed explanation and screenshots.
14 Marks
Learning Outcome(s):
CLO4: Develop a standard database using DBMS.
CLO3: Analyze algorithms for query processing.
CLO1: Recognize database file organization and indexing.
Project Description
Part 1: Database Description and Design
1-Describe your database scenario (Don’t select any database which we studied during lab session or lecture) with at least 5 Entities. (1 Mark)
2-Design an Entity Relationship (ER) diagram to capture the scenario requirements. Make sure cardinalities, relationships, and primary keys are clear. State any assumptions that may affect the ER diagram. Your ER should include at least 4 entities and 1 “Many-to-many” relationship.
(2 Marks)
3-Convert the ER diagram to Class diagram. (1 Mark)
Part 2: Create and Populate Relations
1-Map the ER diagram to a relational model and create the relations in MySQL. (1 Mark)
2-Enter at least 20 tuples (records) in each relation/table. Your solution should include the screenshots of your relations with data. (1 Mark)
Part 3: Indexes and Queries
1-Write any retrieval query that includes a selection condition and show how MySQL internally performed this query. (1 Mark)
2-Create an index for the same column used in the previous selection condition. (1 Mark)
3-Repeat the same retrieval query in step (1) and show how MySQL internally performed the query this time. Discuss how the created index improves the performance of your database. (1 Mark)
4-Write any retrieval query that includes at least one join condition and one selection condition and show the result of this query. (1 Mark)
5-Show the Query Statistics and Execution Plan for the above query. (1 Mark)
Part 4: Roles and Privileges
1-Create two roles and assign the following privileges to the roles (1 Mark):
-Give all privileges to the first role.
-Give only insert privileges to the second role who can further assign the same privileges to others.
2-Create two accounts and assign the above roles to the created accounts (each account with a different role). (1 Mark)
3-Verify the privileges assigned to each account. (1 Mark)

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different character sets, convert text into image or languages other than English or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.
InstructionsLearning Outcome(s):
CLO4: Develop a standard database using DBMS.
CLO3: Analyze algorithms for query processing.
CLO1: Recognize database file organization and indexing.
Suppose you are a database administrator in a large company, and you have been asked to create a new database. Create your database scenario and follow the following instructions.
You should use the same project document to prepare your answer. A word file and a PDF file should be provided.
Each group can have a minimum of 3 and a maximum of 4 students.
You must use MySQL for database creation and manipulation.
Create ONE database scenario. All your answers should be according to the selected scenario.
Support your answer with a detailed explanation and screenshots.
14 Marks
Learning Outcome(s):
CLO4: Develop a standard database using DBMS.
CLO3: Analyze algorithms for query processing.
CLO1: Recognize database file organization and indexing.
Project Description
Part 1: Database Description and Design
1-Describe your database scenario (Don’t select any database which we studied during lab session or lecture) with at least 5 Entities. (1 Mark)
2-Design an Entity Relationship (ER) diagram to capture the scenario requirements. Make sure cardinalities, relationships, and primary keys are clear. State any assumptions that may affect the ER diagram. Your ER should include at least 4 entities and 1 “Many-to-many” relationship.
(2 Marks)
3-Convert the ER diagram to Class diagram. (1 Mark)
Part 2: Create and Populate Relations
1-Map the ER diagram to a relational model and create the relations in MySQL. (1 Mark)
2-Enter at least 20 tuples (records) in each relation/table. Your solution should include the screenshots of your relations with data. (1 Mark)
Part 3: Indexes and Queries
1-Write any retrieval query that includes a selection condition and show how MySQL internally performed this query. (1 Mark)
2-Create an index for the same column used in the previous selection condition. (1 Mark)
3-Repeat the same retrieval query in step (1) and show how MySQL internally performed the query this time. Discuss how the created index improves the performance of your database. (1 Mark)
4-Write any retrieval query that includes at least one join condition and one selection condition and show the result of this query. (1 Mark)
5-Show the Query Statistics and Execution Plan for the above query. (1 Mark)
Part 4: Roles and Privileges
1-Create two roles and assign the following privileges to the roles (1 Mark):
-Give all privileges to the first role.
-Give only insert privileges to the second role who can further assign the same privileges to others.
2-Create two accounts and assign the above roles to the created accounts (each account with a different role). (1 Mark)
3-Verify the privileges assigned to each account. (1 Mark)

you’ll need to work on a ipynb file that I have attached, refer to “copy of question PDF” for instructions, everything else is attached for your reference, including codes and Class Content for your reference to answer the assignment, YOU NEED TO FOLLOW/REFER TO THE CODES AND CLASS CONTENT TO ANSWER THE QUESTIONS DO NOT ANSWER BASED ON YOUR BEST GUESS OR PAST KNOWLEDGE, follow each instruction on the PDF very carefully, remember you are using posterSQL, also there is a zip folder I couldn’t attach so here is the link: https://we.tl/t-78CDZuYPgR

you’ll need to work on a ipynb file that I have attached, refer to “copy of question PDF” for instructions, everything else is attached for your reference, including codes and Class Content for your reference to answer the assignment, YOU NEED TO FOLLOW/REFER TO THE CODES AND CLASS CONTENT TO ANSWER THE QUESTIONS DO NOT ANSWER BASED ON YOUR BEST GUESS OR PAST KNOWLEDGE, follow each instruction on the PDF very carefully, remember you are using posterSQL