ISTE-230 Introduction to Database & Data Modeling Practice Exercise # 9 – Transposing

Document Content and Description Below

ISTE-230 Introduction to Database & Data Modeling Practice Exercise # 9 – Transposing Name: ________KEY_____________________________________ All assignments will be graded with regard to the stan... dards that were discussed in class, which can be found in the Standards Content area. Be sure to use proper relational notation: RELATION(pkattr, attribute, fkattr). Include reference statements for foreign keys. Problem #1 Transpose the E-R diagram below into relations, implementing all relationships. Denote primary keys and foreign keys appropriately. Use proper relation notation. Make sure your relation names are in all caps. YOUR TRANSPOSED RELATIONS: CITY(cityID, name, district, population, code) CITY(code) mei COUNTRY(code) COUNTRY(code, name, region, surfaceArea, indepYear, population, lifeExpectancy, gnp, gnpOld, localName, governmentForm, headOfState, capital, code2, continentID) COUNTRY(continentID) mei CONTINENT(continentID) LANGUAGE(langCode, language) COUNTRY_LANGUAGE(code, langCode) COUNTRY_LANGUAGE(code) mei COUNTRY(code) COUNTRY_LANGUAGE(langCode) mei LANGUAGE(langCode) CONTINENT(continentID, name) PAGE 2 OF 4 Problem #2 Transpose the E-R diagram below into relations, implementing all relationships. Denote pr [Show More]

Last updated: 1 year ago

Preview 1 out of 5 pages