Class07.1_SemanticObjects_Fall2008NEW

Class07.1_SemanticObjects_Fall2008NEW - BCIS 4620...

Info iconThis preview shows pages 1–16. Sign up to view the full content.

View Full Document Right Arrow Icon
BCIS 4620 INTRODUCTION TO DATABASE PROCESSING Class 7 Spring 2009 Dr. Jack D. Becker
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CLASS 5 -- Semantic-Object Data Modeling and Normalization-- SO Diagrams Announcements Semantic Object Model [SOM] Appendix E; Kroenke Normalization (Review Chapter 5 K) Homework #4 Review (NX COBSQL) COBOL with Embedded SQL statements Homework 5 Preview – SOM & Alameda
Background image of page 2
Announcements CLASS #6 -- Announcements, misc. ., etc. Class Announcements CISO meetings BUSI xxx? THURS; 5-6:20 p.m. Cabinets on 3rd Floor BCIS: Name MUST be on Spine/Edge of 3-Ring Notebooks
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Homework #4 SQL/DS Essentials Use SQLCOBOL.SQLCOB as the programming template. Basic Control Break Report REFRESH.DBSINPUT?? EMP, DEPT VIEW (may wish to create your own) STATISTICS?? EXEC SQL. Embedded SQL in COBOL
Background image of page 4
K: Appendix E -- The Semantic Object Model (S-O Model) OBJECTIVES: Define Semantic Objects & TableDesigner™ Define 7 Basic Types Of Semantic Objects Use Semantic Object Diagrams To Build A Data Model (College Example) Compare S-O Model To E-R Model Bottom-up Vs Top-down… Semantic Object Model Vs Object-oriented Programming S-O Model Represents An Alternative View Of The Users' Model [Fig E.1]
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Different Data Models for Database Designs E.1
Background image of page 6
S-O MODEL CHARACTERISTICS S-O Model More Bottom-Up-Oriented than the E-R Model Both Are a Type of "Pseudo-Code“ or "Flowchart" Tool For DB Design David Kroenke primary developer of the SO Model (1994). The Model Is Robust But Lacks Standards. NOT Widely Used Yet in CASE Tools.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
S-O MODEL DEFINITIONS 1. * Semantic Object 2. * Object Identifier (primary key) 3. * Object Properties or Attributes 4. * Semantic Object Links 5. * Formulas
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
S-O MODEL DEFINITIONS * Semantic Objects -- Represented by a Rectangle (See Fig E.2.a) A named collection of Properties that sufficiently describes a distinct entity (Things, Objects (Nouns) Of Importance To The Users' Data Model) E.g., Employee, Customer, Inventory, Order, Etc. Instance Of A Semantic Object (Fig E.3) Employee “Jack Becker” Semantic Object Classes -- Collections Of Same Types Of Objects
Background image of page 10
Object Diagram Fig. E.2
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Figure E.3 Instance of a Semantic Object
Background image of page 12
S-O MODEL DEFINITIONS * Semantic Objects are Distinct Entities -- There are NO “weak” semantic objects! See Fig 3.2: Line_Item would be property of ORDER, not a distinct entity. Semantic Objects are ALWAYS independent !! Names in CAPITAL letters Semantic Objects: Must Exist In The Minds Of The Users-- This is Why They Are Called Semantic Objects
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
S-O MODEL DEFINITIONS Object Identifier: Identifies A Unique Object Instance (Key) May Be a Group or Composite (concatenated) Key (OrderNum, LineNum ), (Cust_Name, Cust_Addr) ID NameMixedCase ID UniqueId when underlined
Background image of page 14
S-O MODEL DEFINITIONS * Properties (Or Attributes)
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 16
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 70

Class07.1_SemanticObjects_Fall2008NEW - BCIS 4620...

This preview shows document pages 1 - 16. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online