Category: SQL

This finals assignment is from a first year SQL class I have been struggling with for different reasons and have been using AI to help with understanding. Unfortunately, this assignment is not as easy for me and my pal Gemini to follow together.
Here is the description of the assignment straight from the first page.
“Your company wants to merge its old product order data into a new data mart to facilitate analysis. You have been tasked with writing an ETL (extract, transform, and load) code sequence, and executing it on three years’ worth of order data. 
In this assignment, you will produce SQL code which scrubs and imports each of the three years’ worth of data, and produces an output file called stagingTable. 
Along with these instructions, there is another document, ‘Additional Clarification on the Week 6 Candy Assignment’. Please read that document carefully. 
You should also read the ‘Data Notes’ in part 3 of this document. It is very important that you understand the data and how the data changes over the three years, so you can create a ‘stagingTable’ the effectively combines the data that might have been captured in different ways over the years.
Let’s get started!

Provide sql queries that could run on AWS instance
https://www.sec.gov/dera/data/financial-statement-data-sets
this is the link to the dataset
only consider these three from the zipped file 
num.txt sub.txt tag.txt – Using data from 2024Q1
and provide a visual for this output

Unit 6 Mastery
Assignment Instructions:
Requirements:
Learner should create webpages that allows inserting, updating, and deleting
against the Firebase table(s) created in Unit 4.  Appropriate information should be returned
based on the function completed (example: “Record Deleted”).  Capture screen shots of your entries and the
results and place into a Word document. 
Place the files in compressed folder for submission purposes.   

1. Activity Modeling
Use an activity diagram to design the business activities and their relationship. You need to
consider how the DVD store will operate. Factors to consider include but not limited to: 1.
How do customers order DVDs online; 2. How does the store procure (order) DVDs when out
of stock; 3. How is the receipt of inventory handled and managed; 4. How is customer
returned merchandise handled (i.e., inventory, customer credit, etc); 5. How will customers
shipments be handled; 6. How is customer billing handled; 7. How do vendors get paid. 5.
What forms of payment does the store accept (check, credit/debit cards etc.); 8. How do
customers know what products are available; 9. Other operations and activities not listed
here but within the HW project scope. Note: the first draft is due a week before the
assignment is handed in (see syllabus). The draft is not graded and should be done using
pencil and paper. The draft ensures 1. The HW gets started early; 2. Provides opportunity
to get answers to questions you may have before the due date. 3. You have one more week
to complete using Visio and submit it in PDF

this project is a final project for a course . It doesnt need to be too complex . It is based on sql. Attached is a similiar project i completed and would need to be like. Instead of using a data set for a coding it would be using a data set for sql and very similiar format would be fine. let me know if there are any questions. Would need an appendix and all that good stuff. As long as its sql you can choose any type of data based on the project you chose.

Requirements for Database project
Create a database of your choice that contains. You can use any DBMS:
At least 3 normalized tables
At least 3 queries
Create and ER diagram of the database with relationships indicated.
Create a user manual that I can use to work with the database.
Save the database to a Zipped file and upload it to Canvas.
I will attach the database info and you can create the project from that

Requirements for Database project
Create a database of your choice that contains. You can use any DBMS:
At least 3 normalized tables
At least 3 queries
Create and ER diagram of the database with relationships indicated.
Create a user manual that I can use to work with the database.
Save the database to a Zipped file and upload it to Canvas.
I will attach the database info and you can create the project from that

Prior to beginning this assignment, visit the following vendor websites: Microsoft SQL
Links to an external site., MySQL
Links to an external site., Oracle
Links to an external site., and SQLite
Links to an external site..
These sites will provide you with additional information that will
assist you with this interactive assignment. For this interactive
assignment, you will discuss the use of DBMS and its benefits. Next,
provide a comparison matrix between MySQL, MSSQL, Oracle, SQLite based
on current version, operating system, cost, written in, licensing,
graphical management tools, and maximum number of records.
Attach your comparison matrix in your initial post. Be sure to include references you used to populate the comparison matrix.

Prior to beginning this discussion, read Chapter 1: Database Systems and
Chapter 2: Data Models from the course text, and review the Database Design
Download Database Design presentation.
Both relational and non-relational databases provide a mechanism for
storage and retrieval of data. In order for organizations to remain
competitive and/or make appropriate business decisions, it is important
to understand the differences between the two. Discuss the difference
between a Relational and Non-Relational Database in terms of simplicity
of design, finer control over availability, speed and cost.

please see word doc attached
***not necessarily about 1101 words but 4 separate task in 4 separate files