Please enable JavaScript.
Coggle requires JavaScript to display documents.
Unit 18 Assignment 1 Sharebook Safari Park Relational Database…
Unit 18 Assignment 1 Sharebook Safari Park Relational Database investigation
Role of relational data structures
Relation
Attribute
Domain
Tuple
degree
cardinality
relational database
relational algebra sets, symbols
entity relationships models
One to Many
Many to Many
One to One
Data manipulation
retrieval of data for queries and reports
administration of users
updating, inserting, modifying and deletion
security, integrity and recovery.
The importance of normalisation
Referral integrity
Data dictionary
Indexing
Cascading update
Keys
Foreign
Composite
Primary
Joins, Unions, and intersects
Anomalies
Insertion
Delete
Update
Normalisation stages
first normal form (1NF)
second normal form (2NF)
un-normalised form (UNF)
third normal form (3NF)
Boyce-Codd normal form (BCNF).
Sources of information/References
https://docs.microsoft.com/en-US/office/troubleshoot/access/database-normalization-description
https://www.1keydata.com/datawarehousing/data-modeling-levels.html
http://www.computerweekly.com/feature/Choosing-the-right-database-management-system