Закрыт

Design a very small database

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.

Навыки: MySQL, Разработка баз данных

Показать больше: create oscommerce displays mores products, php create small database, create flyers samples cleaning services, lucidchart database design, database architecture design, database design examples, relational database, database table design examples, student database design example, database design practice problems, database schema design, design small network topology visio diagram, create small database, small database design project, create small database java, database design small hospital, software create small database, design small database, design small database project using access, small database design examples

О работодателе:
( 0 отзыв(-а, -ов) ) Patna, India

ID проекта: #26760067

11 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹9303

(30 отзывов(-а))
4.5
Emiraza

hey how are you need asp.net mvc or [login to view URL] core developer em here for your assistant please ping me to discuss more on this and for front end #React js #angular js #angular

₹7000 INR за 7 дней(-я)
(1 отзыв)
2.9
sankargan88

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.

₹13333 INR за 4 дней(-я)
(1 отзыв)
2.3
rs181915

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 Prog Больше

₹12500 INR за 10 дней(-я)
(1 отзыв)
0.3
afnanahmad0

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

₹10000 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
AndreiSky

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.

₹10000 INR за 3 дней(-я)
(0 отзывов(-а))
0.0
RajAtagaraha

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 optimiz Больше

₹7000 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
udalsoft

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 & Больше

₹12000 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
cardelgo

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 w Больше

₹12500 INR за 5 дней(-я)
(0 отзывов(-а))
0.0
tabassummahanaz

I have done database designs before I have experience to do

₹3000 INR за 3 дней(-я)
(0 отзывов(-а))
0.0
burhanisolution5

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 i Больше

₹8000 INR за 5 дней(-я)
(0 отзывов(-а))
0.0