2023 Project 2 1 Choose2enterprises businesses corporations companies institutions from one or more economic organizational institutional or industrial | Assignment Collections

Project 2

1.Choose2enterprises(businesses, corporations, companies, institutions) from one or more economic, organizational, institutional or industrial sector of interest to you. See the Appendix for suggestions and examples.

2.Suggestion: Beconcretein your choices, e.g., Wal-Mart, American Express, GE,Toyota, Uncle Ralph’s Deli & Grill, MTA, Amtrak,York College,New YorkUniversity, NYC Board of Education, CUNY,UniversityofCalifornia,AmericanMuseumof Natural History, National Gallery of Japan, Omni Airlines, etc.

3.Design anRelational Model(RM) model of a database (DB) that will be useful for each of the chosen enterprises. (Hint: You may choose to translate the 2 ER model designs you created in Project 1).

4.The following aspects are required and should be captured in the project

a.There should be at least20 – 30 relational schemascoveringEntitiesin theassociated ERdesign for each enterprise dB.b.There should be at least20 – 30 relational schemascovering (entity-to-entity)Relationshipsin theassociated ERdesign, for each enterprise.c.Implement the 2 enterprise relational DBs using eitherMySQLorSQLited.Populate the two DB with relational tables for all the relational schemas involved, with each table having at least5 – 10entries (tuples, records).

5.Document and present your design as a report in the following form:

Title

Author

Date, Revision Number

Problem to Solve

Design (RM) model. (Provide details in an Appendix)

Discussion

Summary & Conclusions

Acknowledgments, (if any)

References, (if any)

Appendix:

Relational Schemas

Relational Tables

SQL scripts showing the Creation and Population (Loading) of the DBs.

Simple SQL queries, providing simple tests on the DBs.

ER diagrams (Chen diagrams) of the ER model, (reference or include your work for Project 1 here)

UML / OO diagrams, charts, maps of the ER model, (reference or include your work for Project 1 here).

A “data dictionary” (a kind of glossary) explaining terms and concepts that make it easy to understand your design and implementation

Appendix

Economic and Organizational Sectors

Institutional:

Government: Federal, National, Country, State, Province, Local, District, Municipal, City: Department, Services. For example: Homeland security, Law Enforcement, Immigration, Taxes, Health Benefits, Housing, Military & Defense

Prison

Library

Academic, Educational: K-12, College, University

Museum, Zoo, Aquarium

Industrial:

Manufacturing

Oil, Petroleum Gas, Energy, Fuels

Agro-Biz

Pharmaceuticals

Mining

Forestry

Construction, Civil Engineering, Capital Works

Technology

Aerospace, Aviation

Aeronautics

Maritime, Marine, Naval, Submarine

Commerce, Commercial

Stock Exchange

Retail Store, Grocery Chain, Supermarket, Department store, Deli, Bodega

Mall

Publishing, Media

Entertainment

Utilities, Infrastructure:

Telecommunications, Carrier

Cellular, Wireless, Mobile Service Provider

Data Communications, Internet, Web, Social Networking

Power, Electric

Water

Sewage

Services:

Banking, Investment Bank

Credit Card

Credit Card Reporting

Healthcare, Medical care: hospital, hospice, clinic, medical office or practice, vet practice

Real estate

Transportation, Logistics, Freight, Reverse Logistics

Warehouse

Rail, Ferry, Bus, Airline

Cruise, Shipping

Export and Import

Gas Station, Automobile Repair

Hotel, Lodging, Accommodation, Hospitality

Entertainment, Leisure, Recreation, Sports,

Movie, Theater, Dramatic arts

Gambling

Illegal enterprises

2013. Project 2: Spring 2013. CS 292.YorkCollege, CUNY Prof. Amenyo1/4