Steven “John” Worthing
Assignment 4

4.1 Restriction are considered relation because each row need one

4.2 relations is 2 dimensional table Tuple are rows Attributes are column File is data Record is data in a table Table is a group of data Rows is a line of data Column is a a line of data but going up/down

4.3 functional dependencies is a relationship between/or among attribute Class - student
Student dorm
Student email
Student loans
4.4 no, because there can be many functional ids
4.5 determinants are the left side of the arrow
4.7 keys is a group of one or more attributes that are uniquely identifies a row 4.8 yes and yes
4.9 Deletion anomaly is a removal of a row of data but it also removes every relationship with that row. Ex: a removal of a computer in an inventory with everything to do with that computer
4.10 Insertion anomaly is adding an entry in a database but can because it hast. Ex: adding a computer to a computer inventory but cant
4.11

4.12 second normal form is the second step in normalization in a database.
4.13 third normalization form is the 3rd step in normalizing a database
4.14 BCNF is a form of database normalization
4.15 multi-value dependency occurs when the presence of one or more rows in a table implies the presence of one or more other rows in the same tables. Ex: Car Company that manufacture many models of cars, but always make both red and blue colors of each models.
4.16
4.17 Forth-normal form is a level of database normalization where there is no non-trivial decency other than a candidate key
4.18 Domain/key normal form is a normal form used in a database normalization that requires that the database contains no constraints other domain constraints and key constraints
4.19
4.22