Make a transact-SQL script for the first 2 pages of the CHF Exhibits case.
[login to view URL]
This data dictionary will help with the meanings of classes and attributes in the diagram:
CHF Data [login to view URL]
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.
[login to view URL]
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.
[login to view URL] Download
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?
Regards,
$25 USD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0
8 freelancers δίνουν μια μέση προσφορά $46 USD για αυτή τη δουλειά
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 providing you complete solution.
Since everything is being provided from your side, I can start working on your project instantly on being awarded.
Waiting for your response to proceed further. Thanks.
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-tenant accountancy , customer relationship management, project management, resource management etc.
I am the best candidate for your project for a number of reasons:
1) There is no Language barrier (meaning I understand what you want).
2) I live in a developed country thus I can provide reliable service (e.g. minimal power outages)
3) Have the capacity to do this project based on experience and point two.
4) Australia has a strong set of laws protecting people from IP (intellectual property) theft and trademark infringements.
Please PM me if you have any queries.
Kind Regards
Trent
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