Please enable JavaScript.
Coggle requires JavaScript to display documents.
Mid-Term - Coggle Diagram
Mid-Term
Data & Categories of Data
Information & Information Management
-
Uses of database systems & Database Management System (DBMS)
-
ERD - supertype/subtype relationships
ERD - GENERALIZATION AND SPECIALIZATION
-
ERD - Entities, relationships, attributes and cardinalities
Unary, binary, and ternary relationships
MULTI-VALUED AND DERIVED ATTRIBUTES
-
tables with the entity and relational integrity constraints
-
FUNCTIONAL DEPENDENCIES AND KEYS
Normalization and Denormalization
Full & Partial functional dependencies
SQL Server database file types
SQL Language Statement - DDL Create, Alter, Drop
SQL Language Statement DML – Select, Insert, Update & Delete
SQL Server Joins (Use Northwind database to practice)
Keys: primary key, candidate key, foreign key
Client-Server Architecture – Server & Client Software
Database files, file groups, pages & extents
SQL Tables - heap & cluster tables
-