Category: Databases

hi i need answers for this project need Query and some Coding And answers no Pla

hi i need answers for this project need Query and some Coding And answers no Plagiarism i need it to be 100% correct answers and the Thats all thank you

Please rewrite the question in letter e) to be in 3NF, not in 4NF. Please also w

Please rewrite the question in letter e) to be in 3NF, not in 4NF. Please also write some explanation about the difference between 3NF and 4NF (the explanation can be in message).

Question 1:
Your first task is to select a case study (from the real world, pref

Question 1:
Your first task is to select a case study (from the real world, preferably something you encounter in your own life , or you can use the internet, or any resource). It can be related to enterprise systems, an organization/store, or any relevant topic.
B- After selecting the case study, describe it in your own words using the following points.
§ Clear headline (introduction): It should give the most important information that describes the case study.
§ Business process: describe in detail the activity, how the business process is done, and the main Input and Output. (If there are many business processes, select one with issues)
§ The current situation: It describes the current situation based on the business process. By providing the main points, including the client’s name/industry, the product/service used, and quick result stats.
§ The Issues: State the problem/issues, consequences, and any hesitations in the business process.
Question 2:
C- Model (As-Is, in other words what is currently being done) process using BPMN 2.0 using any tool such as Visio. (1 mark)
D- Then analyze As-Is process from at least two perspectives. (2 mark)
For example, if quality and time perspectives are taken then mention at least 1 issue related to quality and 1 issue related to time in the process.
Question 3:
A- Propose at least two ideas for improving the process of your selected case study from any perspective: for example: (a) equipment perspective, (b) employees’ perspective, (c) IT & IS technologies perspective, etc.
B- Also explain how your suggestions will solve business process issues.

Map the following ER diagram into physical model. Identify
all tables, columns,

Map the following ER diagram into physical model. Identify
all tables, columns, columns’ optionality, primary keys, and foreign keys:

Consider the following case for Aramco Company given the following Scenario:
A c

Consider the following case for Aramco Company given the following Scenario:
A company has a number of employees. The attributes of EMPLOYEE include Employee ID (identifier), Name, Address. An employee can have more than one address at a time. The company also has several projects. Attributes of PROJECT include Project-ID (identifier), Project Name, and Start Date. Each employee may be assigned to one or more projects, or may not be assigned to a project.
A project must have at least one employee assigned to it, and may have any number of employees assigned. For each project, there is always one employee assigned to manage that project. An employee’s billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project.
a) Clearly identified all the entities with their relevant attributes.
b) Create a relationship among the entities and specify the cardinality Ration
c) Draw an E-R diagram for a Company
d) Draw the corresponding EER diagram.

Assignment 5: Final data management
The purpose of Assignment 5 is to give you

Assignment 5: Final data management
The purpose of Assignment 5 is to give you the opportunity to provide any remaining data management tasks required to complete the table shells for your final project. The required tasks will vary student by student. Use the following steps as a guide.
Step 1: Create the final version of all variables you will use for analysis
Recode missing value codes (e.g. 7, 9) as missing ( . )
If needed, compute new variables using arithmetic functions
If needed, collapse categories of existing categorical variables
If needed, create categorical variables from continuous variables
Use a LABEL statement to make sure that all variables are labeled
Use a PROC format statement to create formats for all categorical variables in your data file
Step 2: Create a final analytic data file that includes only individuals with valid data for your primary exposure and outcome variables
Subset observations in your analytic data file to include only individuals that will be included in your analysis (e.g. you may need to limit your data file based on your population of interest)
Subset columns in your analytic data file to include only variables that will be used in your analysis in addition to SEQN, the participant unique identifier.
Step 3: Run PROC CONTENTS and PROC PRINT (obs=50) to examine your analytic data file
Step 4: Update the codebook you created in Assignment 2 using your revised analytic data file
Variable NameNHANES Data SourceVariable DescriptionVariable TypeN / NMiss% (N) or Mean, Std, Min, Median, Max
Var 1
Var 2
Var 3
Step 5: Submit your SAS Log (make sure errors are resolved before submitting) and your updated codebook.
Assignment 6: Completed tables for final project
This week you are submitting your completed final project tables!
These include:
Table 1 (required): Description of the study sample with stratification by levels of exposure variable
Table 2 (required): Results from your primary analysis
Figure (optional): A graph visualizing some aspect of your data analysis
Use the feedback you received from Assignment 4 to structure your tables. The specific structure will vary depending on the research question you choose. If you have lingering questions surrounding the specific format of your tables, please contact the instructor. The rubric is provided below.