Download and Preview : Database Design Conceptual Model Cont UML And The
Report CopyRight/DMCA Form For : Database Design Conceptual Model Cont UML And The
Database Design ConceptualModel cont UML andThe Logical ModelUniversity of California BerkeleySchool of Information.IS 257 Database ManagementIS 257 Fall 2015 2015 09 15 SLIDE 1 Lecture Outline Review and continuation Database Design Conceptual Model. Assignment 2 Personal DatabaseConceptual Design Object Oriented Modeling in UML The Logical ModelIS 257 Fall 2015 2015 09 15 SLIDE 2. Lecture Outline Review and continuation Database Design Conceptual Model Assignment 2 Personal DatabaseConceptual Design. Object Oriented Modeling in UML The Logical ModelIS 257 Fall 2015 2015 09 15 SLIDE 3 Database Design ProcessApplication 1 Application 2 Application 3 Application 4.External External External ExternalModel Model Model ModelApplication 1Conceptualrequirements.Application 2ConceptualrequirementsConceptual Logical ModelApplication 3 Model Model.ConceptualrequirementsApplication 4Conceptualrequirements.IS 257 Fall 2015 2015 09 15 SLIDE 4 Developing a Conceptual Model Overall view of the database that integrates allthe needed information discovered during therequirements analysis . Elements of the Conceptual Model arerepresented by diagrams Entity Relationship orER Diagrams that show the meanings andrelationships of those elements independent ofany particular database systems or.implementation details Can also be represented using other modelingtools such as UML more later IS 257 Fall 2015 2015 09 15 SLIDE 5 Developing a Conceptual Model. Building the Conceptual Model for theDiveshop databaseIS 257 Fall 2015 2015 09 15 SLIDE 6 Developing a Conceptual Model We will look at a small business a.diveshop that offers diving adventure Assume that we have done interviews withthe business and found out the followinginformation about the forms used andtypes of information kept in files and used.for business operations IS 257 Fall 2015 2015 09 15 SLIDE 7 Customer Dive Sites Dive Order Sea Life Line item Shipwrecks. Shippinginformation Dive Equipment Stock Inventory Dive Locations.IS 257 Fall 2015 2015 09 15 SLIDE 8 Diveshop Entities DIVECUSTZIP PostalCity State ProvStreet Country.Name PhoneCustomer noIS 257 Fall 2015 2015 09 15 SLIDE 9 Ordering Full ERNo DiveCust.Destination Customer ShipViaDestination nno 1 n n ShipVia ShipViaDest DiveOrds 1Destination.DiveStok ItemIS 257 Fall 2015 2015 09 15 SLIDE 10 Location Site SelectionDestination DestinationDestination.DiveOrds to DestIS 257 Fall 2015 2015 09 15 SLIDE 11 Destination SitesDestinationDestination.Dest DiveOrdsDestinationDestinationIS 257 Fall 2015 2015 09 15 SLIDE 12 Sites and Sea Life 2.DestinationSpecies BioLifeIS 257 Fall 2015 2015 09 15 SLIDE 13 Sites and ShipwrecksDestination.IS 257 Fall 2015 2015 09 15 SLIDE 14 DiveShop ER DiagramNo DiveCustDestination Customer ShipViaDestination n.no n 1 ShipVia ShipViaDestination 1DestinationBioSite ShipWrck nSpecies DiveStok Item.BioLife NoIS 257 Fall 2015 2015 09 15 SLIDE 15 What must be calculated Total price for equipment rental Total price for equipment sale . Total price of an order Vacation price Equipment rental or sale ShippingIS 257 Fall 2015 2015 09 15 SLIDE 16. What is Missing Not really an enterprise wide database No personnel Sales people Dive masters. Boat captains and crew payroll No Local arrangements Dive Boats Charter bookings . Hotels Suppliers Wholesalers for dive equipment Orders for new replacement equipment No history only current or last order IS 257 Fall 2015 2015 09 15 SLIDE 17. Lecture Outline Review and continuation Database Design Conceptual Model Assignment 2 Personal DatabaseConceptual Design. Object Oriented Modeling The Logical ModelIS 257 Fall 2015 2015 09 15 SLIDE 18 Assignment 2 Due Friday March 10. Personal Database Project Design Note decide groups by February 24th The following information should be turned in for the preliminary design ofyour personal database project 1 A written description of the data you will be using for the database and what.uses you might expect the database to have 2 4 pages 2 A preliminary data dictionary for the entities and attributes and format of thedata elements of the database You should have at least 5 entities withsome logical connections between them The data dictionary consists of allof the attributes that you have identified for each entity along with indication.of whether the attribute is a primary key or part of a primary key and whatformat the data will be e g text decimal number integer etc 3 Produce an entity relationship diagram of the database OR a UML diagram These will be preliminary design specifications so do not feel that you mustfollow everything that you describe here in the final database design . The report should be in PDF and submitted via our bCourses siteIS 257 Fall 2015 2015 09 15 SLIDE 19 Discussion of Projects Anyone have any ideas for projects for thisIS 257 Fall 2015 2015 09 15 SLIDE 20. Tools for ER and UML diagrams Microsoft Visio has a UML like set ofdiagramming templates for databases For Macs OmniGraffle has UML or spreadsheettemplates that can be used for ER diagrams. More sophisticated and open source CASE toolsare available such as MySQLWorkbench for MySQL only DBDesigner optimized for MySQL databases Toad freeware version . Many other drawing packages have ERDavailable sometimes as add ons IS 257 Fall 2015 2015 09 15 SLIDE 21 Lecture Outline Review and continuation . Database Design Conceptual Model Assignment 2 Personal DatabaseConceptual Design Object Oriented Modeling in UML The Logical Model.IS 257 Fall 2015 2015 09 15 SLIDE 22 Object Oriented Modeling Becoming increasingly important as Object Oriented and Object Relational DBMScontinue to proliferate. Databases become more complex and havemore complex relationships than are easilycaptured in ER or EER diagrams Most UML examples based on McFadden ModernDatabase Management 5th edition .IS 257 Fall 2015 2015 09 15 SLIDE 23 Object Benefits Encapsulate both data and behavior Object oriented modeling methods can beused for both database design and.process design Real World applications have more than justthe data in the database they also involve theprocesses calculations etc performed on thatdata to get real tasks done. OOM can be used for more challenging andcomplex problemsIS 257 Fall 2015 2015 09 15 SLIDE 24 Unified Modeling Language UML Combined three competing methods. Can be used for graphically depicting Software designs and interaction Database ProcessesIS 257 Fall 2015 2015 09 15 SLIDE 25. A class is a named description of a set of objectsthat share the same attributes operations relationships and semantics An object is an instance of a class that encapsulatesstate and behavior . These objects can represent real world things or conceptual An attribute is a named property of a class thatdescribes a range of values that instances of thatclass might hold An operation is a named specification of a service that.can be requested from any of a class s objects toaffect behavior in some way or to return a valuewithout affecting behaviorIS 257 Fall 2015 2015 09 15 SLIDE 26 UML Relationships. An relationship is a connection between oramong model elements The UML defines four basic kinds ofrelationships Association. Dependency Generalization RealizationIS 257 Fall 2015 2015 09 15 SLIDE 27 UML Diagrams. The UML defines nine types of diagrams activity diagram class diagram Describes the data and some behavioral operations of a system. collaboration diagram component diagram deployment diagram object diagram sequence diagram. statechart diagram use case diagramIS 257 Fall 2015 2015 09 15 SLIDE 28 Class Diagrams A class diagram is a diagram that shows a.set of classes interfaces and orcollaborations and the relationshipsamong these elements IS 257 Fall 2015 2015 09 15 SLIDE 29 UML Class Diagram.DIVEORDS Class NameCustomer NoPaymentMethodNo of People List of AttributesDepart Date.Return DateDestinationVacation CostCalcTotalInvoice CalcEquipment .List of operationsIS 257 Fall 2015 2015 09 15 SLIDE 30 Object Diagrams307 DIVORDSOrder No 307.Customer No 1480Sale Date 9 1 99Ship Via UPSPaymentMethod VisaCCNumber 12345 678 90.CCExpDate 1 1 01No of People 2Depart Date 11 8 00Return Date 11 15 00Destination Fiji.Vacation Cost 10000IS 257 Fall 2015 2015 09 15 SLIDE 31 Differences from Entities in Entities can be represented by Class But Classes of objects also have.additional operations associated with themIS 257 Fall 2015 2015 09 15 SLIDE 32 Operations Three basic types for database Constructor. UpdateIS 257 Fall 2015 2015 09 15 SLIDE 33 Associations An association is a relationship thatdescribes a set of links between or among. An association can have a name thatdescribes the nature of this relationship You can put a triangle next to this name toindicate the direction in which the nameshould be read .IS 257 Fall 2015 2015 09 15 SLIDE 34 Associations An association contains an ordered list ofassociation ends An association with exactly two association.ends is called a binary association An association with more than two ends iscalled an n ary association IS 257 Fall 2015 2015 09 15 SLIDE 35 Associations Unary relationships.Is married to managesIS 257 Fall 2015 2015 09 15 SLIDE 36 Associations Binary Relationship0 1 Is assigned 0 1 ParkingOne to one.Product 1 contains One to many Registers for Student CourseMany to many.IS 257 Fall 2015 2015 09 15 SLIDE 37 Associations Ternary RelationshipsVendor Supplies WarehouseIS 257 Fall 2015 2015 09 15 SLIDE 38 Association Classes.Registers forStudent CourseComputer AccountRegistration . Term issues 0 1 PasswordServerSpace .CheckEligibility IS 257 Fall 2015 2015 09 15 SLIDE 39 Derived Attributes Associations andStudent Course Offering. name Scheduled forRegisters for crseCodessn term 1 crseTitle.dateOfBirth section age Derived timeattribute location participant Derived role age currentDate dateOfBirth .Derived associationIS 257 Fall 2015 2015 09 15 SLIDE 40 Generalization .printLabel ConsultantHourly Employee Salaried Employee contractNumberHourlyRate Annual Sal billingRate. stockoption computeWages computeFees Contributepension IS 257 Fall 2015 2015 09 15 SLIDE 41 Other Diagramming methods. SOM Semantic Object Model Object Definition Language ODL Not really diagramming Access relationships display Hybrids.IS 257 Fall 2015 2015 09 15 SLIDE 42 Application of SOM to DiveshopStreet 1 1StateProvince 1 1ZIPPostalCode 1 1.Country 1 1 1 1FirstContact 1 1DIVEORDS 1 NIS 257 Fall 2015 2015 09 15 SLIDE 43DESTINATION.PaymentMethodNoOfPeopleDepartDateReturnDateVacationCost.IS 257 Fall 2015 2015 09 15 SLIDE 44 Lecture Outline Review and continuation Database Design Conceptual Model Assignment 2 Personal Database.Conceptual Design Object Oriented Modeling in UML The Logical ModelIS 257 Fall 2015 2015 09 15 SLIDE 45 Database Design Process.Application 1 Application 2 Application 3 Application 4External External External ExternalModel Model Model ModelApplication 1Conceptual.requirementsApplication 2Conceptualrequirements.Overall view of the database that integrates all the needed information discovered during the requirements analysis. Elements of the Conceptual Model are represented by diagrams, Entity-Relationship or ER Diagrams, that show the meanings and relationships of those elements independent of any particular database systems or implementation details.