1 / 73

Database Design and Programming (part 2)

Learn about database transactions, ACID test, SQL, CRUD operations, and ER modeling. Understand cardinality's role in database transactions and normalization principles.

linus
Télécharger la présentation

Database Design and Programming (part 2)

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Design and Programming (part 2) Relational Databases Fall 2013 MKTG 455

  2. Lecture overview • Transactions • ACID test • Intro to SQL • CRUD • ER Modeling • Normalization

  3. Name two forms of cardinality

  4. What does cardinality have to do with?

  5. transactions in the database

  6. ACID TEST A CID

  7. ACID TEST Atomic Consistent Isolated Durable

  8. ACID TEST Atomic (all or nothing) Consistent Isolated Durable

  9. ACID TEST Atomic (all or nothing) Consistent (follows all other rules) Isolated Durable

  10. ACID TEST Atomic (all or nothing) Consistent (follows all other rules) Isolated (locked data) Durable

  11. ACID TEST Atomic (all or nothing) Consistent (follows all other rules) Isolated (locked data) Durable (guaranteed)

  12. introduction to SQL Structured Query Language

  13. Database vs. DBMS Database Management Systems Oracle SQL Server MySQL Postgre SQL MS Access DB2

  14. declarative language “I want all the books more than $40”

  15. declarative language “I want all the books more than $40”

  16. CRUD

  17. database schema

  18. 2 questions • What’s the point

  19. 2 questions • What’s the point

  20. 2 questions • What’s the point • What do you already have?

  21. 2 questions • What’s the point • What do you already have?

  22. issue singular or plural

  23. ER Models Entity Relationship Modeling

  24. Choose a naming convention Camel Case lastName Pascal LastName Underscore last_name

  25. Data types

  26. normalization

  27. normal forms

  28. first normal form “Each of your columns in each of your tables should contain one value (and only one value) and have no repeating groups”

More Related