Scenario from the lesson of practical classes of computer science technician – 8 scenario INF03

Scenario from a practical lesson

Profession: INFORMATION TECHNOLOGIST

Qualification: INF.03. Development and administration of websites and web applications and databases

Class: IV

Number of hours: 10h

Place of holding classes:

SIDCom Dariusz Michaluk, ul. Ciechanowiecka 19e, 17-300 Siemiatycze

School/company computer simulation laboratory/laboratory, headquarters of companies engaged in the development and operation of computer software, service point, computer network administration company, computer store, IT service department of any enterprise,

Practical class topic: Database system management

Unit Themes:

Analysis and modification of the database structure

Expansion of the database structure
Verification of the correctness of the database structure after expansion
Deleting elements of the database structure and the data in it

OVERALL OBJECTIVE OF THE CLASS:

Developing database system management skills

OPERATIONAL OBJECTIVES:

The student can:

Use database concepts;
Create E/R diagrams (Entity-Relationship Diagram);
Use database management systems SZBD (Database Management System);
Use Structured Query Language (SQL);
Create relational databases as designed;
Create forms, queries and reports for data processing;
Modify database structures;
Manage the database system;

ACTIVITY OBJECTIVES:

Cognitive: Familiarize students with the mechanism of database system management
Educational: Mastering the skills of operating a database system
Educational: To raise awareness of the opportunities provided by database systems

IMPLEMENTATION METHODS:

Show
Instruction
Practical exercises

TEACHING METHODS:

Performing and analyzing practical solutions, Instruction with demonstration

TEACHING RESOURCES:

Internal instructions and orders in force at the unit where the student is doing his professional practice
Job descriptions, instructions, specialized software

FORM OF TEACHING:

Individual and group exercises