Database Design: Conceptual Model (cont.), UML and The ...

Database Design Conceptual Model Cont UML And The -ppt Download

  • Date:20 Sep 2020
  • Views:12
  • Downloads:0
  • Size:1.22 MB

Share Presentation : Database Design Conceptual Model Cont UML And The

Download and Preview : Database Design Conceptual Model Cont UML And The

Report CopyRight/DMCA Form For : Database Design Conceptual Model Cont UML And The


Transcription:

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.

Related Presentations

Conceptual Design Using the ER Model

The Entity-Relationship Model Lecture 21 R&G - Chapter 2 A relationship, I think, is like a shark, you know? It has to constantly move forward or it dies.

9 Views0 Downloads

Sisters of the Academy Site Re Design Conceptual Model

Sisters of the Academy Site Re-Design (Conceptual Model) Cheryl Swanier, Isaac McCray, & Kennard Love Project Background As it currently stands, the website for the Sisters of the Academy Institute has already undergone a major re-design resulting in a currently non-released website.

2 Views0 Downloads

Model based Conceptual Design MBCD Working Group Introduction

Model-based Conceptual Design WG 2012 Activity Report. Joint SETE’12 and APOSE’12 conference in May 2012: Officially accepted as a Special Interest Group of the Systems Engineering Society of Australia (SESA) Organised an MBSE Panel plenary workshop session. INCOSE IS2012 - Rome.

4 Views0 Downloads

MODULE 2 DB2 Process Model Memory Model Database

DB2 UDB for Linux, UNIX, and Windows Performance and Tuning

26 Views0 Downloads

Logical Database Design and the Relational Model

Logical DB design: getting the requirements right >>correctly . transform. the biz logic . for implementation. An E-R data model is not a relational data model need normalization [2nd half of Ch 4] ERD is developed for the purpose of . understanding. biz rules, not structuring data for sound DB . processing. The last part is the goal of logical ...

25 Views0 Downloads

Figure 1 Conceptual model showing the psychological

Interrogating the Science of Resilience and Adversity:Strategies for Individuals, Families, Communities and Providers to Cope, Grow and Thrive . Andrés Felipe Sciolla, MD. Associate Professor. Department of Psychiatry & Behavioral Sciences. University of California, Davis. NAMI 5th Annual Multicultural Symposium: “Diversity in the Face of ...

14 Views0 Downloads

Alabama Racquetball Association Website Conceptual Model

The website should be easy to use. The website should provide all necessary information. Method. User interface design principles. Human computer interaction principles. Webpage development principles. Webpage optimizations. Alabama Racquetball Association Website Conceptual Model, 2008

5 Views0 Downloads

Rapid updating of conceptual model trend and reservoir

Caers, Jef Karel Created Date: 08/15/2006 17:00:00 Title: Rapid updating of conceptual model, trend and reservoir facies model at the appraisal stage Last modified by:

7 Views0 Downloads

Supporting Coastal and Marine Monitoring by Remotely Accessing Data Using Spatial Fusion and WAP A Conceptual Model

Fusion Data Services: registered with the OrbixWeb™ Implementation Repository and containing configuration files (data service name and location). Configuration Utilities: CARIS MapSmith™ and CARIS dbMaps™ - customize the display of CARIS, Oracle 8i Spatial, or Shapefile data.

0 Views0 Downloads

Journal Prompt 3 cont

Summary of Chapter 6. They are in the training center. Katniss experiences the luxury of her apartment-such a contrast to her life in District 12.Katniss, Peeta, Haymitch, Effie, Cinna, and Portia meet for dinner.During dinner, Katniss thinks she recognizes one of the servers. The girl is an Avox- someone who’s committed a crime and whose tongue has been cut out.

24 Views0 Downloads

Integrales de L nea cont y Superficies Parametrizadas

Hallar la ecuación del plano tangente en un punto P de la superficie. Area de una superficie de Revolución: Rota alrededor del eje x Rota alrededor del eje y Hallar el área de la función f(x,y) que está sobre el dominio [0,1]x[0,1] * * Title: Integrales de Línea (cont.) y Superficies Parametrizadas

7 Views0 Downloads

L7 Memory Hierarchy Optimization cont

L8: Memory Hierarchy Optimization, Bandwidth CS6963 Administrative Homework #2 Due 5PM, TODAY Use handin program to submit Project proposals Due 5PM, Friday, March 13 (hard deadline) MPM Sequential code and information posted on website Class cancelled on Wednesday, Feb. 25 Questions?

8 Views0 Downloads