Constraints Foreign key: bookID, gameID, and teamID collectively make a unique key. They must all exist in their respective reference relations. Business Rule: if a bet type is spread” this record will be referenced to determine if they have “point won or not. This information will also be displayed to the users. Candidate Keys bookID, gameID, and teamID E-R Database to Relational Database Conversion Users(userID, userName, fullName, Address, emailAddress, password) userID userName fullName Address emailAddress password 1 Nkott0 Kott, 1920 Hugo Nkott0@gmail.com Alfred0 Nicholas St., Bakersfield, CA, 93308 2 SawCat Cat, 1922 Hugo 1e8gn54 Sawyer St., Bakersfield, CA, 93308 3 Mialicious Cat, Mia 2000 Hugo Mialicious@gmail.com Randumb1 St., Bakersfield, CA, 93308
Constraints Foreign key: bookID, gameID, and teamID collectively make a unique key. They must all exist in their respective reference relations. Business Rule: if a bet type is “point spread” this record will be referenced to determine if they have won or not. This information will also be displayed to the users. Candidate Keys bookID, gameID, and teamID E-R Database to Relational Database Conversion Users(userID, userName, fullName, Address, emailAddress, password) userID userName fullName Address emailAddress password 1 Nkott0 Kott, Nicholas 1920 Hugo St., Bakersfield, CA, 93308 Nkott0@gmail.com Alfred0 2 SawCat Cat, Sawyer 1922 Hugo St., Bakersfield, CA, 93308 1e8gn54 3 Mialicious Cat, Mia 2000 Hugo St., Bakersfield, CA, 93308 Mialicious@gmail.com Randumb1
Nick%20Kott%20Phase%20V.docx