Microsoft SQL Server Laboratory
2ndDevelopment of data storage
Download the data to the storage
Multi-dimensional analysis of data
Cluster analysis of data
I started to do two laboratories.I attach the database.If something is wrong to fix.I add the methodology, all is detailed.Each laboratory should be drawn up on a separate Word document with a detailed description of each step and task point and a screen.For the second laboratory in addition - fill out the data fields (minimum 50 records) and make a diagram screen.Variant
Tourist agency
Description of the subject area
The company provides customers with services to organize travel abroad.At the same time, the purposes of the trips can be different (rest, tourism, treatment, etc.)The fixed cost of the 1 day stay in one country, including the cost of accommodation, food, tour service and other services, shall be established.This cost is the characteristic of each specific route.The cost of the trip can be calculated as the cost of 1 day stay • The number of days + the cost of transportation services + the cost of the visa.In addition, the customer pays an added value tax (VAT) of 18% of the cost of the trip.Minimum set of fields of basic tables
1 FIO Customer
2 Data of passport
3 Country of destination
4 Purpose of the trip
5 Cost of 1 day stay
6 Cost of transportation
7 Cost of Visa
(Determined by the choice of route)
8 Start of the trip
Number of days 9
Applications 2
Client's review of cooperation with Nikolay Khablenko
Microsoft SQL Server LaboratoryThe project is implemented in time and cooperation is pleased. All requirements for work were fulfilled. I recommend it.
![]()
Freelancer's review of cooperation with client
Microsoft SQL Server LaboratoryResponsible Customer . I recommend cooperation.
-
622 28 0 Good day . Interested in your project. I am ready to discuss the details in the personal letter. What are the labs to perform? In the methodology there are eight. You have 1 and which other 5? What about the budget and deadlines? Do you work by your already created BD, or by your task?
Current freelance projects in the category Databases & SQL
Accounting, planning, and sales system for a mushroom farm
600 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 1 day 8 hours back ∙ 51 proposals |
External report 1C 8.3 — forecast of goods balances
22 USD
An external report (.erf) is needed for 1C:Enterprise 8.3 (configuration to be specified). What it should do: Extract product balances from the database Analyze sales history for the last 30 days Calculate the average sales rate for each product Determine how many days until the… Databases & SQL, Client Management & CRM ∙ 1 day 8 hours back ∙ 11 proposals |
Web Application & Database Security Audit for Custom CRM — BaaS / Database-as-API Specialist (PenetrProject Overview We operate a custom-built customer relationship management (CRM) platform that runs two service businesses on a single system. It is a modern JavaScript web application backed by a backend-as-a-service (BaaS) database and deployed on a serverless hosting… Databases & SQL, Testing & QA ∙ 1 day 21 hours back ∙ 9 proposals |
Database synchronizationSynchronization of Microsoft Access programs and CRM SalesDrive. Data transfer from CRM to Microsoft Access in the first stage (changing the funnel status). Data transfer from Microsoft Access to CRM in the second stage (changing the status in the program). Databases & SQL ∙ 2 days 3 hours back ∙ 11 proposals |
Setting up a backup system and optimizing server infrastructureObjective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 3 days 1 hour back ∙ 24 proposals |