Database concepts

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.