Category: Databases

1- Based on your understanding of specialization and generalization constraints, use your own words to define and discuss the two primary constraints: Disjointness Constraint and Completeness Constraint.2- Show the schema mapping of the following Payment EER schema diagram, using Option 8A: Multiple relations-Superclass and subclasses. 3-SQL constraints are used to specify
rules for the data in a table. From what has been studied, what is the benefit
of using constraints in DB. Also, explain three common SQL constraints.4- sing the relational algebra operations, write the following queries on the COMPANY relational database schema shown in the figure below.
Retrieve the address of employees in department 2 who work less than 5 hours per week on the ‘ProductX’ project.
Retrieve the names and salary of employees who work on every project.

Analysis Report in SAS Studio – Customer Orders
A multi-national company wishes to increase sales while maximizing profits. Your task is to analyze a sample of five years of their customer catalog, online, and retail sales data. A link to the customers.csv Download customers.csvdataset is provided. The variable names can be found in the first row of the file. You must determine if any of the variables in the dataset have a strong relationship with the sales amount and if any of the variables could serve as predictor variables for future increased sales. After conducting the descriptive and predictive analysis, you are expected to recommend a course of action based on your analysis of the existing dataset. That course of action could range from needing additional data for an adequate level of analysis to concrete steps for increasing sales while maximizing profits. Note: The customers.csv dataset is relatively large (over 950,000 records), as such, it may take time to process while working in SAS® OnDemand.
Your deliverables for this assignment include a report containing the following:
1-2-business questions including how this data can answer the questions
Alternate and null hypotheses for each business question
Descriptive statistics test results: charts, graphs, and tables including a discussion of your findings
Predictive statistics test results: charts, graphs, and tables including a discussion of your findings
Recommendations for further action
Your paper must be 4-6-pages in length (not including the title page and reference page), well-written and formatted in conformity with the guidelines in the CSU Global Writing CenterLinks to an external site.. In support of your response, cite and integrate at least 2credible sources (not including the course textbooks). The CSU Global LibraryLinks to an external site. is a good place to find these references.

Analysis Report in SAS Studio – Customer Orders
A multi-national company wishes to increase sales while maximizing profits. Your task is to analyze a sample of five years of their customer catalog, online, and retail sales data. A link to the customers.csv Download customers.csvdataset is provided. The variable names can be found in the first row of the file. You must determine if any of the variables in the dataset have a strong relationship with the sales amount and if any of the variables could serve as predictor variables for future increased sales. After conducting the descriptive and predictive analysis, you are expected to recommend a course of action based on your analysis of the existing dataset. That course of action could range from needing additional data for an adequate level of analysis to concrete steps for increasing sales while maximizing profits. Note: The customers.csv dataset is relatively large (over 950,000 records), as such, it may take time to process while working in SAS® OnDemand.
Your deliverables for this assignment include a report containing the following:
1-2-business questions including how this data can answer the questions
Alternate and null hypotheses for each business question
Descriptive statistics test results: charts, graphs, and tables including a discussion of your findings
Predictive statistics test results: charts, graphs, and tables including a discussion of your findings
Recommendations for further action
Your paper must be 4-6-pages in length (not including the title page and reference page), well-written and formatted in conformity with the guidelines in the CSU Global Writing CenterLinks to an external site.. In support of your response, cite and integrate at least 2credible sources (not including the course textbooks). The CSU Global LibraryLinks to an external site. is a good place to find these references.

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).
You are advised to make your work clear and well-presented.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
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

· 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).
· You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
· 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.
· Screenshots for answering SQL questions (f, g, and h).
· You are advised to make your work clear and well-presented; marks may be reduced for poor presentation.

-No plagiarism ,no match please
-Use APA style for references
_unique
-use time new Roman size 12
-The Assignment must be submitted only in WORD format
-mention question number clearly in their answer.
-follow the instructions and read the rules very well.
I uploaded the slides so it can help you in answering.

*Please complete submission form for Relationship Testing Workbook. Submission form and completed workbook attached.
Data Transformation Assignment
Instructions:
The assignment deliverable is to submit your completed Excel Workbook with the Variable Feature Creation Analysis tasks completed as a SINGLE EXCEL FILE.
Use the provided “Assignment Submission Form – Data Transformation” document to organize your output and answers.
Continue working on the same “Housing Market Dataset – Post Midterm” workbook from the “Variable Creation” Lab and HW. We will continue to build on this workbook for all Lab, Homework, and Final Project objectives. If you are not using the Post Midterm file, please begin now. You can copy your Relationship Significance Testing sheets into the Post Midterm workbook.
Save your work as you go and ultimately make sure you save it in your cloud storage environment (Microsoft OneDrive or Sharepoint, or GoogleDrive). My computer crashed is not a valid excuse for late or incomplete work.
Check off each of the tasks as you complete them. It is expected that the student has attended/or watched and attempted the lecture tutorials in order to understand how to complete the assignment tasks. Save and rename your Excel workbook as “LastName Firstname – Data Transformation Lab and Homework.”
Submit your Excel workbook AND your assignment submission form to the “Assignments” folder in D2L (Desire 2 Learn).
**Points will be deducted for failure to follow all instructions, regardless of how trivial you think they are.
Please ensure that:
You are only submitting one Excel workbook with all tasks completed with the instructed worksheet tabs.
You have named your submission according to the instruction above.
Your worksheets are organized and easy to follow.
Task 1: Quantitative Transformation (Refer to the Data Transformation Lecture Manual and Videos for Help)
Instructions: Perform all analysis in a newly created worksheet “Quant Transform Data”
READ THE BACKGROUND INFO FIRST
The variables Living Area, Masonry Veneer Area, and Sale Price all have either slightly or significantly skewed distributions. Refer to your data diagnosis and univariate analysis to confirm the skew. Perform 2 transformations for each of the 3 variables. Remember root transformations for right skewed data and power transformations for left skewed data. Paste your excel formulas in the assignment submission form.
Create a simple histogram for each newly transformed variable and the original. You do not need to format these perfectly, just make sure there is enough information to tell which transformation it is. Paste your simple histograms in the assignment submission form.
Calculate the mean and median of each variable transformation and format it in a table with borders and shading, rounding, etc. You can just use the =median() and =average() functions for a quick and easy method. Paste your table in the assignment submission form.
Create a single correlation matrix with all the quantitative variables expect ID (ID… it’s not a quantitative variable to begin with, just an identifier) and format it neatly (round your decimals, add a title, and some borders, etc..). Paste your table in the assignment submission form.
Provide a brief write up of the changes in distribution shape. Are they becoming more symmetric? Are the means and medians getting closer together?
Provide a brief write up of the changes in the correlation values. As we move through the transformations, are the relationships getting stronger or weaker with each transformation?
Task 2: Categorical Transformation (Preparation (Refer to the Data Transformation Lecture Manual and Videos for Help)
Instructions: Perform all analysis in a newly created worksheet “Cat Transform Data”
READ THE BACKGROUND INFO FIRST
REDUCE: Combine all underrepresented categories for House Style, Overall Quality, and Kitchen Quality with the most logical category for the variable. Paste your if statements in the assignment submission form.
House Style (2.5 Story is underrepresented)
Kitchen Quality (Poor is underrepresented)
Overall Quality (Very Poor, Poor, Fair, and Very Excellent are underrepresented)
CHECK: Create simple pivot tables for your newly reduced variable to check that the combinations were successful. These do not need to be professional formatted. This is just a sanity check. Paste your simple pivot tables in the assignment submission form.
NUMERICALLY ENCODE: Recode the newly reduced categorical variables and the foundation variable as numbers. Remember the nominal variables are always dummy coded and ordinal variables can be rank coded if they show an increasing or decreasing relationship with the target. Paste your if statements in the assignment submission form.
House Style
Foundation
Kitchen Quality
Overall Quality

please use your own words don’t copy and paste (no plagiarism)
‏- Please use keyboard (don’t use handwriting)
‏- All answered must be typed using Times New Roman (size 12, double-spaced)
‏- I want answer with APA reference for per question
##The assignment should not contain sexual orientation or the like

please use your own words don’t copy and paste (no plagiarism)
‏- Please use keyboard (don’t use handwriting)
‏- All answered must be typed using Times New Roman (size 12, double-spaced)
‏- I want answer with APA reference for per question
##The assignment should not contain sexual orientation or the like

please use your own words don’t copy and paste (no plagiarism)
‏- Please use keyboard (don’t use handwriting)
‏- All answered must be typed using Times New Roman (size 12, double-spaced)
‏- I want answer with APA reference for per question
##The assignment should not contain sexual orientation or the like