Category: Databases

Homework Content
Prepare a logical design for your project in the form of a crow’s foot ER diagram for your database. The design must be in a minimum of 3NF and should include primary keys, foreign keys and relationships. Be sure to address any comments made on your proposal assignment. This Assignment has a project proposal So the design will go as the proposal paper. I will upload the document ‘project proposal’

The main goal of this assignment is to allow you to try a NoSQL database or a cloud database provided as a service.
Each two students have to submit as a group. Please form a group. Students with no groups by 26-3-2024 will be assigned a group randomly.
After group formation, select a NoSQL database or a cloud database provided as a service from one of the following databases listed on https://en.wikipedia.org/wiki/Cloud_database. View the table titled Cloud database vendors by deployment and data model and select any except ones under the first square (SQL Data Mode + Virtual Machine Deployment like EDB Postgres Advanced Server and IBM Db2). So, others like MongoDB and Amazon DynamoDB are okay.
Before submitting your selection, experiment and make sure you can access the database. Do not pick one that does not allow you to test for free
.https://lms.psau.edu.sa/bbcswebdav/pid-5652146-dt-…

The main goal of this assignment is to allow you to try a NoSQL database or a cloud database provided as a service.
Each two students have to submit as a group. Please form a group. Students with no groups by 26-3-2024 will be assigned a group randomly.
After group formation, select a NoSQL database or a cloud database provided as a service from one of the following databases listed on https://en.wikipedia.org/wiki/Cloud_database. View the table titled Cloud database vendors by deployment and data model and select any except ones under the first square (SQL Data Mode + Virtual Machine Deployment like EDB Postgres Advanced Server and IBM Db2). So, others like MongoDB and Amazon DynamoDB are okay.
Before submitting your selection, experiment and make sure you can access the database. Do not pick one that does not allow you to test for free
.https://lms.psau.edu.sa/bbcswebdav/pid-5652146-dt-…

You will include two types of data visualization elements in your project:
Type 1: Data will be analyzed first and then visualized;
Type 2: Data will be visualized first, then visual analytics will be applied to it.
The goal of this phase of the project is to demonstrate that you have conducted an analysis for each type of visualization, i.e. data analysis for elements of Type 1, and visualizations for elements of Type 2.
Submit a short report on the story structure, description of the data sources, data preparation and analysis, and the description of the future visualizations (for Type 1), and visualizations (for visual analytics – Type 2). The actual visual analysis will be due at Phase 3 (the Final Report in Unit 8).
You are encouraged to use Tableau and/or Python to create data visualization.
Student Remarks:
Data Source: https://www.kaggle.com/datasets/harshalhonde/starb…

You will include two types of data visualization elements in your project:
Type 1: Data will be analyzed first and then visualized;
Type 2: Data will be visualized first, then visual analytics will be applied to it.
The goal of this phase of the project is to demonstrate that you have conducted an analysis for each type of visualization, i.e. data analysis for elements of Type 1, and visualizations for elements of Type 2.
Submit a short report on the story structure, description of the data sources, data preparation and analysis, and the description of the future visualizations (for Type 1), and visualizations (for visual analytics – Type 2). The actual visual analysis will be due at Phase 3 (the Final Report in Unit 8).
You are encouraged to use Tableau and/or Python to create data visualization.
Student Remarks:
Data Source: https://www.kaggle.com/datasets/harshalhonde/starb…

Deliverable
Submit upto 5 scenarios that we can model in class. Each correct scenario is worth one point. If you submit 5 scenarios you get all the points. You must have 3 or more entities in your scenario to get credit. Note I am looking for the narrative and a ERD.
Note: You may have two, narratives that translate into to entities. The remaining three narratives must have 3 or more entities.
For Credit
You must create the ERD using Lucid Chart or Smart Draw
Example of an acceptable Narrative
Here is an example of what I am looking for: A soccer player is assigned to a team. Each team is assigned a coach.
Please read her how to create ERD.
https://www.lucidchart.com/pages/how-to-draw-ERD

discuss a personal example where Big Data Analytics has positively (or negatively) affected YOU in some way. Relate your experience to the concepts that you have learned in the class.

The Module 3 Assignment provides experience with data integration tasks using Pentaho Data Integration. You need to perform some data cleaning operations on two data sources and then load the data into the fact table of the inventory data warehouse. You should see the class website for details about downloading and installing Pentaho Data Integration.
You need to create and populate the inventory database tables using Postgresql before working on this assignment. The class website contains files with CREATE statements for tables and sequences and INSERT statements. You should create the inventory fact tables and sequences then execute the INSERT statements to populate the tables. Note that the Currency_Dim table is an additional table not part of the Inventory Data Warehouse design.
Grading
Your performance will be assessed by submission of documents and kettle files (.ktr).You need to execute your transformations against a clean version of the Inventory Data Warehouse tables. I will check the documentation that you submit to the gradebook to confirm that you created the transformations and executed them.
Completion
Upload zip files each containing two files: the snapshot documentation and the .ktr file of your transformation designs. You should have one zip file per transformation. Save .ktr files using the File  Save command. You should also take screen snapshots of the complete transform design pane and the execution of the transformation showing the step metrics including the number of rows inserted into the Inventory_Fact table. Make sure that your snapshots of the execution show the metrics for each step of your transformations. You may need more than one snapshot to show results of each step. Put these snapshots (two for each transformation) in a separate Word document.

there are 8 questions , only 2 of them is longer. I have to do it with my user name anyways. I just need an outline to finish the tasks.I just need you to tell me how to do those 2 questions step by step.

Thus far in the quarter, you have primarily been making maps to showcase patterns in data. In this module, we turn our attention to the analytical capabilities of a GIS. In Module 7, you learned about vector analysis tools. In this lab, you will practice using those tools while considering the placement of ballot dropboxes in Seattle and King County. Specifically, we will be exploring the question:
How well distributed are the King County ballot dropboxes?
In this lab, you will be given multiple shapefiles and two tables with spatial, electoral and demographic data relating to King County voters. The lab will walk you through the various analytical tools discussed in Module 7 as we analyze the data.
This lab should take approximately 3 hours to complete. This lab is worth 70 points.
Evidence of skill development will be assessed on:
Submit answers to the lab questions and two maps made using QGIS. (Required – 70 points)