Premium Essay

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

Free Essay

Cis 207 Week 2 Information Use Paper

...Information Use CIS 207 April 10, 2013 Information Use Company’s safeguard sensitive data like credit cards, social security numbers, or names by storing them in files. Businesses need this information to perform business functions. Identification theft is on the rise and protecting customers and employee’s personal information is paramount for any business to perform. The inability to protect their information could result in the loss of trust from a client or a lawsuit. Successfully protecting personal information is based on five key principles; they are take stock, scale down, lock it, pitch it, and plan ahead (Federal Trade Commission, n.d.). Take stock refers to the inventory of personal information stored and who has access to the information. Ensuring only those people who has a need to know is given access. For example, at the restaurant I own, the cashier handles credit card transactions. This is important because if there were an incident where a customer was over charged or had a complaint; it would be easy to investigate the source of the problem. When taking inventory of the personal information stored, computers, and file cabinets are a great place to start. Flash drives, mobile phones, and website are also places to conduct an inventory. The company must talk to employees who sends personal information and how they send it. Customers, banking institutions, and credit card company’s send sensitive data through a variety of ways. Sensitive......

Words: 913 - Pages: 4

Free Essay

Cis 518 Week 6 Case Study 1 Generative Software Development

...CIS 518 Week 6 Case Study 1 Generative Software Development Click below link for answer http://workbank247.com/q/cis-518-week-6-case-study-1-case-study-1-generativ/3603 http://workbank247.com/q/cis-518-week-6-case-study-1-case-study-1-generativ/3603 Case Study 1: Generative Software Development This assignment consists of two (2) sections: a written report and a PowerPoint presentation. You must submit the two (2) sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for.  Section 1: Written Report Read the case study titled, “Generative Software Development” located in Chapter 5 of the textbook. Then, imagine a situation where your organization is considering a generative development process for its new line of software products. You are asked to present a written report to the organization’s CIO about generative software development and its usage. Write a five to six (5-6) page paper in which you: 1. Define in your own words, what is meant by generative software development, and describe how it contrasts with other software development processes. 2. Describe the benefits of applying the generative development in an organization. 3. Explain the challenges of implementing the generative software development process in an organization. 4. Describe how the challenges faced during the implementation of the generative software development process can be overcome. ......

Words: 517 - Pages: 3

Premium Essay

Week 6 Team Paper

...behind its high-priced competitors such as Nissan, Toyota, and GM in speed efficiency. Hence, ZENN Motor Vehicles is dedicated to increasing the rate at which these cars travel mph to meet its competitor’s specification of electric cars by 2015. Customer Safety Survey 1. What is your age? a. 16-21 b. 22-30 c. 31-45 d. 46-60 e. 61+ 2. How many miles do you drive a day? a. Less than 5 b. 5-10 c. 10-20 d. More than 20 3. Do you Own or lease your car a. Own b. Lease c. Neither 4. Do you carpool? a. Yes b. No 5. Have you ever considered purchasing an energy efficient vehicle? a. Yes b. No c. NA 6. How important is safety to you in a vehicle? a. Very important b. Somewhat Important c. somewhat not important d. Not important 7. How much money would you spend on an electric and energy efficient vehicle? a. Less than a $20,000 b. Less than $30,000 c. Less than $40,000 d. No limit 8. What do you look for in a vehicle? a. MPG (Miles per Gallon) b. Electronics (cameras, GPS, etc) c. crash ratings d. Other _______________ 9. When did you purchase your last car? a. Less than a year b. Over 3 years ago c. Over 7 years ago d. Over 10 years ago 10. What type of vehicle was it? a. SUV b. Truck c. Car d. Hybrid......

Words: 1121 - Pages: 5

Premium Essay

Week 2 Cis/211 Paper

...A word processor is a computer program used to write, edit, print, and publish documents for school, work, or even use at home. A word processor in general can be used to create any type of document in plain text, rich text document, HTML, and XML documents. It also has many templates for use such as tables, and graphs for use with your papers and many other features. Microsoft Word is the word processor made by the Microsoft Incorporation, and usually comes in a package known as Microsoft Office and comes with other software such as Power Point, Excel, Groove, Outlook and other useful tools. Some of its features include: • Cut or copy and paste. • Formatting text: such as changing the size of the font, changing the color and even highlighting important phrases so those portions stand out. • Bullets and Borders: for keeping your paper organized. • Spelling and Grammar check: Which helps correct mistakes with spelling and grammar errors. I would first greet the customer with a positive attitude to make him or her feel more comfortable, I would also thank the person for calling. I would then ask her how I could help her or if there was something she needed help with. One possible challenge is people from other countries often have accents that sometimes make things impossible to understand, and also sometimes they may not understand fully what they are talking about. You can overcome this by speaking slowly or asking if the customer......

Words: 932 - Pages: 4

Free Essay

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

Free Essay

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

Premium Essay

Cis 510 Week 10 Technical Paper

...A++PAPER;http://www.homeworkproviders.com/shop/cis-510-week-10-technical-paper/ CIS 510 WEEK 10 TECHNICAL PAPER CIS 510 Week 10 Technical Paper, CIS 510 Week 10 Technical Paper - Strayer Technical Paper: Final Project Plan Due Week 10 and worth 200 points Especially for You Jewelers is a small jewelry company in a college town. Over the last couple of years, it has experienced a tremendous increase in its business. However, its financial performance has not kept pace with its growth. The current system, which is partly manual and partly automated, doesn’t track accounts receivables sufficiently, and the company is finding it difficult to determine the reasons why the receivables are so high. The company runs frequent specials to attract customers but has no idea whether these efforts are profitable or if the benefit—if there is one—comes from associated sales. Especially for You Jewelers wants to increase repeat sales to its existing customers; thus, it needs to develop a customer database. It also wants to install a new direct sales and accounting system to help solve the outlined problems. The new direct sales and accounting system for Especially for You Jewelers will be an important element in the growth and success of the jewelry company. The direct sales portion must track every sale, be able to link to the inventory system for cost data, and provide a daily profit and loss report. The customer database must be able to produce purchase histories......

Words: 621 - Pages: 3

Premium Essay

Cis 525 Week 10 Term Paper

...CIS 525 WEEK 10 TERM PAPER A+ Graded Tutorial Available At: http://hwsoloutions.com/?product=cis-525-week-10-term-paper Visit Our website: http://hwsoloutions.com/ Product Description CIS 525 Week 10 Term Paper, Term Paper: Using Agile Project Management on Mobile Application Development Due Week 10 and worth 150 points Fictitious assumptions and details may be assumed or created for the completion of this assignment. Imagine you are the project manager for a critical project for an organization. The organization wants to implement an application on an iPad and Android Tablet such that the marketing executives and managers can get near real-time updates on how effective their marketing campaigns are doing. Since this project is so critical to the overall financial health of the company, you were asked to complete this project in three (3) months. Your business sponsors are very interested in your approach to manage this project and they are also demanding to see what the project team can deliver on a weekly basis. Due to the tight deadline, the project team was assembled quickly with ten (10) team members of various backgrounds. There are three (3) offshore developers in India and two (2) QA testers in San Francisco, CA. The rest of the project team and the product owner are in Herndon, VA. The team members were unfamiliar with each other. Additionally, there are ethical issues. For example, a developer has been consistently blaming an analyst for his accent......

Words: 653 - Pages: 3

Free Essay

Cis 417 Week 10 Term Paper

...CIS 417 WEEK 10 TERM PAPER To purchase this visit here: http://www.activitymode.com/product/cis-417-week-10-term-paper/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 417 WEEK 10 TERM PAPER – INVESTIGATING DATA THEFT Suppose a large aerospace engineering firm has immediately hired you as a consultant to investigate a potential violation of corporate policy and data theft. You have been informed that an employee may have been using corporate email to send confidential corporate information to one or more personal email accounts, which may or may not belong to him. You have been told that this action has been happening each business day for the last 13 days and the employee is unaware of any suspicion. Write an eight to ten (8-10) page paper in which you: 1. Explain, in detail, the initial actions you would take based on the provided information including formal plans to preserve the crime scene(s) and eventual transportation of evidence to a lab. 2. Analyze the physical and logical places where you would look for potential evidence on the suspect’s computer(s) and / or network servers. 3. Describe, in detail, how you proceed with the email investigation, including the review of email headers and tracing. 4. Describe the processes that would be utilized in order to recover data that may have been deleted from the suspect’s computer(s). More Details hidden… Activity mode aims to provide quality study notes and tutorials to the students of CIS 417 Week......

Words: 784 - Pages: 4

Premium Essay

Cis 210 Week 6 Assignment 3 Strayer

...CIS 210 WEEK 6 ASSIGNMENT 3 STRAYER To purchase this visit following link: http://coursehomework.com/product/cis-210-week-7-assignment-4-strayer/ Contact us at: HELP@COURSEHOMEWORK.COM CIS 210 WEEK 7 ASSIGNMENT 4 STRAYER Strayer CIS 210 Assignment 4: Databases Due Week 7 and worth 100 points You are working as a corporate trainer for a large organization. There are several other trainers and many training topics. The company has grown quickly and scheduling has become difficult. The current method for scheduling involves writing trainer names and courses on a dry-erase board. This has led to issues with trainers changing the assignments in their favor and accidental erasure of some course assignments. Write a 4-5 page paper in which you: 1. Discuss the requirements needed to build a database for the scheduling process. 2. Describe the advantages and disadvantages of moving the schedule to a database. 3. Create a graphical representation of your proposed database environment. 4. Explain how referential integrity can prevent mistakes in a database, and do the advantages outweigh the difficulty of setting it up? 5. Impress your boss by creating a database in Microsoft Access that will match trainers with courses and meet the following requirements: a. Two (2) tables, one (1) containing trainer information and the other containing course information. Create data for five (5) instructors and five (5) courses. The trainer data should include: employee ID number,......

Words: 1222 - Pages: 5

Free Essay

Cis 534 Week 10 Term Paper

...CIS 534 Week 10 Term Paper To purchase this visit here: http://mindsblow.us/question_des/CIS534Week10TermPaper/2792 Contact us at: help@mindblows.us CIS 534 Week 10 Term Paper Network Design CIS 534 Week 10 Term Paper To purchase this visit here: http://mindsblow.us/question_des/CIS534Week10TermPaper/2792 Contact us at: help@mindblows.us CIS 534 Week 10 Term Paper Network Design CIS 534 Week 10 Term Paper To purchase this visit here: http://mindsblow.us/question_des/CIS534Week10TermPaper/2792 Contact us at: help@mindblows.us CIS 534 Week 10 Term Paper Network Design CIS 534 Week 10 Term Paper To purchase this visit here: http://mindsblow.us/question_des/CIS534Week10TermPaper/2792 Contact us at: help@mindblows.us CIS 534 Week 10 Term Paper Network Design CIS 534 Week 10 Term Paper To purchase this visit here: http://mindsblow.us/question_des/CIS534Week10TermPaper/2792 Contact us at: help@mindblows.us CIS 534 Week 10 Term Paper Network Design CIS 534 Week 10 Term Paper To purchase this visit here: http://mindsblow.us/question_des/CIS534Week10TermPaper/2792 Contact us at: help@mindblows.us CIS 534 Week 10 Term Paper Network Design CIS 534 Week 10 Term Paper To purchase this visit here: http://mindsblow.us/question_des/CIS534Week10TermPaper/2792 Contact us at: help@mindblows.us CIS 534 Week 10 Term Paper Network Design CIS 534 Week 10 Term Paper To purchase this visit......

Words: 600 - Pages: 3

Premium Essay

Ese 633 Week 6 Final Paper

...ESE 633 Week 6 Final Paper To Buy This material Click below link http://www.uoptutors.com/ese-633-ash/ese-633-week-6-final-paper After completing this assignment, you will have demonstrated your understanding of the following objectives:  Analyze the value of co-teaching as an inclusion model of instructional delivery. Analyze the value of collaborative consultation as an inclusion model of instructional delivery. Analyze ways to create a collaborative school culture to promote professional growth and leadership. Determine some of the causes of education-based conflict. Evaluate problem solving and negotiation strategies to resolve education-based conflict. Recognize the importance of knowing personal strengths and weaknesses in conflict resolution. Evaluate verbal, non-verbal, and para-verbal cues that impact communication with educators, administrators, parents, and community members. Analyze the range of placements and services offered to students who have a disability. Additionally, this assignment demonstrates your mastery of the Course Learning Outcomes 1, 2, 3, 4, & 5 and the MAED Program Learning Outcomes 2 & 8 and will have reinforced your competency with the MAED Program Learning Outcome 7. As you have learned throughout this course, it takes a team to educate a student. The team is composed of stakeholders who have a professional and/or emotional investment in the student’s education and post-graduation success. Although everyone has the......

Words: 1921 - Pages: 8

Free Essay

Ese 697 Week 6 Final Paper

...ESE 697 Week 6 Final Paper To Buy This material Click below link http://www.uoptutors.com/ESE-697-ASH/ESE-697-Week-6-Final-Paper Throughout the course, you have been demonstrating your understanding of differentiation and lesson planning for children with mild and moderate disabilities through the design of lesson plans in various content areas. For the Final Project, you will demonstrate competency in planning instruction for students with mild and moderate disabilities by developing a lesson plan portfolio that you can use and share with other colleagues, for work interviews, or for personal use. Your Lesson Plan Portfolio will consist of the five complete, original lesson plans that you designed throughout this course. Each week, you received feedback from your instructor, and possibly from your peers, to continuously improve your differentiated lesson plans. Below there is a description of each part of the portfolio that you will submit this week as your Final Project. Part 1: Introduction to your portfolio Provide a brief introductory paragraph that explains the purpose of your portfolio and the competency you are demonstrating through your five lesson plans. Part 2: Lesson plan portfolio Use the feedback you received each week, along with what you have learned throughout the course, to revise each of the five lesson plans to ensure each component sufficiently addresses the required areas (below). Combine the lesson plans into one document to present your revised...

Words: 705 - Pages: 3

Free Essay

Hrmt 415 Week 6 Paper

...HRMT 415 Week 6 Paper Click Link Below To Buy: http://hwaid.com/shop/hrmt-415-week-6-paper/ For this assignment, you should focus on researching the following outside website to learn more about current HRIS products: http://www.ihrim.org/ The breakdown of your paper should be as follows: Introduction: Tell me about three products that you will discuss and why. Body of your paper: (2 Pages total in length)-Your thoughts should be supported with material from the above site and any vendor sites that you find on that site. Use this research paper with the goal of looking for SPECIFC HR technology that could be useful to you as an HR professional. Make sure that it is differenty technology than what was discussed in your week #5 paper. Each of these sections should be a separate paragraph: 1) Introduction 2) Discuss a technology on the above listed site that relates to Compensation (look in the “Buyer’s guide section of the website above and then go to the vendor site). What is the technology and how would it be useful? What are the interesting aspects of the technology? What would be the benefits and downfalls of the product? Which type of organization would it be useful? Why? 3) Discuss a technology on the above listed site that relates to Employment Systems and Services (look in the “Buyer’s guide section of the website above and then go to the vendor site). What is the technology and how would it be useful? What are the interesting aspects of the technology...

Words: 366 - Pages: 2

Free Essay

Hr434 Research Paper Week 6

...Homework Week 6 Student: Kevin Erne Roth Individual Retirement Account (IRA) For my research paper, I chose the Roth Individual Retirement Account (IRA). As a military member I am enrolled in a pension plan and have never had any experience with IRAs or any other type of retirement plan. During my research, I found some history, eligibility requirements, advantages and disadvantages that I would like to share with you. For anyone considering retirement an individual retirement plan might be a great option to pursue, but that all depends on your needs and future plans. You should start with some research. When I first started my research, I was curious as to what the history was behind retirement. The idea of retiring is relatively new. My research told me that back in the 19th century, the majority of the population worked until they died. Reading between the lines led me to believe that this was based on the average lifespan of the working force. It is estimated that only 4% of the population lived into their 60s. Once they reached this age, they were allowed to live with their families until they passed away. Therefore, the need for a retirement account was not an issue because very few people had a necessity to have one (roth-ira.org). Fast forward to present day and we know that people live quite a bit longer than they did in years gone by. It's not uncommon for people to live well into their 90s and when they do, they need to be prepared to...

Words: 1693 - Pages: 7