Data Modelling.pptVIP

Conceptual Modelling Entity Relationship Model Overview Entities, Attributes and Relationship modelling Generating a Relational Database for an EAR model Tutorial - Using the QSEE case tool Abstraction Layers Conceptual What data is held An Image and its meta-data Entity-Relationship model (ERM) Logical How data is organised in storage Block and Directory structure Tables, keys Physical How data is stored in bits JPEG as a stream of bytes A Database as files and records stored in a DBMS-specific format ER Model This modelling language allows a very small vocabulary: Just as English has nouns, verbs, adjectives, pronouns.. ER models have only 3 core concepts Attribute – a simple, atomic data item like a date, a name, a number [also called Property or Field] Entity – a group of attributes which are all related to the same thing [also called Entity Type or Class] Relationship – a relationship between Entities. Entities and Instances MMS application A simple web application which allows an account holder to send a photo from a mobile phone to a web site to be added to a photo gallery Server Technology Data storage in MySQL relational database Scripting language : PHP MMS Photo : EAR diagram Other conceptual models ERM is not the only conceptual model in use Object-role model (ORM) drop the distinction between attributes and relationships – its all relationships. Single level models (RDF) drop the distinction between type and instance. Case Tool - QSEE is a free download for individual use is available in the lab (older version ?) enables a wide range of diagram types to be created UML Data flow diagrams … Entity-relationship diagram With generation of SQL for creating a database (with some fixes ? - use Perl script to clean up) Entity (type) Typically represents a type of thing –person, department, photo with properties of interest Similar to a Class in Object-Orientation (but no methods) Has a name Name becomes the name of the table in a database I p