StudyPath

COM 312 Database Design I

HND1 levelSciences25 topics

COM 312 covers 25 topics. StudyPath paces them into daily study sessions that finish before your exam date, with practice questions and worked answers for each one.

Study COM 312 on StudyPath

Free for every student. No card.

Course outline

The topics this course covers, in teaching order.

  1. Organization information needs
  2. Database concepts
  3. Data models
  4. Data modelling
  5. Relational database design
  6. Structured Query Language (SQL)
  7. Database systems architecture
  8. Organizational information needs
  9. Database concepts and purpose
  10. Data views and data models
  11. Database administrators, users and languages
  12. Hierarchical, network and relational models
  13. Structure data diagrams
  14. E-R modelling
  15. Entity sets, relationships and weak entities
  16. E-R schema design and mapping to tables
  17. Relational database design pitfalls
  18. Decomposition and normalization
  19. Domain-key normal form
  20. Alternative database design approaches
  21. SQL fundamentals and structure
  22. Nested subqueries, views and derived relations
  23. Joins, DDL and embedded SQL
  24. Database system architectures
  25. Centralized, client-server, parallel and distributed systems

A sample from this course

One topic, as StudyPath teaches it.

Organization information needs

Understanding an organisation’s information needs is the first step in database design. It involves identifying the data that support decision‑making, operations and compliance, and determining how that data will be captured, stored and accessed. Mastery of this topic ensures that the database will meet user requirements and provide reliable, timely information for the exam.

What you get for COM 312

Course outlinesBrowse the full catalogue by course code
›
About StudyPathWhat StudyPath is, and what it costs
›
Contact & supportQuestions, problems, anything at all
›