Please answer the questions attached. Below i have provided some reading that may assist.
- Watt, A., & Eng, N. (n.d.). Chapter 2, Fundamental concepts. In Database Design – 2nd edition. British Columbia: Open Text Book Project.
- Courtney, J. F., Paradice, D. B., Brewer, K. L., & Graham, J. C. (2010). Chapter 1: Introduction to database systems. In Database Systems for Management.
- Russell, G. (n.d.) Introduction to database resources.
(Note: The “key” is in the Database Architecture section.) - Wang, W. (2017). Flaws in flat file system data management
- Wang, W. (2017). Major components of a relational database
Note: Defines terms used in working with database design and implementation - Data types of the attributes: https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT012
- Wang, W. (2017). Entity and Referential Integrity
(Note: Covers rules of effective database design to prevent problems that often occur when using flat files.) - Russell, G. (n.d.). Relational algebra
- Russell, G. (n.d.). Relational algebra: Example
- Relational algebra and SQL DDL statements
- Wang, W. (2020). Add Primary Key and Foreign Key to Tables.
Note: This is a large file and may take several seconds to open.