Tech 4010 - Assignment 3-2

Using Figure P7.1 in the text as a guide, write the SQL/DDL to create the Job and EMPLOYEE tables. Note the cardinality requirements for the relationship indicates a foreign key and values are required. Write the SQL commands to add the first three records to the JOB table and the first three records to the EMPLOYEE table. a. What happens if you create the EMPLOYEE table before the JOB table? Why? b. What happens if you add an employee record with a JOB _CODE not present in the JOB table? Why?

The processes used to complete a data science project vary in their number of steps and functions, but in the end, the objectives and outcomes are similar. Research on the Web to identify what you believe to be the set (version) of steps that you'd use to complete a Data Science project. You should find versions with 5, 7, 9, 11, 12, or more steps. If you choose a particular set of steps, cite your source and explain why you would use that approach. If you wish, you can develop your own approach, drawing on the research, if you think there may be a better way. As you get deeper into Data Science, in subsequent courses, you should learn the validity of your approach. List the steps of your approach, cite its source, and provide an explanation of why this particular approach would work best for you.

Select assessment method and create a digital rubrics for the method selected

can you help me create a Data flow diagram based on this system analysis please.

Please answer #3

choose the correct answer

What is preferred orientation and suggest how to refine the preferred orientation?

Please describe the relationship between bias, variance, underfitting, and overfitting. Support your answers with examples if needed.

Transform the table into 1NF, 2NF, and 3NF. Create a database diagram afterward

Our criteria must be broad and consistent to have any value.

Do you have any suggestions for specific ways that may be utilized to capture the flow of data?

What is metric? Who analyses it? Why is it important? Explain the metrics for the analysis model.

There are six elements that may be used to evaluate data quality.

The elaboration phase of the UP is similar to the traditional SDLC analysis phase. Select one: a. TRUE b.FALSE

What is multiple fact taBles actually, and how does it work in practice?

Do you have any specific recommendations for data flow tracking?

Process data flow diagram questions: how to explain and evaluate?

What is a stock model, and how does it function?