Relational Databases - Comp2400 / Comp6240
Lecture 9: Modelling and Translation
How to design a database
What is a model?
Why model?
What is UML?
Decisions
Translation
See Elmasri and Navathe, Chapters 3 and 4, but especially 12.
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Understanding UML: A Modeling Language for Software and Databases, Slides of Relational Database Management Systems (RDBMS)
An introduction to uml (unified modeling language), explaining its origins, purpose, and basic diagram types. Uml is a visual language used for modeling software-intensive systems and databases. It is based on object-oriented principles and is essential for system design and development. Descriptive and prescriptive models, the role of uml in system lifecycle, and its relationship with entity-relationship (er) diagrams.
Typology: Slides
2011/2012
1 / 69
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Understanding UML: A Modeling Language for Software and Databases and more Slides Relational Database Management Systems (RDBMS) in PDF only on Docsity!
Relational Databases - Comp2400 / Comp
Lecture 9: Modelling and Translation
How to design a database
What is a model? Why model? What is UML? Decisions Translation
See Elmasri and Navathe, Chapters 3 and 4, but especially 12.
Where are we now?
UML Model
Relational Model
Computer
translation
DBMS implemention
This weeks lectures and next weeks lab session are about the top box and the arrow coming out of it.
What is a Model?
A model of something resembles that thing in a particular way, for a specific purpose
What is a Model?
A model of something resembles that thing in a particular way, for a specific purpose is smaller, cheaper, simpler
What is a Model?
A model of something resembles that thing in a particular way, for a specific purpose is smaller, cheaper, simpler can take that things place so we can learn about the thing by studying the model
What is a Model?
A model of something resembles that thing in a particular way, for a specific purpose is smaller, cheaper, simpler can take that things place so we can learn about the thing by studying the model which is cheaper, faster, easier, possible
Example Models
Crash-Test Dummy
resembles a human specifically, body movement in crashes shows us effects of crash without hurting anyone
Meteorological Model
a mathematical structure and/or computer program resembles the weather and its progress runs faster than reality enables weather prediction
Descriptive and Prescriptive
those two example models resemble something that exists
Descriptive and Prescriptive
those two example models resemble something that exists but in software and databases we make a model of something we want, which does not exist
Descriptive and Prescriptive
those two example models resemble something that exists but in software and databases we make a model of something we want, which does not exist create that thing from its model
Descriptive and Prescriptive
those two example models resemble something that exists but in software and databases we make a model of something we want, which does not exist create that thing from its model
In database design, we do both.
the model resembles an aspect of the world that we want to record in the database
Descriptive and Prescriptive
those two example models resemble something that exists but in software and databases we make a model of something we want, which does not exist create that thing from its model
In database design, we do both.
the model resembles an aspect of the world that we want to record in the database we create a database schema from the model
Why Model?
Model purpose allows us to ignore irrelevant detail, and work at a “higher level of abstraction”.
Why Model?
Model purpose allows us to ignore irrelevant detail, and work at a “higher level of abstraction”.
This applies to all phases of system lifecycle Requirements capture and analysis