Find Jobs
Hire Freelancers

need SQL project expert

₹100-400 INR / hour

Imefungwa
Imechapishwa over 6 years ago

₹100-400 INR / hour

One (1) of the main functions of any business is to transform data into information. The use of relational databases has gained recognition as a standard for organizations and business transactions. A quality database design makes the flow of data seamless. The database schema is the foundation of the relational database. The schema defines the tables, fields, relationships, views, indexes, and other elements. The schema should be created by envisioning the business, processes, and workflow of the company. Section 1: Design Document 1. Write a five to ten (5-10) page design document in which you: a. Create a database schema that supports the company’s business and processes. b. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes. c. Create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved. d. Normalize the database tables to third normal form (3NF). e. Create an Entity-Relationship (E-R) Diagram through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. f. Explain your rationale behind the design of your E-R Diagram. g. Create a Data Flow Diagram (DFD) through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. h. Explain your rationale behind the design of your DFD. i. Create at least two (2) sample queries that will support the organizational reporting needs. j. Create at least two (2) screen layouts that illustrate the interface that organizational users will utilize. Section 2: Revised Gantt Chart / Project Plan Use Microsoft Project or an open source alternative, such as Open Project, to: 2. Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 2: Business Requirements, with all the project tasks
Kitambulisho cha mradi: 15699223

Kuhusu mradi

9 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
9 wafanyakazi huru wana zabuni kwa wastani ₹560 INR/saa kwa kazi hii
Picha ya Mtumiaji
A proposal has not yet been provided
₹600 INR ndani ya siku 16
4.9 (31 hakiki)
5.7
5.7
Picha ya Mtumiaji
Hello, I have 14 years of experience as a Tech Lead/Developer in .Net Technologies. I have carefully gone through your job post and it looks like a perfect fit for my skills set. I am an expert of SQL and SQL Server. From more than 10 years I have been working in SQL. I have very good knowledge of queries, tables and triggers and have worked on complicated SPs It's been almost a decade that I've been working in C#, ASP.NET, MVC, SQL, Javascript and Jquery. I have good experience of oracle. I have worked on many existing and new multi-tier applications from front-end to back-end. Programming is my passion. I can work alone or within a team. If you are ready, I can show some of the code that I have written to give you an idea how clean and easy to maintain code do I write. I have worked for several product companies like DocStar and NZ Financial Services Group. If you can give me a chance to work on your project for at least 2-3 days, I can prove that I would be the right choice for your project. I would like to tell you that I'm ready for a POC/test. I want to show you my work and skills. You can also contact me on skype: mohammadrafionline Thanks
₹555 INR ndani ya siku 40
5.0 (1 hakiki)
4.4
4.4
Picha ya Mtumiaji
Hi, A SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. Please feel free to discuss the project with me so that I can wrap it up in a timely manner as per your requirements. Thanks, Murtaza
₹1,250 INR ndani ya siku 40
5.0 (2 hakiki)
4.0
4.0
Picha ya Mtumiaji
I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.
₹277 INR ndani ya siku 10
4.4 (25 hakiki)
4.2
4.2
Picha ya Mtumiaji
Understand the requirements. Database design in SQL SERVER. Tables , scripts and required code is developed in SQL SERVER. Create Data Flow Diagram (DFD). Create an Entity-Relationship (E-R) Diagram. Data loading using SQL/SSIS. write sql script for Reports - SSRS. Testing. documentation.
₹666 INR ndani ya siku 40
4.1 (6 hakiki)
3.4
3.4
Picha ya Mtumiaji
A proposal has not yet been provided
₹444 INR ndani ya siku 5
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
A proposal has not yet been provided
₹111 INR ndani ya siku 10
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya INDIA
Bangalore, India
4.8
228
Njia ya malipo imethibitishwa
Mwanachama tangu Jan 29, 2011

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.