ER Diagram / Database Design

you will need to develop a database design for the PetDoctor case study described in the attached document. Your solution deliverables for this are an ER diagram in pdf format (Part 1) and a logical database design in pdf format (Part 2)

Part 1

Your ER diagram should be normalized to 3NF and show all entities, relationships, relationship labels and arrowheads, multiplicity notation, non-key attributes, PKs, and FKs.


Part 2

In the development of your logical database design, your submitted solution to Part 2 should consist of SQL "create" statements for each entity in your ER solution to Part 1.

To earn full points, your SQL "create" statements should:

[url removed, login to view] all needed tables and attributes based on your ER diagram from part 1 above.

[url removed, login to view] all primary key attributes and foreign key attributes using CONSTRAINT clauses.

[url removed, login to view] database integrity, for example, required attributes, attribute domain consistency, entity integrity, multiplicity, and referential integrity using ON UPDATE and ON DELETE clauses.

The "Supplemental Material" attached document should be reviewed before starting work on this project

Habilidades: Administração de Bancos de Dados, Desenvolvimento de Banco de Dados, Programação de Banco de Dados, SQL

Veja mais: study programming, study design, programming diagram, logical programming, design-2-part, design 2 part, deliverables diagram, database programming sql, constraint programming, case study design, case diagram example, ER diagram, entity relationship, diagram, database design, database design sql, case study solution, domain diagram, create diagram, diagram case study, design database support web based discussion board, project database diagram sql, diagram primary, using normalized database, normalized database

Acerca do Empregador:
( 6 comentários ) Pelham, United States

ID do Projeto: #6817727

38 freelancers are bidding on average $158 for this job


Dear Sir, I did lot of ERD projects. You can find them in my reviews. I read your requirements and ready to do it. thanks

$100 USD in 3 dias
(85 Comentários)

Hi there, i'm expert on designing database, actually i saw your file, it required creating ERD with UML notation, and mapping this ERD to logical model and then implementation on SQL. I've done similar job like this be Mais

$150 USD in 3 dias
(84 Comentários)

1. Vollks Australian Online Store In these days we are complete re-designing and reimplementing an online store for our Australian client in which we are using X-Cart latest stable release to implement his all require Mais

$247 USD in 5 dias
(3 Comentários)

Hi, I have gone through the description of the project and attached reference documents. Let me introduce myself as an database expert, I am currently working with a company as DBA. I have worked extensively o Mais

$80 USD in 3 dias
(19 Comentários)

Hi, I have gone through your requirements,I am a Database Programmer at CMMI-5 Level company since August 2004.I am working on MS Access, Shell Script,MySql,MSSQL Server,Oracle database, I can do your job confidently. Mais

$150 USD in 4 dias
(25 Comentários)

Dear Sir, This is Sikander. I am having 12+ years of experience in software development and I am ready to start this job. I will provide you best services in development. Please have a look at my Profile, Ratings an Mais

$250 USD in 7 dias
(9 Comentários)

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around databases and SQL development arou Mais

$78 USD in 3 dias
(13 Comentários)

Hello, I understand your requirements. I am willing to help you do this project right now. Please contact me. Thank you

$111 USD in 3 dias
(14 Comentários)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have an assignment on databases. I have 7 years’ experience writing such assignments. I've got MSc in Information Systems. I am highly q Mais

$120 USD in 6 dias
(8 Comentários)

A proposal has not yet been provided

$222 USD in 3 dias
(6 Comentários)

Having 3+ years of Experience in Oracle MYSQL database. Have vast knowledge of Database architecture, performance tuning. Have completed these type of projects previously, Please have a look on my profile.

$90 USD in 2 dias
(4 Comentários)

Hello I am Software Engineer and Expert in database Analysis and Design so you can hire me for this Project Thanks I will Wait For your Quick Response

$120 USD in 4 dias
(1 Comentário)

HI i have more than 7 years of experience in software developing with database site, i can help you complete this project in a quick and good.

$88 USD in 2 dias
(3 Comentários)

A proposal has not yet been provided

$150 USD in 4 dias
(1 Comentário)

I am a talented .NET/SQL Developer with years of experience and educational training. I am willing to work as a team member and also autonomously for your project. I have also worked for many years of my career as a SQ Mais

$155 USD em 1 dia
(1 Comentário)

I am currently responsible for designing enterprise models including logical and physical database designs and would be more than happy to complete this task for you

$244 USD in 3 dias
(0 Comentários)

Hello Sir, My name is Ahmad Samir and I am a senior software engineer. I have a solid practical experience in DB design and ER creation for more than 5 years. I checked your job's description and attached files and Mais

$130 USD in 4 dias
(0 Comentários)

Hello all, As per my understanding the project requirements are as below: Part-1 Logical data design which is independent of database platform and normalized to 3 NF. It should include all database objects as p Mais

$100 USD in 7 dias
(0 Comentários)

Thank you for the many details that you have provided on this project. In this way, you ensure that the project will look exactly the way you want. I will design a robust and normalized database, with a flexible str Mais

$200 USD em 1 dia
(0 Comentários)

A proposal has not yet been provided

$111 USD in 3 dias
(0 Comentários)