Requirements: 2 PAGES | Assembly Language
Category: Databases
-
DATANALTICS
Download the attached test file WITHOUT changing the file name. [To download, click on the 3 horizontal dots to the right of the file name.] Using File Explorer, right click on the file name, select Properties and Unblock it.
- Open the file in Excel
- The password to open the file is start (lowercase letters).
- Click Enable Editing and then Enable Content to allow the macro to run.
- Click the Click Here button to start your test.
- SAVE your test file often WITHOUT changing the file name, preferably after the completion of each of the 10 questions. The questions are shown on the INSTRUCTIONS worksheet.
- Do NOT CLOSE your file until you are finished the test; once you close your file you will be unable to open it again.
- Upload your completed file in the space below called Additional Content by clicking on the paper clip icon. The test will AutoSubmit after 90 minutes, with or without your attached test file, so budget your time to allow time for uploading.
Requirements: 11
-
Generate Multi-Table Query Statements to Address Health-Rela…
Assignment Instructions
You must incorporate confirmatory work screenshots into a Microsoft Word assignment document (or equivalent). The following image illustrates an example problem screenshot showing both the SQL statement and confirmatory execution results:
Problem 1: List the active ingredients for each of the vaccines. Show the full vaccine name in the query output in alphabetical order. (Hint: The IngredientType attribute denotes whether an ingredient is active or inactive.)
Expected Output:
Problem 2: List the states/jurisdictions and reported COVID deaths on October 31, 2020 for states/jurisdictions with a population exceeding 10,000,000. The output needs to show the full state/jurisdiction names (not the abbreviations).
Expected Output:
Problem 3: Which states/jurisdictions had one or more reported COVID cases on February 29, 2020? Show the full state/jurisdiction names and number of reported COVID cases in the query output. Show the output in alphabetical order by full state/jurisdiction name (not the abbreviations).
Expected Output:
Problem 4: Show the calendar dates and reported daily COVID-19 deaths exceeding 100 for New York and California in the month of March 2020. Display the full state/jurisdiction names in the query output. Present the query results in chronological order (i.e., oldest to latest calendar dates).
Expected Output:
Problem 5: List the average daily reported COVID case values for Georgia, Florida, and Alabama for the time period between December 1, 2020 and December 31, 2020. Present the full state name and average values in the query output. Group the results by full state name in alphabetical order.
Expected Output:
Problem 6: List the full vaccine and state/jurisdiction names for vaccines administered on December 30, 2020. Show the reported number of doses administered in the query output. Sort the output in alphabetical order by full vaccine name and then by full state/jurisdiction name.
Expected Output:
Problem 7: Show the total reported COVID-19 cases exceeding 2,000,000 per state/jurisdiction in the 2021 calendar year. Display the full state/jurisdiction names in the query output. Group the results by full state/jurisdiction name. Present the results in alphabetical order by full state/jurisdiction name. (Hint: GROUP BY and HAVING clauses are required for this query.)
Expected Output:
Problem 8: Show the full vaccine names and dose volumes for the adult second dose series. Display the results in alphabetical order by full vaccine name. (Hint: Permissible attribute values for BIT data types are ‘TRUE’ and ‘FALSE’.)
Expected Output:
Problem 9: Show the full vaccine names and dose volumes for the adult second dose series. Display the results in alphabetical order by full vaccine name. (Hint: Permissible attribute values for BIT data types are ‘TRUE’ and ‘FALSE’.)
Expected Output:
Problem 10: Estimate the number of reported COVID-19 cases per 1,000 people in 2021 for Florida, New York, California, Texas, and Michigan. Group and sort the results by full state/jurisdiction name in alphabetical order. The calculation is performed via the following equation:
COVID-19 Cases/1,000 people = SUM(Daily Reported COVID-19 Cases * 1000 / Population)
Expected Output:
Requirements: few pages
-
Data anltics
Case 5 Assignment
- Municipal budgets are required by provincial law to balance cities must take in enough revenue through property taxes and other sources, like fees for services, to finance all of the citys operations in any given year. You have been hired by the to help prepare next year’s 2020 operating budget. Your starting point is to review the , conveniently in the format of an Excel worksheet, and review the revenues and expenses of each city program. The proposed increases are outlined in the Excel case file.When finished reading the case background, select True and move to the next question.
True or
False
Case 6 Assignment
Question 2
0 Points
Question 2
As recreational and medicinal marijuana use becomes increasingly legal and destigmatized worldwide, many growers of cannabis are prioritizing ways to make their operations more efficient.
Large-scale indoor marijuana cultivation puts a tremendous strain on the energy grid, requiring power-hungry equipment such as indoor lighting, irrigation, fans, humidifiers and more, often running around the clock. Solar panels, therefore, can be a valuable investment for marijuana growers. Though solar energy can represent a significant upfront investment for your business, it can pay for itself in both the short-term and the long run by allowing you to reduce or even eliminate some of your energy consumption.
This case is about a cannibus business considering the purchase of solar panels to replace 100% of their it’s hydro usage. Details related to costs are presented in the Excel case file.
When finished reading the case background, select True and move to the next question.
True
False
These Assigment has Case 5 and Case 6 there are Both files do the diffrent and both of them have marcos enabled so write My name both Files Maaz Hafeji
Requirements: 11
- Municipal budgets are required by provincial law to balance cities must take in enough revenue through property taxes and other sources, like fees for services, to finance all of the citys operations in any given year. You have been hired by the to help prepare next year’s 2020 operating budget. Your starting point is to review the , conveniently in the format of an Excel worksheet, and review the revenues and expenses of each city program. The proposed increases are outlined in the Excel case file.When finished reading the case background, select True and move to the next question.
-
Data Naltics
Case 5 Assignment
- Municipal budgets are required by provincial law to balance cities must take in enough revenue through property taxes and other sources, like fees for services, to finance all of the citys operations in any given year. You have been hired by the to help prepare next year’s 2020 operating budget. Your starting point is to review the , conveniently in the format of an Excel worksheet, and review the revenues and expenses of each city program. The proposed increases are outlined in the Excel case file.When finished reading the case background, select True and move to the next question.
True or
False
Case 6 Assignment
Question 2
0 Points
Question 2
As recreational and medicinal marijuana use becomes increasingly legal and destigmatized worldwide, many growers of cannabis are prioritizing ways to make their operations more efficient.
Large-scale indoor marijuana cultivation puts a tremendous strain on the energy grid, requiring power-hungry equipment such as indoor lighting, irrigation, fans, humidifiers and more, often running around the clock. Solar panels, therefore, can be a valuable investment for marijuana growers. Though solar energy can represent a significant upfront investment for your business, it can pay for itself in both the short-term and the long run by allowing you to reduce or even eliminate some of your energy consumption.
This case is about a cannibus business considering the purchase of solar panels to replace 100% of their it’s hydro usage. Details related to costs are presented in the Excel case file.
When finished reading the case background, select True and move to the next question.
True
False
These Assigment has Case 5 and Case 6 there are Both files do the diffrent and both of them have marcos enabled so write My name both Files Maaz Hafeji
Requirements: 11
- Municipal budgets are required by provincial law to balance cities must take in enough revenue through property taxes and other sources, like fees for services, to finance all of the citys operations in any given year. You have been hired by the to help prepare next year’s 2020 operating budget. Your starting point is to review the , conveniently in the format of an Excel worksheet, and review the revenues and expenses of each city program. The proposed increases are outlined in the Excel case file.When finished reading the case background, select True and move to the next question.
-
Week 5 Peer Responses
Respond to two of your classmatesthreads with posts of at least 100 words discussing their comments and ideas.Try to ask open-ended questions that encourage discussion and remember torespond to people who post on your thread.
Requirements: minimum 100-word response to both peer
-
EER Design for a Delivery System
Need help creating an EER diagram (ER notations not UML). Must include entities, attributes, PKs, relationships, cardinality, participation constraints, and specialization (overlapping + total for Person Student/Faculty/Staff).
Requirements: Detailed
-
Everything provided below
You have been tasked with designing a data model for UniFit, a newly established wellness and fitness center in the UAE. UniFit offers a variety of services, including gym training, group fitness classes, personal training sessions, and nutrition consultations.
The management requires a database system to manage member registrations, service bookings, trainer schedules, room allocations, and attendance tracking. You conducted an interview with the operations manager and collected a sample booking record to identify key data requirements. The interview is shown in Figure 1. The sample service booking example customer is shown in Figure 2.Figure 2: Unifit service booking
Figure 2: Unifit service bookingRequirements
Based on the interview in Figure 1 and the sample booking in Figure 2, complete the following:
1. Additional Interview Questions
- Propose additional interview questions that would help gather more data requirements for the system to help identify relationships, attributes or deletion rules.
2. Identify Subjects (Tables)
- Extract a list of subjects (tables).
- Clearly document how each table was identified from the interview and booking sample (e.g., underlining or highlighting).
- Remove any duplicate table names.
3. Identify Characteristics (Fields)
- Extract the list of characteristics (fields) for each table.
- Remove duplicate fields where applicable.
4. Table Structures
- Create table structures showing table names and their associated fields.
- Clearly identify primary keys and foreign keys.
- Provide a short description for each table.
5. Populate Tables
- Populate each table with three realistic records.
6. Normalization (Up to 3NF)
- Ensure all tables are normalized up to Third Normal Form (3NF).
- Provide a clear justification explaining how 1NF, 2NF, and 3NF are achieved for each table.
7. Relationship Matrix
- Create a relationship matrix.
- Justify each relationship by explaining:
- Relationship type.
- Participation type and degree.
- Foreign key specification forms.
8. Entity-Relationship Diagram (ERD)
- Draw an ER diagram showing:
- Entities and attributes
- Relationships
- Participation types and degrees
- Deletion rules
Justify your deletion rules choices.
Submission
Submit a report (single PDF file) that contains all the above requirements.
(Please be advised that submitting more than one file or an external link to an ERD or a Google Document will result in a reduction in your grade.)
Instructions for Students
- You may use AI tools (such as ChatGPT or Gemini or any other) to help answer the questions. You must only utilize the data modeling concepts that have been taught in class so far to receive complete credit. Answers with advanced concepts not covered in the course will get a score of 0. In addition, you must understand every single line of your submitted work. Please be prepared to explain your work, as you might be called for a technical interview to explain your answers. The extent to which you know the answer will be used to evaluate the assignment. If you have used an AI tool (e.g., ChatGPT, Gemini …), please submit all the prompts (screenshots) you used to help you in this assignment.
- Make sure that you submit your own original work. Suspected plagiarism cases will be treated as possible academic misconduct and will be reported to the College Academic Integrity Committee for formal investigation. As part of this procedure, your instructor may require you to meet with them for an oral exam on the assignment.
- Failure to comply with the instructions will result in a 0 grade on the relevant portions of the assignment. Your instructor will grade your submission based on what you submitted on the Forum within the allowed deadlines. Do not submit your assignment via email. Failure to submit an assignment or submitting an assignment for another student from the same class or another class will result in a 0 grade without the opportunity to resubmit.
- Clearly list any assumptions you have made about concepts not explicitly mentioned in the assignment.
Assignment Information
Learning Outcomes Added
- : Design a data model that is accurate, complete, and fulfills the system requirements.
- : Apply data normalization concepts to structure the data and reduce redundancies
Requirements: n/a