Database Entity Relationship Diagram
- or -
Post a project like this3594
£25(approx. $31)
- Posted:
- Proposals: 6
- Remote
- #492341
- Awarded
VBA, Excel,Access,SQL Development,Intrgration & Automation,Database Desigh & Development,Reporting Services
Melbourne
42253329789145952654918460144380167
Description
Experience Level: Intermediate
Estimated project duration: 1 - 2 weeks
General information for the business: SQL Database
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: I have a SQL2008R2 database that has grown over the last couple of years.
It is updated on a daily basis through schedule download and I run a number of queries, exports and varying other tasks through scheduled VB interface.
I wish to have an independent review of the database/system and have a visual relationship schema created (Entity Relationship Diagram) so I can see how the data tables are linked (Primary/Foreign), what elements get updated with the daily updates, which parts of the data the VB queries use and which SQL Database they are linked to.
I will require confirmation before the project is started on how this data is going to be presented I.e. through visual database tools or another third party application, finally any recommendations to improving the database/process and scripts. I can provide full access to the database via a remote connection and understand if you wish to look at the sql server first before committing on the cost.
Specific technologies required: SQL, VB
Extra notes:
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: I have a SQL2008R2 database that has grown over the last couple of years.
It is updated on a daily basis through schedule download and I run a number of queries, exports and varying other tasks through scheduled VB interface.
I wish to have an independent review of the database/system and have a visual relationship schema created (Entity Relationship Diagram) so I can see how the data tables are linked (Primary/Foreign), what elements get updated with the daily updates, which parts of the data the VB queries use and which SQL Database they are linked to.
I will require confirmation before the project is started on how this data is going to be presented I.e. through visual database tools or another third party application, finally any recommendations to improving the database/process and scripts. I can provide full access to the database via a remote connection and understand if you wish to look at the sql server first before committing on the cost.
Specific technologies required: SQL, VB
Extra notes:
Jason R.
100% (17)Projects Completed
21
Freelancers worked with
17
Projects awarded
19%
Last project
13 Mar 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies