Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.
8 Pages
Lecture06
Course: BTD 210, Fall 2009School: CSU Fullerton
Rating:
Word Count: 499
Document Preview
Howtoconvertfromtheconceptualmodelto DatabaseDesignPrinciples Lecture6 MovingtoaLogicalModel LectureObjectives thelogicalmodel Refiningthekeystructureofanentity Refiningrelationshipsbetweenentitiesbased onBusinessRules 2 ConvertingEntities 1. 2. 3. Addattributestoeachentity VerifyPKdefinedinconceptualmodelisit appropriatefortableordoesanotherunique (generic)PKneedtobedefined Removederivedvalues 3...
Unformatted Document Excerpt
Coursehero >> California >> CSU Fullerton >> BTD 210Course 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.
Howtoconvertfromtheconceptualmodelto DatabaseDesignPrinciples
Lecture6
MovingtoaLogicalModel
LectureObjectives
thelogicalmodel Refiningthekeystructureofanentity Refiningrelationshipsbetweenentitiesbased onBusinessRules
2
ConvertingEntities
1. 2.
3.
Addattributestoeachentity VerifyPKdefinedinconceptualmodelisit appropriatefortableordoesanotherunique (generic)PKneedtobedefined Removederivedvalues
3
ConvertingRelationships
1. 2. 3.
For1:Mconnectivity,takethePKofthe1table andmakeitanFKintheMtable For1:1connectivity,takethePKofthemaintable andmakeitanFKinthedestinationtable ForM:Nconnectivity,createabridgetable
IncludethePKfromeachoftheoriginaltablesas compositePKinthebridgetable.ThesewillalsobeFKs inthebridgetable Addadditionalattributestothebridgetableasrequired
4.
ForStrongWeakEntityrelationships,takethePK oftheStrongEntityandincludeitaspartofthePK oftheWeakEntity.ItwillalsobeanFKinthe WeakEntity
4
ExampleConversion
Giventhe followingERD, converttoa logicalmodel usingthe techniques provided
LIBRARIAN PK EMPL_ID NAME
CATEGORY PK CAT_ID CAT_NAME
BOOK PK,FK1 FK2 BOOK_ID CUST_ID
CUSTOMER PK CUST_ID NAME BOOK_ID
FK1
5
ExampleConversion
1. 2.
Noterelationship appropriatenowbetween librarianandborrow transactions
LIBRARIAN PK EMPL_ID NAME
3.
4.
Addattributes mayinvolve RefinePKs(this creatinganew, moremeaningful PK) Removederived values(noneinthis example) Allrelationships revised(1:1,1:M, M:N)
CUSTOMER PK CUST_ID can generate
has
Notenewentity createdto handleM:N relationship betweenbook andcustomer
CATEGORY PK CAT_ID CAT_NAME
BORROW_TRANSACTION PK FK1 FK2 TRANS_ID CUST_ID EMPL_ID has contains BORROW_DETAIL PK,FK1 PK FK2 TRANS_ID LINE_NUMBER BOOK_ID FK1 CAT_ID BOOK can be on PK BOOK_ID
6
InSummary
Aconceptualmodelcanhaveafewattributesor manyattributesdependingonthelevelofdetail providedinanarrative Mostoften,wewilladdasmanyattributesas areknowntotheinitialconceptualmodeltoget ittoanadequatelevelofdetail(orascloseto logicalaspossible)
7
ExampleLogicalDesign
SAS(SupportAS...
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:
Below is a small sample set of documents:
CSU Fullerton - BTD - 210
DatabaseDesignPrinciplesLectureNormalizationLectureObjectivesReviewbasicrulesforconvertingEntitiesto Tables ReviewhowtoaddressRelationships betweenentities OverviewofNormalization2ConvertingERDintoRelational DatabaseModel1.Entitie
CSU Fullerton - DES - 715
Database Design Lecture 13Object TerminologyOO TerminologySimple ObjectContains only singlevalued attributes and has no attributes that refer to other objectsCurrentSemester -semesterCode -semesterName -startDate -endDate 2OO Te
CSU Fullerton - DES - 715
DatabaseDesignLecture18Client/Server,Data WarehouseandE CommerceDatabaseDesignLectureObjectives Client/Server DataWarehouse ECommerce2Client/Server Acomputingmodel/architecture Functionalityisdistributedbetweenservers andclients
CSU Fullerton - DES - 715
Microsoft Access Tutorial TUTORIAL: CREATING A NEW RELATIONAL SCHEMA OVERVIEW In this tutorial you will create a relational schema in Access. o PART I Creating a database and adding entities o PART II Adding relationships TUTORIAL START PART I ADDI
CSU Fullerton - DES - 715
Microsoft Visio Tutorial TUTORIAL: CREATING A NEW OBJECT DATA MODEL1OVERVIEW In this tutorial you will create an object data model in Visio. In this model entities and their attributes will be shown. TUTORIAL START PART I ADDING ENTITIES AND ATTR
CSU Fullerton - DES - 715
DES715 Database Design Class Diagram The following describes the process when a customer brings a vehicle in for servicing. From this narrative, draw the class diagram. Show classes with attributes. Show relationships (associations, aggregation/compo
CSU Fullerton - DES - 715
DES715 In Class Exercise: Class Diagram Using the document sample at the bottom of this page, complete the following a. b. c. d. Identify the main classes Identify the attributes for each class Draw the class diagram Show appropriate relationships (a
CSU Fullerton - DES - 715
DES715 InClassExercise Bottom Up DesignCustomer statement sample for pet care:Statement # 0171658 Client: 1455933 Ann & Mark Smith 127 Main Street Toronto, Ontario M1M 1M1 Date: 11/24/03Patient: RUSTY Patient ID: 1924 Medical History: RABIES due:
CSU Fullerton - DES - 715
DES715 In Class Exercise Bottom Up DesignNormalization. You have been given the following sample document. Using main form/sub form design, create the tables to support this document. You may create attributes as required. Ensure all attributes are
CSU Fullerton - DES - 715
DES715 Database Design In-Class Exercises: Dependency DiagramDependency Diagram Exercises1. Using the figure below, label all the transitive and partial dependencies (dependency diagram has been shown two ways: horizontal and vertical):ABC
CSU Fullerton - DES - 715
DES715 In Class Exercise Exercise 1 Given the following overview and sample report, create a normalized table structure by drawing the dependency diagram and showing the tables through 1NF, 2NF and 3NF.Order Detail ReportOrder Number Order Date Cu
CSU Fullerton - DES - 715
DES715 Design Challenge Option 1:Customer Employee -empolyeeId[1] -fName[1] -lName[1] -address[1] -gender[1] -date_of_birth[1] -job _position[1] -SECTOR[1] : Sector -PACKAGE [1.*] : Package -customerId[1] -fName[1] -lName[1] -email[1] -phone[1] -ad
CSU Fullerton - DES - 715
DES715 Database Design Winter 2009 Quiz 3Page 1 of 1Order nurseName 1 containsfills 1.n 1Pharmacist name1.n Prescription 1.n has 1.n has Prescriptio nDetail 1.n dosage qty repeat Drug name is on 11 Patient name unit roomNum
CSU Fullerton - DES - 715
DES715 In-Class Exercise Part 1: For each of the following: 1. Provide examples of centralized entities. 2. Identify potential attributes and keys for the entities. Identify significant attributes. Dont go overboard. 3. Design a distributed structure
CSU Fullerton - DES - 715
DES715 In Class Exercise Bottom Up DesignNormalization. You have been given the following sample document. Using main form/sub form design, create the tables to support this document. You may create attributes as required. Ensure all attributes are
Milwaukee School of Engineering - ME - 191
ME 191 ScheduleQuarter: Room:8:00 9:00 10:00 11:00 12:00 1:00 2:00 3:00 4:00 5:00Spring 2009 S G32Mon Tue Wed Thu Fri ME 191-001 ME 191-002 ME 191-001 ME 191-002 (Carnell) (Carnell) (Carnell) (Carnell)OPEN LABME 191-003 (Farrow)OPEN LABM
Milwaukee School of Engineering - ME - 191
John Jones ME-191, Section 04 Lab 1 March 16, 2015 Digital Input / Output Exercises I. Problem StatementLab 1 consisted of . Part one of the lab required .Part two of the lab further developed the concepts of Part 1 by requiring II.Solution M
Milwaukee School of Engineering - MT - 4901
MT-4901Mid-Term Review of Design Project Week 6Time Allotted: 10 15 minutes Organization: Project Title Background Project Goals Technical Work Completed Technical Work Remaining Reference: Chapter 6 of the course text: Dym & Little, Engineering
Milwaukee School of Engineering - MT - 4901
MT-4901 Senior Capstone Project Spring, 2008 March Dates Week 1 3/4 Week 2 3/11 Week 3 3/18 Topics Introduction to the Capstone Project No formal class meeting Assignment 1 due No formal class meeting Assignment 2 due * Spring Break Week * April Da
Milwaukee School of Engineering - MT - 4901
MT4901 Capstone Project Advisor Grade Sheet Student:_Advisor:_Problem-Solving or Design Content (25%) Clear, complete problem definition (10%) o Problem definition clearly stated o Objectives and constraints listed Effective use of library resear
Milwaukee School of Engineering - MT - 4901
MT-4901 Capstone Project Spring, 2008 Instructor: Mr. Stephen Rather Office: S-125A e-mail: rather@msoe.edu Web Page: Textbook:Phone: 414-277-7425http:/people.msoe.edu/~rather/me/MT4901/4901notes.html Engineering Design: A Project-Based Introduct
Milwaukee School of Engineering - MT - 4901
MT-4901 Capstone Project Fall, 2007 Instructor: Office: S-125A Web Page: Textbook: Mr. Stephen Rather e-mail: rather@msoe.eduPhone: 414-277-7425http:/people.msoe.edu/~rather/me/MT4901/4901notes.html Engineering Design: A Project-Based Introductio
Milwaukee School of Engineering - MT - 4901
MT-4901 Capstone Project Fall, 2007 Instructor: Office: S-125A Web Page: Textbook: Mr. Stephen Rather e-mail: rather@msoe.eduPhone: 414-277-7425http:/people.msoe.edu/~rather/me/MT4901/4901notes.html Engineering Design: A Project-Based Introductio
Milwaukee School of Engineering - MT - 4901
MT-4901 Capstone Project Assignment 1 Task: Produce a "Problem Definition" document (see the sample attached). It must include: Your name Your project advisor's name A Problem Statement A detailed list of project objectives and milestones (note t
Milwaukee School of Engineering - MT - 4901
MT-4901 Capstone Project Assignment 1 Task: Produce a "Problem Definition" document (see the sample attached). It must include: Your name Your project advisor's name A Problem Statement A detailed list of project objectives and milestones (note t
Milwaukee School of Engineering - MT - 4901
MT-4901 Capstone Project Assignment 2 Task: Review of Project Management Concepts Read Chapter 7 in the MT 4901 textbook. Other useful background information can be found on the Wikipedia web site. A link to that web site appears on the course web pa
Milwaukee School of Engineering - MT - 4901
MT-4901 Capstone Project Assignment 3 Task: Review Patent Law Concepts After completing Patent Law readings in the MT-4901 text book and on the web site, answer the following questions: 1. What is required for and "idea" to become a patent (see the U
Milwaukee School of Engineering - MT - 4901
MT-4901 Capstone Project Assignment 4 Engineering Ethics After completing the Engineering Ethics module of the ASME Professional Practice Curriculum, answer the following questions: 1. According the ASME Fundamental Canons, what must practicing engi
Milwaukee School of Engineering - MT - 4901
Investigating Design AlternativesA Log Splitter Example(from: an earlier edition of Introduction to Engineering Design and Problem Solving, by Eide, et. al.)Brainstorming TechniquesAnalysis Using scientific and engineering principlesEvalua
Milwaukee School of Engineering - MT - 4901
Engineering Design Process.the process of devising a system, component, or process to meet desired needs..an iterative decision-making process in which the basic sciences , mathematics, and engineering science are applied to convert resources opt
Milwaukee School of Engineering - MT - 4901
MT4901 Capstone Project Committee Member Grade Sheet Student:_Committee Member _Problem-Solving or Design Content Clear, complete problem definition (15%) o Problem definition clearly stated o Objectives and constraints listed o Background researc
UNC Asheville - EGM - 180
Exercise 5: A nightlightCreate the following nightlight circuit on your boe-bot breadboard:Questions:1. A photoresistor is a light sensitive resistor. When its dark, the photoresistors resistance is large; when its light, the photoresistors resis
UNC Asheville - EGM - 180
EGM 180 Take Home Quiz 1Due at the start of class on Feb 4th For the past two weeks we have been experimenting with basic circuit design. We have measured current, voltage, and resistance. We have also experimentally verified Ohms Law, and Kirchhoff
UNC Asheville - EGM - 180
DC MotorsTaken from a variety of sources including: http:/electronics.howstuffworks.com and http:/micro.magnet.fsu.edu/electromag/electricity/generatMotorsElectromagnetic direct current (DC) motors Usually runs high speed and low torque (Gear
UNC Asheville - EGM - 180
EGM 180 Take Home Quiz 2 (Due Friday Feb 13 at the start of class) In this exam, you are asked to address two questions in writing. The answer to each question should be multiple paragraphs long. Both questions refer to the schematic below. The schem
UNC Asheville - EGM - 180
EGM 180 Take Home Quiz 3: Due Friday Feb 20thIn 2004, the Discovery Channel's "Mythbusters" presented a segment debunking one of John Bedini's circuits used in the Bedini motor. The Bedini motor has been described as a motor that, employs a device t
UNC Asheville - EGM - 180
IR ControlMaterialstakenfromIRRemoteforthe BoeBotbyAndyLindsayThe Plan: Use a TV Remote to Control the Boe-BotIRSignal: 980nm, 38.5kHzBasicStamp Programto GuidetheBoeBot BasedonIRsignalsSonyTVRemote Control.PWM: Inverted, 0.6msPWoff 1.2msPW
UNC Asheville - EGM - 180
Exercise 13: Controlling the Bot-Boe With IRThis exercise covers the material presented in IR Remote for the Boe-Bot by Andy Lindsay. While you are not required to read this material, it is recommended. Question 1. Write a program using constants, s
UNC Asheville - EGM - 180
Exercise 14: SolidWorks and the VexPart 1: SolidWorksSolidWorks is a 3D mechanical computer-aided design (MCAD) software package; arguably one of the most widely used CAD packages in industry today. In addition to mechanical design, SolidWorks can
UNC Asheville - EGM - 180
Exercise 16: Working with Sheet MetalIn this exercise, you have the opportunity to try out the sheet metal tools that you've just learned about in lecture. Use the sheet metal strip issued to your group to try each of the tools listed below.Tools
UNC Asheville - EGM - 180
BoeBotProject1PROJECTDESCRIPTION:DesignandbuildaBoeBottocompeteintheenhancedRoboBilliardsevent.PROJECTDOCUMENTATION:YourcompleteprojectdocumentationisdueinclassonApril1st.Onedocumentation packageisrequiredperteam.Theprojectincludesthefollowing:
UNC Asheville - EGM - 180
EGM 180 Take Home Quiz 4: Due Friday March 20thRead the following article and write a response essay. Your essay must exhibit appropriate structure. It should have an introduction and a conclusion. The introduction should include a thesis statement-
UNC Asheville - EGM - 180
Exercise 17: Detecting Objects with an Ultrasonic SensorThis exercise makes use of the material presented in PING Ultrasonic Distance Sensor by Parallax. While you are not required to read this material, it is recommended. Connect the Ping sensor as
UNC Asheville - EGM - 180
Exercise 18: IR and QTIsMuch of the material in this exercise is taken from Robotics with the Boe-Bot by Andy Lindsay. While you are not required to read this material, it is recommended. You can use your QTIs (or photoresistors) to detect the prese
UNC Asheville - EGM - 180
ControlSome Material taken from RobotSubsumption.pdfRemember Where Are We Going?SumoBot competitionsControlling Robot Movement Based on QTI (or Photo-Resistor) Readings' [ Constants ] LeftDark CON 108 RightDark CON 114 LeftWh
UNC Asheville - EGM - 180
13-team double eliminationwinners bracket11 1 2 3 4#6 #1 #15 #2 #712#215 6 7 8 9 10#3 #8 #4 #16 #5 #913#24losers bracketL Closer ofJloser of #6loser of #21 loser of #16#25winner#3A #4#14loser ofB#10#19 #17#23
Purdue - HORT - 306
Lecture 251Lecture 25 Herbal RecipeA copy of the rst edition (1597) of John Gerards famous herbal (The Herball or Generall Historic of Plantes) is in the Purdue Library (now in the manuscript case of the Pharmacy Library). In this copy there are
Oregon State - SR - 1072
Agricultural Experiment Station Oregon State UniversitySpecial Report 1072June 2007Central Oregon Agricultural Research Center 2006 Annual ReportTrade-name products and services are mentioned as illustrations only. This does not mean that the O
Oregon State - SR - 1072
2006 Station Faculty and StaffAdministrative Marvin Butler, Superintendent, COARC, Professor, Crop and Soil Science, Chair, Jefferson County Extension Leta Morton, Office Specialist II, COARC Faculty Dr. Fred Crowe, Associate Professor, Botany and
Oregon State - SR - 1072
Carrot Tolerance to Pendimethalin and Mesotrione Broadcast at LaybyRichard Affeldt, John MacKenzie, Bruce Martens, and Kurt Farris Abstract The objective of this trial was to determine carrot tolerance to pendimethalin and mesotrione applied as an o
Iowa State - STAT - 579
Stat579 Homework7 Solution: 1. (a) > >vote<read.table("http:/www.public.iastate.edu/~maitra/stat579/ FL2000vote.dat",header=TRUE) >head(vote) GOREBUSHBUCHANANNADERNELSONMCCOLLUMLOGAN ALACHUA4736534124263322649091310601735 BAKER2392561073533104457850
Temple - CP - 2579
CIS 1055 Debate ProjectDue 4/20/2009Teams of students will research and debate an issue. Teams will consist of 4 students. For each issue there will be one team that is divided in half. One half of the team will represent the pro side of the issue
Iowa State - STAT - 579
case speed dist1 4 22 4 103 7 44 7 225 8 166 9 107 10 188 10 269 10 3410 11 1711 11 2812 12 1413 12 2014 12 2415 12 2816 13 2617 13
Temple - CIS - 4309
CIS4309: Client/Server & Net-Centric ComputingSyllabus - Fall 2008 Lecturer: Christopher M. PascucciContact InformationOffice: Wachman Hall, Room 412 215-204-9656 Office Hours: Monday 10:00am 12:30pm Tuesday 11:00am 3pm Friday 9:30am 10:30am Ot
Iowa State - STAT - 579
0.8758653 -0.07872465 1 1 -1.713688-1.347825 -1.394871 0.2020388 1 -1.700831-0.553068 0.5087647 -0.3772446 1 -1.4610291 0.4433004 -0.3294565 -0.2231128 -0.2558858
Iowa State - STAT - 579
CountryRedMeatWhiteMeatEggsMilkFishCerealsStarchNutsFr&VegAlbania10.11.40.58.90.242.30.65.51.7Austria8.914.04.319.92.128.03.61.34.3Belgium13.59.34.117.54.526.65.72.14.0Bulgaria7.86.01.68.31.256.71.13.7
Iowa State - STAT - 579
Homework 2 Due September 171. The Titanic. The dataset, available as a comma-separated le on the WWW at www.public.iastate.edu/ maitra/stat579/titanic.txt provides the survival status of passengers on the Titanic, together with their names, age, s
Iowa State - STAT - 579
Homework 4 Due October 11. Microarray gene expression data. The le, accessible on the WWW at the location: http : /www.public.iastate.edu/ maitra/stat579/diurnaldata.csv contains gene expression data on 22,810 genes from Arabidopsis plants exposed
Temple - CIS - 4309
.NETProgrammingCodeBehindClicktoeditMastersubtitlestyleChristopher M. Pascucci6/3/09WhatisaCodeBehind?v vThe ASPX file contains HTML and the ASP tags for the server controls (WFC). A CodeBehind refers to a separate class file that contain
Temple - CIS - 4309
Exceptions & Error HandlingChristopher Master subtitle style Click to edit M. Pascucci6/3/09Errors and ExceptionsAn error is a bug in your program. dividing by zero going outside the bounds of an array trying to use a null object or reference A
Iowa State - STAT - 579
Homework 3 Due September 241. Consider the following dataset: group Y A 0.64 A 0.33 A 1.02 A 0.78 A 5.12 A 1.84 A 0.45 A 2.13 A 1.13 A 2.36 B 0.39 B 0.83 B 5.66 B 8.06 B 24.93 B 1.97 B 0.44 B 2.57 B 2.53 B 13.27 The primary objective for this exerc