Understanding and Definitions of Database, RDBMS, entity, attributes, tables, rows, columns Understanding and Definitions of Primary...

Transcribed Image Text:

Understanding and Definitions of Database, RDBMS, entity, attributes, tables, rows, columns Understanding and Definitions of Primary key, Foreign Key What is ER Diagram What is CRUD What are the limitations of spreadsheets as compared to database tables How to write SQL code for: CREATE TABLE with PRIMARY KEY DELETE rows DELETE rows with WHERE clause DROP TABLE SELECT (general format) SELECT with a WHERE clause SELECT with aggregate INSERT Understanding and Definitions of Database, RDBMS, entity, attributes, tables, rows, columns Understanding and Definitions of Primary key, Foreign Key What is ER Diagram What is CRUD What are the limitations of spreadsheets as compared to database tables How to write SQL code for: CREATE TABLE with PRIMARY KEY DELETE rows DELETE rows with WHERE clause DROP TABLE SELECT (general format) SELECT with a WHERE clause SELECT with aggregate INSERT

Answer rating: 100% (QA)

Question 1 definitions of the terms RDBMS Relational Database Management System A type of database that stores data in related tables Entity A realworld object or concept that is stored in a database ... View the full answer