Relational Database, RDBMS, table, row, column, cell, primary key, unique key, foreign key, composite primary key, Relationship and types of relationships.
2.)
- Using the data in the Cake Order Database excel file, decide what tables of data could be created, and what fields would be included in the tables (you can add new fields in each table as required or useful for the table).
- Identify what field would serve as the primary key for the tables and what field could be used as unique key.
- Create an entity relationship diagram showing the tables (with fields) and relationships among the tables.
- What other data could be included in this database? What benefits are there from organizing the data this way as opposed to in an Excel file. Important Instruction
- (Please write all your answers in a word document. Also mention the resources used to complete the assignment.)
- Kindly check against plagiarism and avoid the use of AI because my school checks for it.
