İptal Edildi

SQL project

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:

Title

Author

Date, Revision Number

Problem to Solve

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

Discussion

Summary & Conclusions

Acknowledgments, (if any)

References, (if any)

Appendix:

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.

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

Beceriler: MySQL

Daha fazlasını görün: wireless web station, wireless service provider, what's new in manufacturing, web repair services, web design supermarket, web design for transportation, web design for japan, web design er, university of mobile, uml model types, uml for sql, uml data types, types of social media, types of internet businesses, toyota of york, the new e commerce companies, the gallery collection, the department of energy, supermarket services web design, submarine design, sports gallery web, s&c electric, s.c. department of education, reporting services sql, repair clinic

İşveren Hakkında:
( 4 değerlendirme ) Queens village, United States

Proje NO: #4461081

9 freelancer bu iş için ortalamada 188$ teklif veriyor

eperfections

SQL Expert ! Ready to do the task

in 5 gün içinde257$ USD
(63 Değerlendirme)
6.1
Alinlish

I can finish the project in the shortest time and with high quality.

in 5 gün içinde132$ USD
(1 Değerlendirme)
2.1
riskypathak

Well its a quite large assignment thats why placing a bid of 1902 dollar. Now coming to eligibility for this kind of work. Yes i am eligible. I have good expertise in UMLs, database design, analysis and other related c Daha fazlası

in 10 gün içinde220$ USD
(3 Değerlendirme)
2.0
PerfectSquare

Hi I am interested and I have experience in building the ERD in MS VISIO or any other software like ER WIN etc. I can create the ERD from any case study with normalization, Let start now Thanks

in 3 gün içinde110$ USD
(1 Değerlendirme)
1.2
oplalchandani

I have done similar projects recently

in 3 gün içinde264$ USD
(0 Değerlendirme)
0.0
manjukotla

Hi I would like to design specified database for you. I had done similar type of projects.

in 3 gün içinde165$ USD
(0 Değerlendirme)
1.5
sunsriinfosys

Hi, I have over 13 years of Experience in software design, development and implementation of various commercial applications in Client/Server environment, Web and ERP applications using C# 1.1/2.0/3.5, ASP.Net, VB.N Daha fazlası

in 3 gün içinde249$ USD
(2 Değerlendirme)
1.4
nasim31

Hi, I'm ready to take up your project. Kindly check PMB for more details. Awaiting your kind response. Thank you Nasim

in 5 gün içinde188$ USD
(0 Değerlendirme)
0.0
arvindkumar01

i will give ths best

in 0 gün içinde110$ USD
(0 Değerlendirme)
0.0