Case Study CTTS - Milestone 05 Data Model Normalization
4 Pages

Case Study CTTS - Milestone 05 Data Model Normalization

Course Number: CIS 231, Spring 2011

College/University: American Public University

Word Count: 926

Rating:

Document Preview

SADM 7/ed CTTS CASE STUDY - Milestone 5: Data Model Normalization Page: 5-1 MILESTONE 5 DATA MODEL NORMALIZATION Synopsis I n this milestone you will normalize the data model created in Milestone 4, along with additional data requirements, to be in third normal form. Objectives After completing this milestone, you should be able to: Normalize a logical data model to remove impurities that can make a...

Unformatted Document Excerpt
Coursehero >> West Virginia >> American Public University >> CIS 231

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

7/ed SADM CTTS CASE STUDY - Milestone 5: Data Model Normalization Page: 5-1 MILESTONE 5 DATA MODEL NORMALIZATION Synopsis I n this milestone you will normalize the data model created in Milestone 4, along with additional data requirements, to be in third normal form. Objectives After completing this milestone, you should be able to: Normalize a logical data model to remove impurities that can make a database unstable, inflexible, and non-scalable. Prerequisites 1. Data analysis - Chapter 8 2. Milestone 4 Solution Assignment The goal of this project is to normalize our logical data model to remove impurities that can make a database unstable, inflexible, and non-scalable. Prepared by Gary B. Randolph for Systems Analysis & Design Methods 7ed by J. L. Whitten, L. D. Bentley, & K. C. Dittman Copyright Irwin/McGraw-Hill 2007 SADM 7/ed CTTS CASE STUDY - Milestone 5: Data Model Normalization Page: 5-2 Activities 1. To construct an Entity Relationship Diagram to be in 3rd Normal form, follow the normalization procedure outlined in Chapter 8 of the SADM 7th ed. textbook. Use feedback from your the ERD solution of Milestone 4 as well as the data dictionary provided at the end of this milestone to prepare the new data model. 2. Specify all data types (your instructor will specify the target database or allowable set of data types). 3. Specify all primary and foreign keys. 4. Specify which attributes are required (not nullable). 5. Add and normalize additional entities and attributes as directed by your instructor. Make assumptions where necessary. Deliverable format and software to be used are according to your instructors specifications. Deliverables should be neatly packaged in a binder, separated with a tab divider labeled Milestone 5. References: Previous Milestone Solutions Provided by your instructor Data Attribute Dictionary Provided at the end of this milestone Refer to a Copy of Your Fully Attributed Data Model Created for Milestone 4. Deliverables: Logical Data Model in 3rd Normal Form: Due: __/__/__ Time:_______ Milestones Point Value: _______ Prepared by Gary B. Randolph for Systems Analysis & Design Methods 7ed by J. L. Whitten, L. D. Bentley, & K. C. Dittman Copyright Irwin/McGraw-Hill 2007 SADM 7/ed CTTS CASE STUDY - Milestone 5: Data Model Normalization Data Attribute Dictionary Page: 5-3 Below is a Data Attribute Dictionary that contains all the attributes and definitions. Note: the attributes below are listed in alphabetical order, not by entity. Address Barcode City ClientID ClientName ComponentType ConfigurationID ContactFirstName ContactLastName DateInstalled DatePurch DateRemoved Description Email Equipment EquipName EquipNum EquipType FinishTime InfoName InfoValues InServiceDate ModelNum A 30-character alphanumeric field holding the clients street or box address. A 20-character alphanumeric barcode ID that is either pre-printed on each component package or added via a label at Coastline Consulting. A 20-character alphanumeric field holding the name of the clients city. A system-generated large integer numeric value unique to each client. 50-character A alphanumeric field holding the clients company name. A 10-character alphanumeric classification of the type of component. A system-generated large integer numeric value unique to each software configuration record. A 20-character alphanumeric field consisting of the first name of the client contact person. A 30-character alphanumeric field consisting of last name of the client contact person. Date field consisting of the date a component was installed into a piece of equipment. A date field representing the date a component was purchased. Date field consisting of the date a component was removed from a piece of equipment. A 30-character description of the component. A 70-character alphanumeric field consisting of the client contacts e-mail address. A 20-character alphanumeric description of the piece of equipment, if any, for a software configuration record. A 15-character alphanumeric field holding the identifying name for the piece of equipment A system-generated numeric value unique to each piece of equipment. A 10-character alphanumeric field identifying the equipment as PC, Printer, Scanner, etc. A time field holding the time a technician finished work on a request. A 20-character alphanumeric description of the information stored in a software configuration record. A 50-character alphanumeric information value stored in a software configuration record. A date field consisting of the date the piece of equipment was placed in service. A 10-character alphanumeric identifier of the model number of the component. Prepared by Gary B. Randolph for Systems Analysis & Design Methods 7ed by J. L. Whitten, L. D. Bentley, & K. C. Dittman Copyright Irwin/McGraw-Hill 2007 SADM 7/ed CTTS CASE STUDY - Milestone 5: Data Model Normalization Quantity Page: 5-4 ReportDate ReportedBy ReqNum ResolutionDate StartTime State TechInitials Vendor WorkDate WorkDescription WorkNum Zip A numeric field specifying the quantity of items installed as an EquipmentComponent. This is always a whole number. An inspection of past forms shows no quantity exceeding 50. A date field holding the date a service request was reported. A 50-character alphanumeric field holding the first and last name of the person reporting a service request. A system-generated large integer numeric value unique to each service request. A date field holding the date a service request was resolved. A time field holding the time a technician began work on a request. A 2-character abbreviation for the clients state. A 3-character alphanumeric field consisting of the initials of the technician performing work. A 30-character field holding the name of the vendor from whom a component was purchased. A date field consisting of the date a technician did work on a request. A large alphanumeric field describing the work done on a work record. A system-generated large integer numeric value unique to each work record. A 10-character alphanumeric postal code of a client. Prepared by Gary B. Randolph for Systems Analysis & Design Methods 7ed by J. L. Whitten, L. D. Bentley, & K. C. Dittman Copyright Irwin/McGraw-Hill 2007

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

American Public University - CIS - 231
SYSTEMS ANALYSIS AND DESIGN METHODS 6th EditionWhitten Bentley DittmanCHAPTER17Irwin/McGrawHillUSER INTERFACE DESIGNCopyright2004TheMcGrawHillCompanies.AllRightsreservedSYSTEMS ANALYSIS AND DESIGN METHODS 6th EditionWhitten Bentley DittmanChapter
Kennesaw - CHEM - 3361
Handout 7 Strain in Simple Alkanes Interaction C-H, C-H eclipsed C-CH3, C-H eclipsed C-CH3, C-CH3 eclipsed CH3, CH3 gauche Type of Strain Torsional Torsional Torsional, Steric Steric Energy (kJ/mol) 4 5 17 3.3 3.1-3.3Strain in Axially-substituted Cyclohe
East Central Community College - ENGL - 1010
Three Paragraph EssayBelow is a formula to use for writing a three-paragraph literary analysis. Pay attention to what is asked for in each sentence. Notice the ONE supporting paragraph has at least two quotes supporting your central point and there are m
East Central Community College - ENGL - 1010
I-5 paragraph essay outline Introduction (broad to specific)- broad topic_ - specific focus_ - Thesis sentence_ _(_,_,_)reason /ex. 1 reason / ex. 2 reason / ex. 3(transitional bridge to first point)II-Body paragraph one-Statement / topic sentence
East Central Community College - ENGL - 1010
Introduction to Literary AnalysisWhat is Literary Analysis?Aliterary analysis is first and foremost, an essay. such, it must have those elements that make it an essay: an introduction, a body and a conclusion. AsNot just an opinion However,in an an
East Central Community College - ENGL - 1010
NAME _6 Trait Rubric Mastery EssayIdea Development Organization Voice Word Choice Sentence Fluency Conventions 5 5 5 5 5 5 _ 4 4 4 4 4 4 _ 3 3 3 3 3 3 _ 2 2 2 2 2 2 _ 1 1 1 1 1 1 _ _ / 30MASTERY TOTALNAME _6 Trait Rubric Mastery EssayIdea Developmen
East Central Community College - ENGL - 1010
NAME _6 Trait Rubric Mastery EssayIdea Development Organization Voice Word Choice Sentence Fluency Conventions 10 10 10 5 5 10 _ 8 8 8 4 4 8 _ 6 6 6 3 3 6 _ 4 4 4 2 2 4 _ 2 2 2 1 1 2 _ _ / 50MASTERY TOTALNAME _6 Trait Rubric Mastery EssayIdea Develo
East Central Community College - ENGL - 1010
6 Traits RubricIDEA DEVELOPMENT ORGANIZATION VOICE5 The writing is clear, well-supported or developed,and enhanced by the kind of detail that keeps readers reading5 The order, presentation, or internal structure of thepiece is compelling and guides t
East Central Community College - ENGL - 1010
6 Traits RubricWORD CHOICE SENTENCE FLUENCY CONVENTIONS5 Precise, vivid, natural language paints a strong,clear, and complete picture in the readers mind 5 An easy flow and sentence sense makes this text adelight to read aloud5 The writer shows exc
East Central Community College - ENGL - 1010
Actualanalogiesandmetaphorsfromhighschoolessays Histhoughtstumbledinhishead,makingandbreakingallianceslikeunderpantsinadryerwithoutCling Free. ShegrewonhimlikeshewasacolonyofE.coliandhewasroomtemperatureCanadianbeef. Shehadadeep,throaty,genuinelaugh,like
East Central Community College - ENGL - 1010
Advanced Placement English Open-Essay Questions1971 The significance of a title such as *The Adventures of Huckleberry Finn* is easy to discover. However, in other works the full significance of thetitle becomes apparent to the reader only gradually. C
East Central Community College - ENGL - 1010
Character Analysis Writing PromptsTOPIC 1: Not all minor/supporting characters play an integral role in a story; however, sometimes a minor character is so important to the novel/book that the theme, plot, protagonist, etc., would be greatly changed if t
East Central Community College - ENGL - 1010
Citing Web Publications If you are using a subscription data base that provides a citation, use the material provided but be sure to use a hanging indent on your working bibliography card or Works Cited page. If a website gives the information needed for
East Central Community College - ENGL - 1010
Classroom Instruction that Works Robert J. Marzano, Debra, J . Pickering, Jane E. Pollock, MCREL, 2001. Strategies to activate prior knowledge include: K-W-L (Ogle 1986 in Vacca & Vacca, 1999) In a chart: 1. Students list what they think they already Know
East Central Community College - ENGL - 1010
Closerlook(svidentification)JonathanandMattwenttothemallonFridayafternoonafterclass.Jonathan wantedabirthdaygiftforhisnewgirlfriend,Chantal.Buyingagiftfora newfriendishard.Therearesomanyinterestingideasforgiftsinthestores. WouldChantallikeperfume,jewelry
East Central Community College - ENGL - 1010
Creatingabrochure1. TodisplaytheCatalog,clickNewontheFilemenu. 2. ClickthePublicationsbyWizardtab. 3. Inthewizardspane,clickBrochures,thenclickInformational. 4. Intherightpage,doubleclickFramesInformationalBrochure. 5. Inthewizardpane,clickNext. 6. Inthe
East Central Community College - ENGL - 1010
Definition paperAnswer the question, "What is it?" Yours might ask "What is In a five-paragraph essay, define one of the following terms. Remember you will need an opening paragraph, a concluding paragraph, and three supporting points. Remember to includ
East Central Community College - ENGL - 1010
Essay activity5 paragraph essay topic: What are the three most significant cartoons in our cultures history and why? Possible choices 1 2 3 4 5 general statement about topic Topic sentence ( argument)Choice 1Becausea. b. c.transition Choice 2Because a.
East Central Community College - ENGL - 1010
NAME _ COURSE _ TEACHER _ ESSAY FORMAT TYPE OF ESSAY TIMED/UNEDITED NARRATIVE EXPOSITORY LIT ANALYSIS REVISED/EDITED DESCRIPTIVE PERSUASIVE COMPARE/CONTRASTTOPIC _ _ _ I CHOSE NOT TO DO THIS ASSIGNMENT _ I AFFIRM THAT THE ATTACHED WORK IS COMPLETELY MY O
East Central Community College - ENGL - 1010
NAME : _ CLASS PERIOD : _ DATE : _CATEGORY Introduction and Thesis10Topic is introduced smoothly and in an interesting fashion Thesis is clear and easily identifiable. Smooth flowing information is organized with well-constructed paragraph(s) and trans
East Central Community College - ENGL - 1010
Name:_ Period_ TopicThesisStatements / Reasons for PositionConcrete Examples to Support
East Central Community College - ENGL - 1010
Name: Date: Period: Teacher: Title: I. Write a sentence explaining the use of character analysis in all literature: _ _ . a. This sentence includes the title of the work, the authors name and further detail on character analysis: _ _ _ . b. (Thesis):_ _ .
East Central Community College - ENGL - 1010
GHSGTWritingHow long do I have? 90 minutes for test Suggested time breakdown Planning and Revising (15) Rough Draft (30) Revising (35) Editing and Proofreading (10)Specifications Only a PEN can be used on the test. Write or Print on no more than 2 p
East Central Community College - ENGL - 1010
GHSWTisavailableat: http:/www.gadoe.org/ci_testing.aspx?folderID=3343&m=links&ft=GHSWT%20Resources
East Central Community College - ENGL - 1010
Character Analysis Graphic OrganizerOpening Paragraph:Write a sentence explaining the use of character analysis in all literature.This sentence includes the title of the work, the authors name and further detail on character analysis.Thesis statement:
East Central Community College - ENGL - 1010
How to Write an Expository EssayAn expository essay informs the reader about a particular subject. It is intended to provide information rather than convince the reader of a particular point of view. When writing an essay, follow these basic steps: Selec
East Central Community College - ENGL - 1010
IdentifyingSetting Definition:Thesettingisthetimeandtheplaceoftheactionofastory.Itcontributesstronglytothemoodoratmosphereofastory.Questions:1. WhatevidencedoyoufindinChapter1thatindicatesthetimeofthisstory: 2. Examinecloselytheaccompanyinghandout.Whol
East Central Community College - ENGL - 1010
PLAYER NAME _ GOALS FOR SEASON: 1. _ 2. _ 3. _AFFIRMATIONS:(I AM, I FEEL, I ENJOY, ETC)1. _ 2. _ 3. _ 4. _ 5. _ 6. _ 7. _ 8. _3rd PERSON IMAGERY ACTIVITY: (SUCCESSFUL VISION OF GOAL FROM ABOVE) I SEE MYSELF _1ST PERSON IMAGERY ACTIVITY: I FEEL MYSELF
East Central Community College - ENGL - 1010
Introduction to Literary Analysis What is Literary Analysis? A literary analysis is first and foremost, an _. As such, it must have those elements that make it an essay: _, a _ and a _. Not just an opinion However, in an analysis, you also examine the par
East Central Community College - ENGL - 1010
Your Thesis Statement:The Only Sentence Worth More Than A Thousand WordsThesis Statements Are Not As Hard As You May ThinkFirst, lets look at what a Thesis Statement is NOT! isWhat a Thesis Statement is Not:Your Thesis Statement is NOT Your Your Topi
UGA - FDNS - 2100
Thefollowingarepotentialerrorsindietaryintakeassessment: o *ALLOFTHEABOVE* o Nonresponsebias o Recallerror o Memoryproblems o Daytodayvariabilityinintake ThefollowingisNOTafunctionofawater o Providesenergyformusclestoperformwork ThefollowingAREfunc
UGA - FDNS - 2100
FDNS 2100, Human Nutrition and Food Exam 1 Study GuideLee Spring 2011FDNS 2100 Study Guide: Exam 1 BRING CALCULATOR TO THE TEST! Here are some things you should focus on for the exam. Nutrition Basics & How We Know What We Know Be familiar with the diff
UGA - FDNS - 2100
FDNS 2100, Human Nutrition and Food Exam 3, March 29, 2010Lee Spring, 2010FORM AI agree to uphold the UGA Student Honor Code: I will be academically honest in all of my academic work and will not tolerate academic dishonesty of others. Print Name: _ Si
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeExam next Wednesday (4/3)! Diet and Health II Types of disease Infectious diseases Degenerative diseases 4. Cardiovascular Diseases (CVD) 1) CVD 2) ~80 million people in US suffer some form of CVD (about 1 million ye
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeCARBOHYDRATES II5. The Bodys Use of Glucose (1) Using Glucose for Energy i. Glucose is main source of energy for body required by _, _ii.(2) Adequate Glucose Supply: 1) 1st: Storing Glucose as Glycogen: When have
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeHealthy Weight/Fad Diets I -Obesity trends among U.S. adults (1990, 1998, 2007) -BMI across different age groups -obesity prevention and treatment are national public health priorities -Georgia billboard campaign-hel
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeNUTRITION ASSESSMENT 1. Nutrition Assessment of Individual (1) Evaluates the many factors that influence or reflect nutritional health 1) _ regarding diet, health status, drug use, and socioeconomic status is gathere
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeWater and Minerals 1. Water (1) The most _ nutrient 1) Makes up about 60% of an adults body weight 2) Found in: Blood vessels, Cells, Chemical structure of cells, tissues, organs (2) Why is Water the Most Indispensab
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeWELCOME and NUTRITION BASICS I. FDNS 2100 Course Objectives Through readings, class lectures, and the assignment, students will learn: a. The basic constituents of food and their role in nutrition b. The complexity o
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeHow Do We Know What We Know? I1. How do we know what we know?2. Scientific Method (1) The process by which scientists, collectively and over time, endeavor to construct an accurate representation of the world a. Ob
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeFOOD LABELING1. Food Labels (1) Daily Values (DV) 1) Nutrient standards used on food labels, in grocery stores, and on some restaurant menus b. Reflect the nutrient requirements of an average person someone who eats
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeBody Basics1. The Bodys Cell (1) Cells require _. (2) All living things including cells die. (3) Each cell contains a complete set of genes. (4) Nutrients affect the genes activities within the cells (5) Cell _ Orga
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLee Spring, 20072005 DIETARY GUIDELINES FOR AMERICANS Key Recommendations for the General PopulationADEQUATE NUTRIENTS WITHIN CALORIE NEEDS Consume a variety of nutrient-dense foods and beverages within and among the b
UGA - FDNS - 2100
FDNS 2100 Exam 3 Study GuideLee 2011FDNS 2100 Exam 3 Study Guide Spring 2011 Nutrition Assessment Be familiar with the four nutrition assessments that were discussed in class Know how to assess dietary intake. Which methods are prospective & which ones
UGA - FDNS - 2100
FDNS 2100, Human Nutrition and Food Exam 3, November 20, 2007Lee Fall, 2007FORM A The following are potential errors in dietary intake assessment:o *ALL OF THE ABOVE* o Non-response bias o Recall error o Memory problems o Day to day variability in int
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeCARBOHYDRATES I1. FACTS ABOUT Carbohydrates (1) Consist of _, _ and _ (2) TYPES of Carbohydrates include (3):(3) Carbohydrates are our main SOURCE OF _ (4) Energy in carbohydrates originally came from the SUN via _
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeFOOD LABELING1. Food Labels (1) Daily Values (DV) 1) Nutrient standards used on food labels, in grocery stores, and on some restaurant menus b. Reflect the nutrient requirements of an average person someone who eats
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLeeWater and Minerals 1. Water (1) The most _ nutrient 1) Makes up about 60% of an adults body weight 2) Found in: Blood vessels, Cells, Chemical structure of cells, tissues, organs (2) Why is Water the Most Indispensab
UGA - FDNS - 2100
FDNS 2100 Human Nutrition and FoodLee Spring, 20072005 DIETARY GUIDELINES FOR AMERICANS Key Recommendations for the General PopulationADEQUATE NUTRIENTS WITHIN CALORIE NEEDS Consume a variety of nutrient-dense foods and beverages within and among the b
UGA - JRLC - 5040
Spring 11 Chapter 7 Political Speech Optional logs will be due Friday, March 25. First we look at the corporate rights to speak in referenda (Bellotti v. First National Bank of Boston), freedom from compelled speech (Pacific Gass and Electric v. Public Ut
UGA - JRLC - 5040
Alison Grimes Ch.5 Privacy 1. Define the private facts tort and tell how much protection the First Amendment provides for the press to publish lawfully acquired, truthful private information. Write the point of law from BJF. Understand the First Amendment
UGA - JRLC - 5040
BORING vs. GOOGLE, INC., UNITED STATES DISTRICT COURT FOR THE WESTERN DISTRICT OF PENNSYLVANIA 598 F. Supp. 2d 695; 2009 U.S. Dist. LEXIS 11682 February 17, 2009Facts: Pennsylvania property owners, the Borings, filed a suit in the Court of Common Pleas o
UGA - JRLC - 5040
Chapter 2, Part I Questions Spring 2011 These pages and questions present issues and terms important throughout the course. Friday Aug. 28 Part I. Write answers to Chapter 2, part I. Be prepared to discuss the questions as we progress through the chapter.
UGA - JRLC - 5040
Alison Grimes Log No. 2Chapter 2, Part 21. What's constitutionally deficient with the "bad tendency" test? Bad tendency test provides no First Amendment protection for speech. Expression may be halted or punished if it presents the slightest tendency to
UGA - JRLC - 5040
Alison GrimesCHAPTER 3Spring 2011 Optional Logs 1. What did Bickel mean about the legal reality and the cost to appearance? Another way to phrase the question: Did the New York Times and the press gain an uncompromised victory in the Pentagon Papers dec
UGA - JRLC - 5040
SubmittingElectronicFiles Pleasesubmitbriefs,logsofstudyquestionsandotherassignments toELCinWorddocumentfiles. 1.LabeleachWordfileasyousaveitwithyourlastnameandthe nameoftheassignment.E.g.,King,Logch2,pt2;or,King,Sullivan brief.Makesureeachfilesisa.docfil
UGA - JRLC - 5040
PrivacyandLibel(ch4&5) Online: Websiteshaveimmunityfromuserposts Usertermsholdindividualsliablefordefamatoryposts TheRedandBlacknewspaperbearsresponsibilityforletterstotheeditor inthepaper Section230 Theoriginatoralwayshasliability(ifthestoryislibelous) S
UGA - JRLC - 5040
TEST TWO REVIEW Chapter 4: Libel I. INTRODUCTION a. US Supreme Court still recognizes reputation as one of a persons most important possessions b. Libel law: only legal means to vindicate/recover a falsely tarnished reputation c. Number of successful libe
UGA - JRLC - 5040
IntellectualProperty Copyright 1976CopyrightActmadecopyrightlawmoreuniformbypreemptingstatelaw Copyrightallowsauthorstocontrolhowtheircreativeexpressioniscopied,distributed, andperformed TheconstitutiongivesCongressthepowertopromotetheProgressofScienceand
UGA - JRLC - 5040
Karen Baxter JRLC 5040 Extra Credit 810-107-4280Chapter 5: PrivacyINTRODUCTION Right of privacy is a development of the 20th century Right of privacy is rooted in the dignity of the individual Nearly all 50 states recognize the right to privacy Also inc
UGA - JRLC - 5040
Chapter4&5RelevantCourtCaseOutcomes Chapter4 Beauharnaisvs.Illinoiscourtupheldastatutethatcriminalizedanypublicationthat portraysdepravity,criminality,unchastity,orlackofvirtueinanyclassofcitizensthelaw wasusedtoprosecuteahatemongerwhodistributedracistli