Making a laboratory from a database
13 USD The laboratory work is performed according to the indicated individual option.by L.1.Creating a database and developing tables for it.The task is to create a database and assign a name to it.Create tables structures for the database according to the task option.The L.2.Developing the interconnection scheme of tables.Task: Develop a scheme of interconnections between the database tables that characterizes the subject area.Conquer the means and rules of data correction in the tables.Introduce in the table and scheme of interconnections means that ensure the integrity of data in the BD.by L.3.Fill out the table with data.Task: Fill all the tables with data that correspond to the subject area of the task.The number of records must ensure the correct functioning of requests.by L.4.Forming requests to the database tables.The task:
To get the search for records by the determined value of the fields;
To be able to sort the records in the tables;
Get the requests to several tables.by L.5.Forming complex requests to the database tables.The task:
Working with aggregate functions;
Resolve the requests;
Request related requests.Ls 6 .Use of presentations.The task:
Forming a presentation according to the task option;
Create a presentation that is updated.
L.7 Creation of preserved procedures.The task:
Create a saved procedure that performs the modification of the table.The procedure must check the conditions of modification, and make warnings if the conditions are not met.by L.8.Creating a trigger.The task:
Create a trigger that controls the integrity of the modification operations in the related table;
Create a trigger that controls the integrity of the modification operations with the data in other tables.by L.9.Safety management BD
The task:
In accordance with the methodological instructions to perform a set of actions on information protection in the BD.Variant No. 12
Subject area: Admission committee (abiturants).Basic subject-significant essences: Abiturents, Specialties, Subjects.Basic subject-significant attributes of essences:
- Applicants - name, name, by father, article, date of birth, speciality;
Speciality is the name of speciality.
Subjects are the name of the object, the type of control.Basic requirements for system functions:
- Choosing all abituants for specialties or specific specialties;
- Choose all the students who have passed the entrance exams and their rating (the sum of points for all subjects) according to specialties or specific specialties;
The average score of disciplines and specialties.The Trigger:
1 .To add a record on the results of the exam.If for the specified subjects there is an assessment from the discipline, prohibit adding the record.The 2ndCreate a presentation of the "Exempts" with the fields "PIB of the Aboriginal", "Discipline", "According", which contains the results above N. Update the presentation of the "Exempts".The Procedure:
The procedure must return the average score of the indicated abitory.
Applications 1
Client's review of cooperation with Aleksandr Keshman
Making a laboratory from a databaseThank you for your collaboration, everything is done well.
Freelancer's review of cooperation with Bogdan I.
Making a laboratory from a databaseBogdan is a good customer, provided clear tasks and methodical instructions that in the process of performing the work. With understanding and patience, I have come to a delay, for which I am grateful. I was almost always in contact. I recommend cooperation.
-
Winning proposal6 days13 USD
1528 88 11 6 Winning proposal6 days13 USD
Good afternoon, I will do my task. We have great experience in doing such work.
-
1 day22 USD
402 15 1 1 day22 USD
Good day . I have great experience in writing databases of different complexity.
It will be done for tomorrow (04.01). I will write a commentary with an explanation and explain everything that will be interesting. I can also write an explanatory note to these laboratory works.
Get back, agree, always in contact.
I am pleased to cooperate)
-
4 days33 USD
318 21 0 4 days33 USD
Good day . Ready to develop a BD in MySQL. I would like to look at the method. And there are a few questions about reports, robots filling and timetables.
-
5 days4 USD
34 5 days4 USD
I will help you to do as quickly as possible, which database ACCESS???????The ?
-
7 days25 USD
189 1 0 7 days25 USD
Good day ! Interested in your proposal. Can you use the method?
-
Прикрипите или ссылку или задание более отркыто спасибо.
-
Current freelance projects in the category Tuition
Romanian language tutor for a child
16 USD
Hello. We are looking for a tutor for an 11-year-old child in Romanian language. Please write about your tutoring experience, your level of language proficiency, the cost of your services, and what times you are available for lessons. Tuition ∙ 2 days 6 hours back |
Launching an online programming and IT school for children: website, platform, CRM, and automation
28 USD
Need help launching an online programming and IT school for children and teenagers in Germany. We already have an offline programming school for children, experience conducting classes, the first online groups, and an understanding of the product. Now we need to properly… Tuition, Client Management & CRM ∙ 5 days 2 hours back ∙ 25 proposals |
Create a basic electrical diagram in A1 format according to the plan.Assemble the diagramThe diagram must be assembled according to the requirements of the state standard.A schematic electrical diagram in A1 format in a frame has been created.I need to receive a PDF file ready for printing, and the file of the assembled diagram. Tuition ∙ 7 days 8 hours back ∙ 2 proposals |
One-time project (1 month): call manager for clients (remote)
334 USD
One-time project (1 month): client call manager (remote) BEST DEVELOPMENT OÜ (Estonia) invites a specialist for a temporary project lasting 1 month for the position of client call manager (educational programs, foreign language courses). Work format: fully remote (online)… Tuition, Customer Support ∙ 9 days 9 hours back ∙ 4 proposals |
I am looking for a FreeCad program instructor.I'm looking for a FreeCad instructor. The goal is to learn how to design technical parts for 3D printing. 3D Modeling, Tuition ∙ 9 days 9 hours back |
Rovno