restName Pok Pok Kiin Thai Carbone Il Mulino Don Peppe Loukoumi Taverna Nisi Ela Taverna cuisine...

 

Transcribed Image Text:

restName Pok Pok Kiin Thai Carbone Il Mulino Don Peppe Loukoumi Taverna Nisi Ela Taverna cuisine borough Thai Thai Italian Italian Italian Brooklyn Manhattan Manhattan Manhattan Queens Queens Manhattan Greek Greek Greek Brooklyn yearEst avgPrice starRating ratingDate comments Good food, bad 2005 100 2013 75 2010 150 1999 1998 250 75 1994 2014 130 100 2015 150 Attribute Name Entity Name CUSTOMER CustomerNumbeINT 2 11/13/14 service 2 2/1/15 Disappointed 3 6/30/03 Overpriced Data Format and length Description A surrogate key for the CUSTOMER table firstN 1) Create a UML E-R diagram that includes the entities, attributes, and relationships. 2) Create a data dictionary for each table. Specify the table constraints, the attributes per table, the data type of each attribute, description for each attribute, and add any column constraints for the attributes. You can use the following example as a template to build your data dictionary: CUSTOMER Customer VARCHAR(255) CUSTOMER Phone Sarah 5 12/21/01 Loved everything Elizabeth Thomas Chronicle 7/2/16 Great food, rude staff Elizabeth Thomas Chronicle Must try fish Chris Jackson NYT 3 5 VARCHAR(12) The ten-digit North American lastN affiliation Brittany Harris Vogue Ashley While NYT Martinez NYT phone number in the format nnn.nnn.nnnn Default Input Mask Required? Value YES DBMS No supplied Remarkable Constraints PRIMARY KEY, AUTO_INCREMENT restName Pok Pok Kiin Thai Carbone Il Mulino Don Peppe Loukoumi Taverna Nisi Ela Taverna cuisine borough Thai Thai Italian Italian Italian Brooklyn Manhattan Manhattan Manhattan Queens Queens Manhattan Greek Greek Greek Brooklyn yearEst avgPrice star Rating ratingDate comments Good food, bad 2005 100 2013 75 2010 150 1999 1998 250 75 1994 2014 130 100 2015 150 Attribute Name Entity Name CUSTOMER CustomerNumbeINT 2 11/13/14 service 2 2/1/15 Disappointed 3 6/30/03 Overpriced Data Format and length Description A surrogate key for the CUSTOMER table firstN 1) Create a UML E-R diagram that includes the entities, attributes, and relationships. 2) Create a data dictionary for each table. Specify the table constraints, the attributes per table, the data type of each attribute, description for each attribute, and add any column constraints for the attributes. You can use the following example as a template to build your data dictionary: CUSTOMER Customer VARCHAR(255) CUSTOMER Phone Sarah 5 12/21/01 Loved everything Elizabeth Thomas Chronicle 7/2/16 Great food, rude staff Elizabeth Thomas Chronicle Must try fish Chris Jackson NYT 3 5 VARCHAR (12) The ten-digit North American lastN affiliation Brittany Harris Vogue Ashley While NYT Martinez NYT phone number in the format nnn.nnn.nnnn Default Input Mask Required? Value YES DBMS No supplied Remarkable Constraints PRIMARY KEY, AUTO INCREMENT restName Pok Pok Kiin Thai Carbone Il Mulino Don Peppe Loukoumi Taverna Nisi Ela Taverna cuisine borough Thai Thai Italian Italian Italian Brooklyn Manhattan Manhattan Manhattan Queens Queens Manhattan Greek Greek Greek Brooklyn yearEst avgPrice starRating ratingDate comments Good food, bad 2005 100 2013 75 2010 150 1999 1998 250 75 1994 2014 130 100 2015 150 Attribute Name Entity Name CUSTOMER CustomerNumbeINT 2 11/13/14 service 2 2/1/15 Disappointed 3 6/30/03 Overpriced Data Format and length Description A surrogate key for the CUSTOMER table firstN 1) Create a UML E-R diagram that includes the entities, attributes, and relationships. 2) Create a data dictionary for each table. Specify the table constraints, the attributes per table, the data type of each attribute, description for each attribute, and add any column constraints for the attributes. You can use the following example as a template to build your data dictionary: CUSTOMER Customer VARCHAR(255) CUSTOMER Phone Sarah 5 12/21/01 Loved everything Elizabeth Thomas Chronicle 7/2/16 Great food, rude staff Elizabeth Thomas Chronicle Must try fish Chris Jackson NYT 3 5 VARCHAR(12) The ten-digit North American lastN affiliation Brittany Harris Vogue Ashley While NYT Martinez NYT phone number in the format nnn.nnn.nnnn Default Input Mask Required? Value YES DBMS No supplied Remarkable Constraints PRIMARY KEY, AUTO_INCREMENT restName Pok Pok Kiin Thai Carbone Il Mulino Don Peppe Loukoumi Taverna Nisi Ela Taverna cuisine borough Thai Thai Italian Italian Italian Brooklyn Manhattan Manhattan Manhattan Queens Queens Manhattan Greek Greek Greek Brooklyn yearEst avgPrice star Rating ratingDate comments Good food, bad 2005 100 2013 75 2010 150 1999 1998 250 75 1994 2014 130 100 2015 150 Attribute Name Entity Name CUSTOMER CustomerNumbeINT 2 11/13/14 service 2 2/1/15 Disappointed 3 6/30/03 Overpriced Data Format and length Description A surrogate key for the CUSTOMER table firstN 1) Create a UML E-R diagram that includes the entities, attributes, and relationships. 2) Create a data dictionary for each table. Specify the table constraints, the attributes per table, the data type of each attribute, description for each attribute, and add any column constraints for the attributes. You can use the following example as a template to build your data dictionary: CUSTOMER Customer VARCHAR(255) CUSTOMER Phone Sarah 5 12/21/01 Loved everything Elizabeth Thomas Chronicle 7/2/16 Great food, rude staff Elizabeth Thomas Chronicle Must try fish Chris Jackson NYT 3 5 VARCHAR (12) The ten-digit North American lastN affiliation Brittany Harris Vogue Ashley While NYT Martinez NYT phone number in the format nnn.nnn.nnnn Default Input Mask Required? Value YES DBMS No supplied Remarkable Constraints PRIMARY KEY, AUTO INCREMENT

Answer rating: 100% (QA)

Im sorry but Im unable to create images such as UML Unified Modeling Language EntityRelationship ER ... View the full answer