mbi 630 week 9 conceptual data modeling and designing database n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
MBI 630: Week 9 Conceptual Data Modeling and Designing Database PowerPoint Presentation
Download Presentation
MBI 630: Week 9 Conceptual Data Modeling and Designing Database

Loading in 2 Seconds...

play fullscreen
1 / 12

MBI 630: Week 9 Conceptual Data Modeling and Designing Database - PowerPoint PPT Presentation


  • 191 Views
  • Uploaded on

MBI 630: Week 9 Conceptual Data Modeling and Designing Database. 6/7/2014. Week 9: Conceptual Data Modeling and Designing Database. Data Modeling (Logical Design) Designing Database (Physical Design). Overview of Database Design. Capture Users’ “Views” of data Forms, Screens, Reports

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'MBI 630: Week 9 Conceptual Data Modeling and Designing Database' - mea


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
week 9 conceptual data modeling and designing database
Week 9: ConceptualDataModelingandDesigningDatabase
  • Data Modeling (Logical Design)
  • Designing Database (Physical Design)
overview of database design
Overview of Database Design
  • Capture Users’ “Views” of data
    • Forms, Screens, Reports
  • Data Modeling (entity-based ERD)
    • Add keys, attributes, relationships (key-based, and fully-described ERD)
  • Consolidate data models – One big ERD
  • Determine Database Schema
data modeling
Data Modeling
  • Data modeling is a technique for organizing and documenting a system’s DATA. Data modeling is sometimes called database modeling because a data model is usually implemented as a database.
  • Entities
  • Attributes
  • Relationships
  • Cardinality
entity relationship e r diagram
Entity-Relationship (E-R) Diagram
  • Entity-Relationship diagram is graphical representation of E-R model, which is a detailed, logical representation of the entities, associations (relationships), and data elements (attributes) for an organization of business area.
physical database design
(Physical) Database Design
  • Purpose of database design

-- Translate a relational data model into a technical file and database design that balances several performance factors

-- Choose data storage technologies that will efficiently, accurately and securely process database activities

the database schema
The Database Schema
  • Data type. Each DBMS supports different data types, and terms for those data types.
  • Size of the Field. Different DBMSs express precision of real numbers differently.
  • NULL or NOT NULL. Must the field have a value before the record can be committed to storage?
  • Domains. Many DBMSs can automatically edit data to ensure that fields contain legal data.
  • Default. Many DBMSs allow a default value to be automatically set in the event that a user or programmer submits a record without a value.
  • Referential Integrity. An integrity constraint specifying that the value (or existence) of an attribute in one relation depends on the value (or existence) of the same attribute in another relation
other considerations
Other Considerations
  • Denormalization
  • Choices of storage formats
  • File organizations
  • Backup/Recovery
  • Security of Data