Data base ER diagram

終了済み 投稿 Mar 11, 2016 着払い
終了済み 着払い

Pick a context by yourself, e.g. a pet store, an animal hospital, consulting firm, etc and familiarize yourself with its business operation. You are to develop a database for it. This first part of the project is on database analysis/modeling and you are expected to work on the design and implementation of the same database in the second and third part of the project.

In this database analysis/modeling project, your task is to develop a conceptual data model for the context you have picked and represent this model using an ERD. You should keep the following requirements in mind when selecting your context. In order to show you are capable of applying your database analysis knowledge, your conceptual data model should meet the following requirements:

1. It should have at least eight entities (including associative entity).

2. Use associative entity wherever appropriate. It should have at least one associative entity.

3. It should have at least one unary relationship and at least one binary relationship.

4. The relationships should show different types of cardinalities wherever appropriate (optional one, optional many, mandatory one, mandatory many).

5. Each entity type should have a set of attributes. Your ERD should have at least one special type of attribute, such as composite attribute, multi-valued attribute, etc.

6. Designate a key attribute for each strong entity type.

Deliverables:

1. ERD drawn using (e.g. Microsoft Visio).

2. Describe in English

a. the context (e.g. what type of company and who in the company will use your database, what business processes your database can support; make sure your model makes reasonable business sense);

b. the business rules represented by the ERD;

c. how your ERD meets the above requirements, e.g. which entities are associative entities; which attribute is a special type of attribute and the specific type; if your ERD contains a ternary relationship, please indicate so and where. (in Microsoft Word).

データベース管理

プロジェクトID: #9918971

プロジェクトについて

19個の提案 リモートプロジェクト アクティブ 7年前

19人のフリーランサーが、平均$141 で、この仕事に入札しています。

ygenchik

I teach databases I am top 2% in DB design according to BrainBench I have Masters Degree I work with sql server for 20+ years, ever since 4.2 It appears to be a bit too little - 8 entities, we prob can do more. もっと

$277 USD 2日以内
(4件のレビュー)
4.9
AwaisChaudhry

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I would call myself a master of what I do, I do work smart and do not rest until I get the job done. Please feel free to pin もっと

$150 USD 3日以内
(2件のレビュー)
4.5
vinaysinghh

I am oracle dba having more then 6 yrs of experience

$222 USD 7日以内
(32件のレビュー)
4.8
point5nyble

Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in もっと

$166 USD 3日以内
(21件のレビュー)
4.4
mdakteruzzaman

Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here もっと

$111 USD 3日以内
(12件のレビュー)
4.5
rashmisingh2990

I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.

$55 USD 1日以内
(9件のレビュー)
3.4
rafaelnadal

Hello I am Software Engineer and expert in Database so you can consider me for this Project Thanks

$100 USD 3日以内
(2件のレビュー)
3.2
CHREHAN

I have almost 3 years of experience in Database Development, Database Optimizations, Database Design Currently at work responsible for implementing complex business of this client at database side from data Design もっと

$84 USD 3日以内
(4件のレビュー)
2.0
boscha

Hi. I am professional database developer with 5 years of project experience. I've completed a lot of similar projects, please check my profile for more info. If you are interested to share more, feel free to contact. T もっと

$88 USD 2日以内
(2件のレビュー)
2.0
saimyousaf

I'm CS Graduate. I'have quite great skills in database. I have Studied many courses including Data Structures, Algorithms, Database system, Advanced Database, Data WareHousing, Data Mining, Software Engineering and Sof もっと

$100 USD 3日以内
(2件のレビュー)
1.4
ashupathania

I have 4 + years of experience in MSBI Technology (SQl Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Expert in creating Sql queries ,Dynam もっと

$150 USD 3日以内
(2件のレビュー)
2.5
ENRICOJ

hi. i would be happy to assist as i am well qualified in database design. ====================================================================== ================================================================== もっと

$50 USD 3日以内
(2件のレビュー)
1.1
mannykk

I am a professional db architect with 15+ year exp. will design using sql developer which is a free tool. visio is expensive. Plz let me know. quality guarnteed. 10 day for analysis. 5 day for design

$250 USD 15日以内
(0件のレビュー)
0.0
umairHanif024

I am a DataBase expert who is expert in making multiple ERDs, ERDs which I'd made in the recent past is of Hospital Management System, Bank Management System, Online Shopping Portal. I've made all the ERDs on MS Visio もっと

$166 USD 2日以内
(0件のレビュー)
0.0
gnugal314

A proposal has not yet been provided

$155 USD 3日以内
(0件のレビュー)
0.0
vzaitsev

Hello! I could prepare ER-model of shoes store, is it ok? I have template for it, I will need just to fix it. Best regards, Vladimir

$111 USD 3日以内
(0件のレビュー)
0.0
saurabhd63

4 years experience in database design. Worked on various complex systems. Skilled in SQL and other data base queries.

$127 USD 4日以内
(0件のレビュー)
0.0