1. RDBMS is a database management system based on the relational model. A relational database is a type of database structure that maintain the relationship between entities.

2. A database schema refers to the structure in which the database presented. It logically groups objects and can be thought of as a container for those objects.

3. ER Model refers to the entity-relationship model which is a graphical approach of the design of the database. It represents the layout of the database, the schema, its entities or tables, and the entities relationships.

4. A one-to-one relationship means that a record from table A is associated with only one record in table B. For example, each student is only assigned a single student ID.

5. A one-to-many relationship means that a record from table A is associated with one or more records in table B. For example, a customer can have many orders.

6. A many-to-many relationship means that multiple records from table A are associated with multiple records in table B. For example, customers and products; a single product can be purchased by many customers and a single customer can purchase various products.

7. Tuples are often thought of rows in a table within a database. Some argue tuples are not rows because rows are ordered sets of values while tuples don't carry the same definition being unordered sets.

8. Primary keys are useful to uniquely identify records in a table. This is useful to find all information related to the primary key.

9. A primary key should always be unique because its purpose is to uniquely identify records. It'd be useless when searching for certain information and getting results for unrelated information.

10. SQL is a Structured Query Language and is the standard language for accessing and managing databases.

11. 
	CREATE TABLE Customers (
		c_id INT NOT NULL AUTO_INCREMENT,
		c_firstName VARCHAR(50),
		c_lastName VARCHAR(50),
		c_address VARCHAR(50),
		c_city VARCHAR(50),
		c_state VARCHAR(30),
		c_zip VARCHAR(30),
		c_email VARCHAR(50),
		PRIMARY KEY(c_id)
	);

12. 
	ALTER TABLE Customers
	ADD age TINYINT UNSIGNED;

13. 
	CREATE TABLE Products (
		p_id INT NOT NULL AUTO_INCREMENT,
		p_title VARCHAR(50),
		p_description VARCHAR(500),
		p_price DECIMAL(13,4),
		PRIMARY KEY(p_id)
	);

14. 
	INSERT INTO Customers
	VALUES (NULL, 'Reilly', 'Mackenzie', '66 Addison Street', 'Saint Joseph', 'Michigan', '49085', 'rMack@gmail.com', 21);

	INSERT INTO Customers
	VALUES (NULL, 'Alex', 'Wilson', '249 East High Noon Road', 'Havertown', 'Pennsylvania', '19083', 'lWilson@hotmail.com', 29);

	INSERT INTO Customers
	VALUES (NULL, 'Alyssa', 'Williams', '7480 Queen Ave', 'Santa Clara', 'California', '95050', 'aWilliams@gmail.com', 26);

15. 
	INSERT INTO Products
	VALUES (NULL, 'DJI Spark Drone Quadcopter Elite Bundle', 'Meet Spark, a mini drone that features all of DJI's signature technologies, allowing you to seize the moment whenever you feel inspired. With intelligent flight control options, a mechanical gimbal, and a camera with incredible image quality, Spark empowers you to push your creative boundaries.', 629.99);

	INSERT INTO Products
	VALUES (NULL, 'Ibanez S Series Iron Label SIX6FDFM', 'The guitar's S-series body is incredibly thin and contoured for unparalleled comfort. The Nitro Wizard neck profile welcomes your fastest performances. A pair of DiMarzio Fusion Edge humbucking pickups are engineered to bring out the most power, clarity, and note velocity as possible from the SIX6FDFM. And you receive rock-solid tuning stability due to the SIX6FDFM's Gibraltar Standard II fixed bridge and locking tuners.', 899.99);

	INSERT INTO Products
	VALUES (NULL, 'Nintendo Switch', 'Introducing Nintendo Switch, the new home video game system from Nintendo. In addition to providing single and multiplayer thrills at home, the Nintendo Switch system can be taken on the go so players can enjoy a full home console experience anytime, anywhere. The mobility of a handheld is now added to the power of a home gaming system, with unprecedented new play styles brought to life by the two new Joy-Con controllers.', 297.99);

16. 
	CREATE TABLE Orders (
		o_id INT NOT NULL AUTO_INCREMENT,
		o_cid INT,
		o_amount DECIMAL(13,4),
		o_date DATETIME,
		PRIMARY KEY(o_id),
		FOREIGN KEY (o_cid) REFERENCES Customers(o_cid)
	);

17.
	INSERT INTO Orders
	VALUES (NULL, 1, 297.99, GETDATE());

	INSERT INTO Orders
	VALUES (NULL, 2, 899.99, GETDATE());

	INSERT INTO Orders
	VALUES (NULL, 3, 629.99, GETDATE());

18. SELECT * FROM Customers;

19. SELECT * FROM Products;

20.
	UPDATE Products
	SET p_price = 49.99
	WHERE p_id = 3;

21.
	SELECT *
	FROM Products
	WHERE p_price < 100.00;

22.
	SELECT *
	FROM Orders
	WHERE o_cid = 1;

23. SELECT *
	FROM Orders
	WHERE o_amount > 100.00;

24.
	DELETE FROM Products
	WHERE p_id in (SELECT TOP 1 p_id FROM Products ORDER BY p_id DESC);

25. DROP TABLE DropThisTable_GoneForever;