Convert Class Diagram to Database Structure

Completado Publicado Dec 1, 2013 Pagado a la entrega
Completado Pagado a la entrega

Make a transact-SQL script for the first 2 pages of the CHF Exhibits case.

[url removed, login to view]

This data dictionary will help with the meanings of classes and attributes in the diagram:

CHF Data [url removed, login to view]

Your submission should be a single text with all the statements to create a database, a login and all the tables for the database. Also create indexes on all foreign keys.

Here is a script file to get you started. Do not change the name of the database or the login information.

[url removed, login to view]

One way to check that you have implimented built the database correctly is to enter data into tables. If you can't record the data needed, it indicates either an error in design or an error in the translation of the class diagram into table structure. The following Excel file has some data that will help you check your model of you so choose. Your script need not include data insert statements.

[url removed, login to view] Download

Administración de bases de datos SQL

Nº del proyecto: #5186414

Sobre el proyecto

8 propuestas Proyecto remoto Activo Dec 1, 2013

Adjudicado a:

hieutc

I think I can do it for you in several hours. But do I need to think about the db design, i.e I see two table, Role and Presentation Role, I think those can be merged in one; or just do the script as requested? R Más

$25 USD en 1 día
(0 comentarios)
0.0

8 freelancers están ofertando un promedio de $46 por este trabajo

Reza2012

Hi I have more than 10 years experience in MSSQL server database Design and administration. Please see my profile. thanks.

$40 USD en 1 día
(9 comentarios)
4.0
pivn

Đề xuất vẫn chưa được gửi

$45 USD en 1 día
(9 comentarios)
3.8
yubor

Hi. I am certified MS SQL Server expert (MCSE: Data Platform). Ready to help you with you project. Regards, Yuri.

$55 USD en 3 días
(16 comentarios)
3.6
mail2vimalarora

Hi.. I have gone through your requirement of SQL script required by you for mentioned tables and its attributes. I have good understanding of tables and its relations and feel comfortable in taking up the job and provi Más

$30 USD en 0 días
(4 comentarios)
2.9
savvyinnovations

G'day SkittlesAddictx5, I have 5+ years experience with Microsoft SQL Server ranging from MS SQL Server 2005 - 2012. I am experienced with designing and developing RBDMS for a number of applications such as Multi-te Más

$55 USD en 3 días
(0 comentarios)
0.0
pallavibk

hi I am experienced developer. I have experience in creating/ maintaining database. Whether I need to Create script here on my machine and then message you ? thanks

$55 USD en 1 día
(0 comentarios)
0.0