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 projecta.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