SQL project

This project received 9 bids from talented freelancers with an average bid price of $188 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

Project 1

1. Choose 2 enterprises (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: Be concrete in your choices, e.g., Wal-Mart, American Express, GE, Toyota, Uncle Ralph’s Deli & Grill, MTA, Amtrak, York College, New York University, NYC Board of Education, CUNY, University of California, American Museum of Natural History, National Gallery of Japan, Omni Airlines, etc.

3. Design an Entity-Relation (ER) model of a database (DB) that will be useful for each of the chosen enterprises.

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

a. There should be at least 20 - 30 Entities in the ER model for each enterprise dB.

b. There should be at least 20 – 30 (entity-to-entity) Relationships in the ER model, for each enterprise.

c. There should be at least 5 Relationships that have their own attributes

d. Indicate the types of values, and value domains (sets) of entity Attributes

e. Indicate the primary key for each Entity and Relationship

f. Indicate the secondary key(s), if any, for entities and relationships.

g. For each Relationship, indicate the (min, max) multiplicity (adicity), for example, 1-to-1, many-to-1, 1-to-many, many-to-many.

h. In the design report, highlight and discuss any 3-way or N-way (N > 3) Relations that occur in the ER models.

i. The design report should discuss: i) modeling fidelity and faithfulness (realism); ii) avoidance of redundancy; iii) modularity in representation; iv) choosing the right relationships; v) making good choices about what to represent as entities, entity relationships, entity attributes, entity relationship attributes.

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



Date, Revision Number

Problem to Solve

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


Summary & Conclusions

Acknowledgments, (if any)

References, (if any)


Collection of Entities

Attributes associated with each Entity & Domain Values

Relations between (or among) Entities

ER diagrams (Chen diagrams) of the ER model

UML / OO diagrams, charts, maps of the ER model.


Economic and Organizational Sectors


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



Academic, Educational: K-12, College, University

Museum, Zoo, Aquarium



Oil, Petroleum Gas, Energy, Fuels





Construction, Civil Engineering, Capital Works


Aerospace, Aviation


Maritime, Marine, Naval, Submarine

Commerce, Commercial

Stock Exchange

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


Publishing, Media


Utilities, Infrastructure:

Telecommunications, Carrier

Cellular, Wireless, Mobile Service Provider

Data Communications, Internet, Web, Social Networking

Power, Electric




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


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


Illegal enterprises

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online