Find Jobs
Hire Freelancers

Design a very small database

₹1500-12500 INR

Zavřený
Zveřejněno před více než 3 roky

₹1500-12500 INR

Zaplaceno při doručení
Design a very small database and a create a brief description of the below 3-4 steps in a doc 1. You need to add the data to the database that has been provided to you in the Excel document. You must add the new client using the T-SQL Insert statement. All other data—other than the client—can be entered using the SSMS Edit Table feature. Important: In the doc, paste the text of your T-SQL Insert statement. 2. Write a paragraph describing any changes that you needed to make to your database design and implementation as a result of the materials provided here and in the Excel document. In a few sentences, what could you have done in the early design process that would have prevented any issues at this point in your project? 3. White a series of T-SQL SELECT queries to report the data that you have inserted into your database. There is no specific "look-and-feel" for your reports/queries. The T-SQL Select statement doesn't allow you to do much in the way of formatting your output. But make sure you can accomplish the following querying tasks—several of which will require you to join multiple tables together. The goal is to demonstrate that you can produce the desired output and that you can do so with a single T-SQL Select statement for each of the following (all queries in this project should use the data provided as part of this project for City of Windsor Fire Pension): a. Create a query that shows the name of the client, the address information, investor contact, and client services contact. b. Create a query that displays the name of the client and then the "sum" total of the value of their account. This is to say that it needs to calculate the shares X price for each investment and total these and show that total with the name of the client. Hence, this query should result in only one row for each company that you query. c. Create a query that shows each stock, stock company name, price, shares, and total investment (shares X price). d. Create a query that shows the client, the management fee, and then calculate what the total management fee will be based on the value of the investments being managed. For example, if the total value of the investments equal $10 million, then the total management fee will be $93,000.00. You will copy the T-SQL query statements that you write into your progress report in the doc, making sure that you carefully document what each query does with what it produces. To document the results simply include a screen capture of your SSMS screen.
IČ projektu: 26760067

O projektu

11 nabídky
Vzdálený projekt
Aktivní před 4 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
11 freelanceři nabízejí v průměru ₹9 303 INR za tuto práci
Avatar uživatele
Hi, I have gone through the details which you have shared and I can do this. I have an experience of 10+ years in database. Ping me in chat for more details, Thanks in advance.
₹13 333 INR v 4 dnech
5,0 (1 recenze)
2,3
2,3
Avatar uživatele
Hello, I am an experienced Full Stack Web Developer, and i am willing to complete your company projects in minimum time, I do have a very sharp hand in : HTML5, CSS3, Bootstrap 4 & 5 too, Javascript MySQLi and PHP Programming language. Contact me so we can discuss further details and Start working, I will get your work done in Minimum possible time with Maximum Quality, Thank you.
₹12 500 INR v 10 dnech
4,8 (1 recenze)
0,3
0,3
Avatar uživatele
Hi, Your provided details are really good and comprehensive. I assure you I can do this job in best budget and time. Let's talk. Afnan
₹10 000 INR v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hi, I would like to collaborate with you. The SQL queries looks pretty easy to do in a reasonable time. Looking forward to hear from you.
₹10 000 INR v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I have an expertise in development of complete database from scratch for multiple projects which adhere to ACID properties, data warehouse. I have worked and wrote 1000 of queries and stored procedure which are optimized and gives no error. I can also create an automation solution of the repeatable task for reporting. I have working experience in MySQL, SQL Server, Redshift and Postgres.
₹7 000 INR v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Respected Sir, Greetings of the Day ! I am Udal Bharti. I have 9+ years of competitive experience in web application development using .net and SQL server. I have 7+ years of experience in Database development & management and i am expert in writing complex queries, stored procedure, User Defined Functions. My Skills ------------------- 1. Extensive Experience in writing complex queries 2. Expert in Writing Stored Procedures, Triggers, User Defined Fucntions 3. Expert in Creating and managing Jobs 4. Expert in SSRS If I can provide you with any further information on our background and qualifications ,Please let me know. I look forward to hearing from you , Thank you for your consideration. Regards Udal Bharti
₹12 000 INR v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Greetings. Your quality parameters will be the baseline for the project. I am an Agile practitioner, and I have supported deployments both on-premise and in cloud environments. Some of the services I have supplied when working as a member of remote software providers: - I was involved in the specification and implementation of projects for the sector of tourism services. Through system integrators are accessed hundreds of suppliers and tour operators who, in real-time, offer and sell the availability of their services. Clients: Hotelbeds and SerhsTourism in Spain and TUI UK in England. - I was part of projects to develop operational support systems (OSS) and management of network resources (NRM) in the telecommunications sector. Clients: Andinatel and Claro. - Offshore custom software engineering developing solutions that provide price optimization, sales effectiveness, and revenue management SaaS products. Clients: PROS Inc., ABG, Hertz, Avianca, LIW, Volvo. My main strengths are on the backend side, manipulating XML/JSON, data persistence, and web services. I team up perfectly with persons who are proficient on the frontend, quality assurance, and other disciplines. My development skills include SCMs like Git; SQL and NoSQL; automated tests; JMeter; messaging with tools like ActiveMQ and Tibco; caching solutions; Maven, Gradle, & CI/CD systems; and more. Take a look at my résumé and if you have any questions, please let me know. Best regards.
₹12 500 INR v 5 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I have done database designs before I have experience to do
₹3 000 INR v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hello! This is Mufaddal from Burhani IT Solutions, we build and provide services on our Mobile App (Android and ios), Web Application, Oracle based Softwares for more than 10 years. As an expert, I am very interested in doing this project. I have gone through your project details and I can easily fulfill all the requirements. Quality and time of project is guaranteed. Please offer me the opportunity to provide you with my expertise. Thank You
₹8 000 INR v 5 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z INDIA
Patna, India
0,0
0
Členem od čvc 16, 2020

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.