Category: Databases

Draw complete ER/EER diagram. Identify entities (superclass/subclass), attributes, primary keys, relationships and participation controls
Map the ER diagram into relations
Apply normalization (3rd normal form)
Write SQL statements for the following:
Creating all tables with appropriate data types and constraints
Filling all tables with minimum 3 records.

Hi i need answers for this diagrams and Presentations DIAGRAMS must be original work not a picture from google Presentations need to be 5 slide 1 intro and the other 4 make it part 1 part 2 part 3 part 4 EACH Slide must be 6 lines

I need someone who is expert with database management, this is a final project and I want the person who can handle it follow everything that shows in the files that I attached bellow. Thank you

hello, i have a project the instructions are clear in the file but in the last qusetion there are an error, so our dr said that we can assume attributes if we could not get an outcome, so you can assume an attribute only to the last question without chaning anything else in other questions or adding anything not all the last question only in part h . of corse the answer should not have any palagresim
,and there an solved file just for an example how to solve it if you want it i will share it with 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.

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.

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, columns’ optionality, primary keys, and foreign keys:

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.

There are 3 questions in both of the attached files. In question 1, you need to write an expression in the relational algebra to express each of the following queries. In question 2, you are given a relational schema, from where you need to find the candidate keys, find all kinds of normal forms((1NF, 2NF, 3NF, BCNF) and explained in details the questions related to that. Use the decomposition algorithm to obtain some normal form of that schema, answers questions related to that. In question 3, Using ChatGPT, generate prompts to ask it to explain how functional dependencies are utilized in practical database management systems and how functional dependencies can be used together with the Entity Relationship Model. Using the answers given by ChatGPT, provide detailed explanations of whether you agree or disagree with the answers (if you only state that you agree or disagree with the answers without providing detailed explanations, you will get a zero score for this question). If you disagree, include modifications to the answers. Present your prompts, ChatGPT’s answers, your detailed explanations, and any modifications made.
You need to write the answers of the above type of questions in a single document, attached the screenshot of the prompts in the document,
I have attached a word document file from where you get the 1st question and a PDF file, where you can get the remaining 2 questions, If you need anything, feel free to reach out to me.
You should follow the instructions provided in the PDF. Please don’t take this assignment unless you have a strong knowledge about the Relational Database models and schema, otherwise I will provide a very bad review,if I find bad quality answers.