18 Jun WHAT IS NORMALIZATION? September 20, 2018Posted by: kajo No Comments
WHAT IS NORMALIZATION?
September 20, 2018Posted by: kajo No Comments
Part A: You and your ITEC 630 Group Project Team are close to completing a system for Meecham Feeds. Ms. Taylor Swift, who is one of your ITEC 630 teammates, is quite confident that the programs that she has written for Meecham’s inventory system will perform as necessary, because they are similar to programs she has written before. Your team has been very busy and would ideally like to begin full systems testing as soon as possible.
Two of your junior team members have proposed the following:
Skip desk checking of the programs (because similar programs were checked in other installations; Taylor Swift has agreed). (10 points)
Do link testing with large amounts of data to prove that the system will work. (10 points)
Do full systems testing with large amounts of live data to show that the system is working. (10 points)
In the form of a well crafted essay (750 words), please respond to each of the three steps and their proposed test schedule.
Part B: In the form of a well crafted essay (750 words), please respond to the below two exam questions:
What is normalization? What is the purpose of normalization? What types of functional dependencies may exist in relations? What types of problems one may encounter if the dependencies are not removed? (10 Points)
Describe the analysis that is applied to a data model in order to place it in first normal form (1NF), then second normal form (2NF) and finally, in third normal form (3NF). (10 points)
Problem II – (50 points)
The following is a code for one produce in an extensive cosmetic line: L02002Z621289. L means that it is a lipstick, 0 means that it was introduced without a matching nail polish, 2002 is a sequence code indicating in what order it was produced, Z is a classification code indicating that the product is hypoallergenic, and 621289 is the number of the plant (there are 15 plants) where the product was produced.
PART A: In the form of a well crafted essay response (750 words), please critique the above code by listing the features that might lead to inaccurate data entry. (25 points)
PART B: Write a well crated essay response (750 words) which explains changes that you have suggested, indicating what data entry problems the change will eliminate. Please include your version of the revised code in your response. (25 points)
Problem III- (50 points)
Titanic Marinas is a chain of 12 marinas that offer lakeside service to boaters; service and repair of boats, motors, and marine equipment; and sales of boats, motors, and other marine accessories. The systems development project team at Titanic Marinas has been hard at work on a project that eventually will link all the marina’s facilities into one unified, networked system.
The project team has developed a logical process model of the current system. This model has been carefully checked for syntax errors. Last week, the team invited a number of system users to role-play the various data flow diagrams, and the diagrams were refined to the users’ satisfaction. Right now, the project manager feels confident that the as-is system has been adequately represented in the process model.
The director of operations for Titanic Marinas is the sponsor of this project. He sat in on the role-playing of the process model and was very pleased by the thorough job the team had done in developing the model. He made it clear to YOU, the project manager, that he was anxious to see your team begin work on the process model for the to-be system. He was a little skeptical that it was necessary for YOUR team to spend any time modeling the current system in the first place, but grudgingly admitted that the team really seemed to understand the business after going through that work.
The methodology that YOU are following, however, specifies that the team should now turn its attention to developing the logical data modelfor the as-is system. When YOU stated this to the project sponsor, he seemed confused and a little irritated. “YOU are going to spend even more time looking at the current system? I thought YOU were done with that! Why is this necessary? I want to see some progress on the way things will work in the future!”
By way of a well-written essay response (750 words), please address the following questions: What is your response to
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.