IS3280 Data Management Assignment: 1. Convert the ER Diagram below to a list of tables. The first step will be to identify Mapping ER Diagrams to Tables cardinalty/optionality. Be sure to identify primary leeys and foreign keys. Name: submit vio 021 . You may create your tables using the Table feature in Word or you may use visio, Lucidcharts, etc. [Word is probably the easiest urless you are proficient in Visio]. The Table should be arie colurnn with the number of rows equaling the number of attributes. Underline primary keve and italicize foveign keys. Use only the hnx horder. The TABI F_NAMF should he in AlI CAPS. In the examples below, I put the table raame above the rectarigle but mest drawirlg prograrrs put it in the top row. You mav put it where ever is casiest - but do make the table name all CAPS. What is the cardinality/optionality of this ER diagram? Example table formats: Place your tables below. Ttne aoove table nas a single attribute as a primary key 2. Convert the ER Diagram below to a list of tables. The first step will be to identify cardinalty/optionality. Be sure to identify primary leeys and foreign keys. "the abcove table has two attrituutes that make up a composite primary key What is the cardinality/optionality of this ER diagram? I Place your tables below. "the above table has two attributes that make up a composite primary key and are also foreign keys -the point here to remember is that a primary key may also be a foreign key 1lee these eumhnle th ifmntifu rardinalitur and nntinnalitu- 3. Convert the ER Diagram below to a list of tables. The first step will be to identify 5. Convert the ER Dlagram below to a list of tables. The first step will be to identify cardinalty/optionality. Be sure to identify primary keys and foreign keys. \{Be careful here - note cardinalty/optionality. Be sure to identify primary keys and foreign keys. the composite primary key\} What is the cardinality/optionality of this ER diagram? What is the cardinality/optionality of this ER diagram? I Place your tables below. Place your tables below. 6. Map the following specialization hierarchy [super-type, sub-type relationship] to tables. Be sure to identify primary keys and foreign keys. 4. Convert the ER Diagram below to a list of tables. The first step will be to identify Note: this model contains disjoint subtypes [denoted by the 1(d) symbol - in other vords, a cardinalty/optionality. Be sure to identify primary keys and forelgn keys. device can be either a Desktop or Mabile device, but not both. The designation of disjoint on overlapping is considered a constraint/business rule - however, the designation DOES NOT impact how you map to tables. It should also be noted that many dravirig programs including visio, do not include symbols for this constraint.\} What is the cardinality/optionality of this ER diagram? What is the cardinality/optionality of this ER dlagram? / f Place your tables below. Place your tables below