Cis Week 6 Paper

In: Computers and Technology

Submitted By goatleg84
Words 491
Pages 2
Normalization
Rebecca Leonard
Strayer University
CIS 111 – Introduction to Relational Database Management Systems
Diana Merkel
March 20, 2016 *

As a database developer for a local college, and tasked with providing database normalizing training material. The steps for moving from un-normalized to 3NF will be the key points to cover. The most important reason for a college is to ensure data integrity, keeping records associated with the proper student. Sample database: Student ID | First Name | Last Name | Date of birth | Course number | Course name | Level | Course length | Date completed | result | 1 | Jeff | Jones | 13/09/89 | 100 | Pre-algebra | 1 | 3 weeks | 10/10/04 | Pass | | | | | 200 | Arabic studies | 2 | 6 weeks | 23/06/05 | Pass | | | | | 250 | Statistics | 2 | 6 weeks | 05/03/04 | Pass | 2 | Elenore | Jobs | 30/07/86 | 330 | Humanities | 3 | 9 weeks | 10/10/05 | Merit | | | | | 345 | Trig | 3 | 9 weeks | 05/03/05 | Distinction | | | | | 210 | System Management | 2 | 6 weeks | 13/01/05 | Pass | 3 | Jake | Bloom | 17/01/87 | 200 | Arabic studies | 2 | 6 weeks | 23/06/05 | Unclassified | 4 | Makenzie | Tam | 16/10/90 | 100 | Pre-algebra | 1 | 3 weeks | 10/10/08 | Pass | | | | | 102 | English | 1 | 3 weeks | 02/07/04 | Merit | | | | | 250 | Statistics | 2 | 6 weeks | 05/03/04 | Merit |

The first step to normalizing the database is to list out all the fields as seen below. To move in to 1NF find the fields without duplication and place them on top. Other fall to the bottom. I choose Student ID for the top table and Course number for the bottom. Student ID was added to the bottom as a link. To move to 2NF the top will move across. Then we must set the primary keys for the tables. The bottom will be split into at least two. To make the split the developer will need to find the fields that are dependent on each…...

Similar Documents

Cis 247 Week 6

...HELPIDO.COM ------------------------------------------------------------------ FOLLOW THE LINK TO GET THE TUTORIAL http://helpido.com/cis-247-week-6/#5 ------------------------------------------------------------------ CIS 247 WEEK 6 ________________________________________ Week 6: Interfaces and Abstract Classes – iLab iLab 6 of 7: Abstract Classes i L A B O V E R V I E W Scenario and Summary The objective of the lab is to take the UML Class diagram and enhance last week’s Employee class by making the following changes: 1. Convert the Employee class to an abstract class 2. Add an abstract method called CalculateNetPay to the Employee class 3. In both the Salaried and Hourly classes implement the CalculateNetPay method Deliverables Due this week:  Before you post your lab in the dropbox, copy your entire program into a Notepad file and post that. I do not need you to zip the project or give me screen shots of the output. i L A B S T E P S STEP 1: Understand the UML Diagram Analyze and understand the object UML diagram, which models the structure of the program.  The Employee class has been specifed as abstract, which is denoted by the name of the class being italized Employee  The Employee class as a new method CalculateNetPay which is an abstract method, denoted by the italized name of the method. Since this method is an abstract method the CalculateNetPay method WILL NOT have an implementation in the Employee......

Words: 686 - Pages: 3

Cis 247 Week 6

...HELPIDO.COM ------------------------------------------------------------------ FOLLOW THE LINK TO GET THE TUTORIAL http://helpido.com/cis-247-week-6/#5 ------------------------------------------------------------------ CIS 247 WEEK 6 ________________________________________ Week 6: Interfaces and Abstract Classes – iLab iLab 6 of 7: Abstract Classes i L A B O V E R V I E W Scenario and Summary The objective of the lab is to take the UML Class diagram and enhance last week’s Employee class by making the following changes: 1. Convert the Employee class to an abstract class 2. Add an abstract method called CalculateNetPay to the Employee class 3. In both the Salaried and Hourly classes implement the CalculateNetPay method Deliverables Due this week:  Before you post your lab in the dropbox, copy your entire program into a Notepad file and post that. I do not need you to zip the project or give me screen shots of the output. i L A B S T E P S STEP 1: Understand the UML Diagram Analyze and understand the object UML diagram, which models the structure of the program.  The Employee class has been specifed as abstract, which is denoted by the name of the class being italized Employee  The Employee class as a new method CalculateNetPay which is an abstract method, denoted by the italized name of the method. Since this method is an abstract method the CalculateNetPay method WILL NOT have an implementation in the Employee......

Words: 686 - Pages: 3

Cis 247 Week 6

...HELPIDO.COM ------------------------------------------------------------------ FOLLOW THE LINK TO GET THE TUTORIAL http://helpido.com/cis-247-week-6/#5 ------------------------------------------------------------------ CIS 247 WEEK 6 ________________________________________ Week 6: Interfaces and Abstract Classes – iLab iLab 6 of 7: Abstract Classes i L A B O V E R V I E W Scenario and Summary The objective of the lab is to take the UML Class diagram and enhance last week’s Employee class by making the following changes: 1. Convert the Employee class to an abstract class 2. Add an abstract method called CalculateNetPay to the Employee class 3. In both the Salaried and Hourly classes implement the CalculateNetPay method Deliverables Due this week:  Before you post your lab in the dropbox, copy your entire program into a Notepad file and post that. I do not need you to zip the project or give me screen shots of the output. i L A B S T E P S STEP 1: Understand the UML Diagram Analyze and understand the object UML diagram, which models the structure of the program.  The Employee class has been specifed as abstract, which is denoted by the name of the class being italized Employee  The Employee class as a new method CalculateNetPay which is an abstract method, denoted by the italized name of the method. Since this method is an abstract method the CalculateNetPay method WILL NOT have an implementation in the Employee......

Words: 686 - Pages: 3

Cis 247 Week 6

...HELPIDO.COM ------------------------------------------------------------------ FOLLOW THE LINK TO GET THE TUTORIAL http://helpido.com/cis-247-week-6/#5 ------------------------------------------------------------------ CIS 247 WEEK 6 ________________________________________ Week 6: Interfaces and Abstract Classes – iLab iLab 6 of 7: Abstract Classes i L A B O V E R V I E W Scenario and Summary The objective of the lab is to take the UML Class diagram and enhance last week’s Employee class by making the following changes: 1. Convert the Employee class to an abstract class 2. Add an abstract method called CalculateNetPay to the Employee class 3. In both the Salaried and Hourly classes implement the CalculateNetPay method Deliverables Due this week:  Before you post your lab in the dropbox, copy your entire program into a Notepad file and post that. I do not need you to zip the project or give me screen shots of the output. i L A B S T E P S STEP 1: Understand the UML Diagram Analyze and understand the object UML diagram, which models the structure of the program.  The Employee class has been specifed as abstract, which is denoted by the name of the class being italized Employee  The Employee class as a new method CalculateNetPay which is an abstract method, denoted by the italized name of the method. Since this method is an abstract method the CalculateNetPay method WILL NOT have an implementation in the Employee......

Words: 686 - Pages: 3

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment To Buy this Class Copy & paste below link in your Brower http://www.homeworkregency.com/downloads/cis-515-week-6-assignment/ Or Visit Our Website Visit : http://www.homeworkregency.com Email Us : homeworkregency@gmail.com CIS 515 Week 6 Assignment SQL Concepts and Database Design Due Week 7 and worth 90 points The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following: • Employee (EmpNumber , EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) • Invoice ( InvNumber , InvDate, EmpNumber, InvAmount, CustomerID) • InvoiceLine ( InvLineNumber , InvNumber, ProductNumber, Quantity) • Product (ProductNumber , ProductDescription, ProductCost) • Department (DepartmentID , DepartmentDescription) • Job (JobID , JobDescription) • Customer (CustomerID , CustomerName, CustomerAddress, CustomerPhone) Write a three to four (3-4) page paper in which you: 1. Create a data......

Words: 13856 - Pages: 56

Cis 247b Week 6 Ilab

...CIS 247B Week 6 iLab Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-247b-week-6-ilab/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 247B Week 6 iLab Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-247b-week-6-ilab/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 247B Week 6 iLab Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-247b-week-6-ilab/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 247B Week 6 iLab Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/cis-247b-week-6-ilab/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) CIS 247B Week 6 iLab Get Tutorial by Clicking on the link below...

Words: 1441 - Pages: 6

Cis 515 Week 6 Assignment

...• CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6......

Words: 590 - Pages: 3

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6......

Words: 760 - Pages: 4

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment To Buy this Class Copy & paste below link in your Brower http://homeworkregency.com/downloads/cis-515-week-6-assignment/ Or Visit Our Website Visit : http://www.homeworkregency.com Email Us : homeworkregency@gmail.com CIS 515 Week 6 Assignment SQL Concepts and Database Design Due Week 7 and worth 90 points The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following: • Employee (EmpNumber , EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) • Invoice ( InvNumber , InvDate, EmpNumber, InvAmount, CustomerID) • InvoiceLine ( InvLineNumber , InvNumber, ProductNumber, Quantity) • Product (ProductNumber , ProductDescription, ProductCost) • Department (DepartmentID , DepartmentDescription) • Job (JobID , JobDescription) • Customer (CustomerID , CustomerName, CustomerAddress, CustomerPhone) Write a three to four (3-4) page paper in which you: 1. Create a data......

Words: 432 - Pages: 2

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment http://homeworkfy.com/downloads/cis-515-week-6-assignment/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) SQL Concepts and Database Design Due Week 7 and worth 90 points The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following: • Employee (EmpNumber , EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) • Invoice ( InvNumber , InvDate, EmpNumber, InvAmount, CustomerID) • InvoiceLine ( InvLineNumber , InvNumber, ProductNumber, Quantity) • Product (ProductNumber , ProductDescription, ProductCost) • Department (DepartmentID , DepartmentDescription) • Job (JobID , JobDescription) • Customer (CustomerID , CustomerName, CustomerAddress, CustomerPhone) Write a three to four (3-4) page paper in which you: 1. Create a data dictionary that includes......

Words: 432 - Pages: 2

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment http://homeworkfy.com/downloads/cis-515-week-6-assignment/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) SQL Concepts and Database Design Due Week 7 and worth 90 points The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following: • Employee (EmpNumber , EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) • Invoice ( InvNumber , InvDate, EmpNumber, InvAmount, CustomerID) • InvoiceLine ( InvLineNumber , InvNumber, ProductNumber, Quantity) • Product (ProductNumber , ProductDescription, ProductCost) • Department (DepartmentID , DepartmentDescription) • Job (JobID , JobDescription) • Customer (CustomerID , CustomerName, CustomerAddress, CustomerPhone) Write a three to four (3-4) page paper in which you: 1. Create a data dictionary that includes......

Words: 432 - Pages: 2

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment http://homeworkfy.com/downloads/cis-515-week-6-assignment/ To Get this Tutorial Copy & Paste above URL Into Your Browser Hit Us Email for Any Inquiry at: Homeworkfy@gmail.com Visit our Site for More Tutorials: (http://homeworkfy.com/ ) SQL Concepts and Database Design Due Week 7 and worth 90 points The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following: • Employee (EmpNumber , EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) • Invoice ( InvNumber , InvDate, EmpNumber, InvAmount, CustomerID) • InvoiceLine ( InvLineNumber , InvNumber, ProductNumber, Quantity) • Product (ProductNumber , ProductDescription, ProductCost) • Department (DepartmentID , DepartmentDescription) • Job (JobID , JobDescription) • Customer (CustomerID , CustomerName, CustomerAddress, CustomerPhone) Write a three to four (3-4) page paper in which you: 1. Create a data dictionary that includes......

Words: 432 - Pages: 2

Cis 210 Week 6 Cis210 Week 6

...CIS 210 Complete Course CIS210 Complete Course Click Link for the Answer: http://workbank247.com/q/cis-210-complete-course-cis210-complete-course/22404 http://workbank247.com/q/cis-210-complete-course-cis210-complete-course/22404 CIS 210 Week 1 Discussion 1 "Technical Skills vs. Customer Service"  Please respond to the following: * You are tasked with hiring a new systems analyst at your company. One candidate has excellent technical credentials, but does not think customer service is important. A second candidate has excellent customer service credentials and fair technical skills. Which candidate would you be more likely to hire and why? CIS 210 Week 1 Discussion 2 "The Importance of Research" Please respond to the following: * Describe how you would explain the importance of researching policies and procedures to someone that just wants to get started on the project. CIS 210 Week 2 Discussion 1 "Scope Creep" Please respond to the following: * You overhear two of your systems analysts talking. One tells the other that scope creep is a good thing as long as it improves the project overall. Respond to this statement. CIS 210 Week 2 Discussion 2 "Failed Technology Projects" Please respond to the following: *  In your opinion, discuss the three (3) most likely causes for failed technology projects. CIS 210 Week 2 Assignment 1: Inventory Management Systems Due Week 2 and worth 100 points Your sister owns a small clothing store. During a conversation at a family......

Words: 4138 - Pages: 17

Cis 111 Week 6 Cis111 Week 6

...CIS 111 Complete Course CIS111Complete Course Click Link for the Answer: http://workbank247.com/q/cis-111-complete-course-cis111complete-course/22359 http://workbank247.com/q/cis-111-complete-course-cis111complete-course/22359 CIS 111 Week 1 Discussion "Business Rules in Data Modeling"  Please respond to the following: * Per the text, when databases are developed, they are modeled around business rules, so they accurately support a business function or operation. * Based on your experiences, identify one (1) example of a business function / operation. Explain the business function / operation in the context of business data models. * Identify the business rules associated with your selected business function / operation. Explain the manner in which such business rules would impact the design of a database. * Explain at least one (1) way in which the business function or operation would be affected if these business rules were not adhered to in the development of the database. CIS 111 Week 2 Discussion "Relational Database Model"  Please respond to the following: * In the Week 1 discussion, you identified one (1) example of a business function or operation and the business rules associated with that business function / operation. You will build upon that discussion as you describe the main entities or objects of that business function / operation in question, as well as the manner in which they relate to one another. * Describe the main entities...

Words: 5395 - Pages: 22

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment To Buy this Class Copy & paste below link in your Brower http://homeworkregency.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment SQL Concepts and Database Design Due Week 7 and worth 90 points The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization’s sales database. You are asked to propose a data dictionary that can be used to document the following: • Employee (EmpNumber , EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) • Invoice ( InvNumber , InvDate, EmpNumber, InvAmount, CustomerID) • InvoiceLine ( InvLineNumber , InvNumber, ProductNumber, Quantity) • Product (ProductNumber , ProductDescription, ProductCost) • Department (DepartmentID , DepartmentDescription) • Job (JobID , JobDescription) • Customer (CustomerID , CustomerName, CustomerAddress, CustomerPhone) Write a three to four (3-4) page paper in which you: 1. Create a data dictionary that includes the following: a. A description of the content for each field b. The data type of each field...

Words: 418 - Pages: 2