Phu Xuan University Library
|
PXU E-LIB
Sign in
Database Design - NOT GOOD

External

Database Design - NOT GOOD

Engineering
Publisher
LibreTexts
Source
LibreTexts
Language
EN
Category
Information Technology
Read online Download PDF (open licence)
Contents· 65 sections
  1. 01: Chapter 1 - Before the Advent of Database Systems
  2. 1.1: File-based System
  3. 1.2: Database Approach
  4. 02: Chapter 2 - Fundamental Concepts
  5. 2.1: What Is a Database?
  6. 03: Chapter 3 - Characteristics and Benefits of a Database
  7. 3.1: Good Things from Database
  8. 04: Chapter 4 - Types of Data Models
  9. 4.1: What is a Database Model
  10. 05: Chapter 5 - Data Modelling
  11. 5.1: Data Abstraction
  12. 5.2: Data Abstraction Layer
  13. 5.3: Schemas
  14. 06: Chapter 6 - Classification of Database Management Systems
  15. 6.1: Database Classification Types
  16. 07: Chapter 7 - The Relational Data Model
  17. 7.1: Relational Model Explained
  18. 08: Chapter 8 - The Entity Relationship Data Model
  19. 8.1: Entities
  20. 8.2: Attributes
  21. 8.3: Keys
  22. 8.4: Nulls
  23. 8.5: Relationships
  24. 09: Chapter 9 - Integrity Rules and Constraints
  25. 9.1: Constraints and Intergrity
  26. 9.2: Business Rules
  27. 9.3: Relationship Types
  28. Chapter 10 - ER Modelling
  29. 10.1: Relationships
  30. Chapter 11 - Functional Dependencies
  31. 11.1: Dependency Concepts
  32. Chapter 12 - Normalization
  33. 12.1: Normal Form
  34. 12.2: First - Second - Third Normal Form
  35. 12.3: Boyce-Codd Normal Form
  36. 12.4: Normalization and Database Design
  37. Chapter 13 - Database Development Process
  38. 13.1: Software Development Life Cycle – Waterfall
  39. 13.2: Database Development Life Cycle
  40. Chapter 14 - Database Users
  41. 14.1: Who are the Users?
  42. Chapter 15 - SQL Structured Query Language
  43. 15.1: What is SQL
  44. 15.2: CREATE a Database
  45. 15.3: Optional Column Constraints
  46. 15.4: Table Constraints
  47. 15.5: Few Final Tidbits
  48. Chapter 16 - SQL Data Manipulation Language
  49. 16.1: Introduction
  50. 16.2: SELECT Statement
  51. 16.2.1: SELECT with WHERE criteria
  52. 16.2.2: Wildcard in LIKE clause
  53. 16.2.3: SELECT statement with ORDER BY clause
  54. 16.2.4: SELECT statement with GROUP BY clause
  55. 16.2.5: Restricting rows with HAVING
  56. 16.3: INSERT statement
  57. 16.3..1: Specific INSERT Examples
  58. 16.4: UPDATE statement
  59. 16.5: DELETE Statement
  60. 16.6: Built-in Functions
  61. 16.6.1: Aggregate functions
  62. 16.6.2: Conversion function
  63. 16.6.3: Date function
  64. 16.6.4: Mathematical Functions
  65. 16.6.5: Joining Tables