Convert Class Diagram to Database Structure

Completed Posted Dec 1, 2013 Paid on delivery
Completed Paid on delivery

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

Database Administration SQL

Project ID: #5186414

About the project

8 proposals Remote project Active Dec 1, 2013

Awarded to:

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 More

$25 USD in 1 day
(0 Reviews)
0.0

8 freelancers are bidding on average $46 for this job

Reza2012

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

$40 USD in 1 day
(9 Reviews)
4.0
pivn

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

$45 USD in 1 day
(9 Reviews)
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 in 3 days
(16 Reviews)
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 More

$30 USD in 0 days
(4 Reviews)
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 More

$55 USD in 3 days
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0