sid7AHgh

1Name: Charles Stevens
2Class: BCIS-18
3Date: 2-11-19
4
5Questions
61.	Multiple people can’t pay for the same movie with credit cards, Video rentals have to be back by specified date, employees have to leave by a certain time.
72.	Relational, Object-oriented, and the nosql ways are relationships that data in databases have with other people/computers things in existence. A relationship in this context is the same definition as in real life.
83.	Desc below:
9a.	Customers have multiple movies, each movie has only one customer
10b.	A Video Store has many movies, each movie has only one Video Store
11c.	Actors have multiple movies, each movie has multiple actors
12d.	Movies have multiple genres, each genre applies to multiple movies
13e.	Each Video Store has many Employees, each Employee has one Video Store
14f.	A Rental Account has multiple Customers, a Customer may have many Rental Accounts, but probably not.
154.	The parable of the blind men and elephant means that things have many properties.
165.	It’s called CRUD which stands for Create Read Update Delete
176.	Disadvantages of DBMSs is that they weigh a lot, they’re highly complex and it’s hard to do operations on them.
187.	Dictionary storage, Data storage, Multi-user access control, Security BLA BLA BLA
198.	CREATE TABLE IF NOT EXISTS persons (pid INT AUTO_INCREMENT UNIQUE PRIMARY KEY, name_l VARCHAR(35), name_f VARCHAR(35), address VARCHAR(35), city VARCHAR(20), state CHAR(2), zip CHAR(5));
209.	ALTER TABLE persons 
2110.	A
2211.	A
2312.	A
2413.	A
2514.	A
2615.	A
2716.	A