======================== Conceptual Questions ======================== 1) A RDBMS is a relational database management system which allows the ability to modify, access and process data stored within a relational database 2) SQL is a Structured Query Language that is used to interact and access a database through commands like Create, Select etc. 3) The ER model is an Entity Relationship model, which is a diagram showing unique entities that would reside within a database and their relationships towards other entities through cardinality. 4) One-to-one: There exist an entity X and entity Y where in their relation there exists only one of each. One-to-many: There exists an entity X and entity Y where in their relation there exists only one of X and more than one Y. Many-to-many: There exists an entity X and entity Y where in their relation there exists more than one of each. 5) A primary key is a unique identifier of a subset of information. It needs to be unique as to refrain from having two of the same keys being used to identify two tables which will cause obvious errors. ======================== SQL Exercises ======================== 6) CREATE TABLE IF NOT EXISTS Customers { id INTEGER NOT NULL AUTO_INCREMENT, fname VARCHAR(30) NOT NULL, lname VARCHAR(30) NOT NULL, address VARCHAR(30) NOT NULL, city VARCHAR(30) NOT NULL, zip UNSIGNED INTEGER(5) NOT NULL, email VARCHAR(30) NOT NULL, PRIMARY KEY(id) };