MODULE IV

General Information

// SUBMODULE 1
Build databases for web applications
96 hours
DEVELOP WEB APPLICATION SOFTWARE WITH
PERSISTENT DATA STORAGE
192 hours // SUBMODULE 2
Develop web applications with database connection
data
96 hours

OCCUPATIONS ACCORDING TO THE NATIONAL CLASSIFICATION OF OCCUPATIONS SYSTEM (SINCO-2011)

2271 Researchers and Specialists in Computer Systems

2272 Multimedia Software Developers and Analysts
2651 Assistants and Technicians in Computing and Communication and Recording Equipment

INSERTION SITES ACCORDING TO THE NORTH AMERICAN INDUSTRY CLASSIFICATION SYSTEM (NAICS-2013)

519130 Editing and dissemination of content exclusively through the Internet and search services on the web
541510 Computer system design services and related services
611421 Private sector computer schools
611422 Public sector computer schools
 MODULE IV
DEVELOP A WEB APPLICATION SOFTWARE WITH PERSISTENT DATA STORAGE

LEARNING OUTCOME
At the end of the module, the student will be able to:
• Develop web application software with persistent data storage
• Building Databases for Web Applications
• Develop web applications in a programming language with database connectivity

COMPETENCIES/CONTENTS TO DEVELOP
No. PROFESSIONALS SUBMODULE SITUATIONS

Implement the conceptual and logical design of the Applying the entity-relationship model
1 1 Using the relational model
database
Checking its minimum normality

Using the relational database management system

2 Implement the physical design of the database 1 Creating the database elements
Creating relationships and views of the database

Through update queries, grouping, and data combination

3 Manage the information of the database 1 Through data selection queries
Using SQL language and the visual query tool

4 Design a Web application 2 Using programming language for web development with database connection

Using the programming language

Through an Open Source development environment
5 To program a web application 2 Using an Open Source Framework
Incorporating HTML, CSS
Connecting to the database

33
 MODULE IV
DEVELOP WEB APPLICATION SOFTWARE WITH PERSISTENT DATA STORAGE

COMPETENCIES RELATED TO THE COMMON CURRICULUM FRAMEWORK

SUGGESTED BASIC DISCIPLINES

Competencies required to develop professionals. They are developed from the basic training component.

M1 Builds and interprets deterministic or random mathematical models through

C1 Identifies, organizes, and interprets explicit and implicit ideas, data, and concepts in
the application of arithmetic, algebraic, geometric procedures and
a text, considering the context in which it was generated and in which it is received.
variational, for the understanding and analysis of real or formal situations.
CE9 Designs models or prototypes to solve problems, meet needs or M8 Interprets tables, graphs, maps, diagrams, and texts with mathematical symbols.
demonstrate scientific principles. scientists.

SUGGESTED GENERICS
These attributes are included in professional competencies; therefore, they should not be developed separately.

4.5 Manages information and communication technologies to obtain 8.1 Proposes ways to solve a problem or develop a project as a team,
information and express ideas. defining a course of action with specific steps.

5.6 Uses information and communication technologies to process and interpret. 8.3 Assume a constructive attitude, consistent with knowledge and abilities.
information. with those that are part of different work teams.

PRODUCTIVITY AND EMPLOYABILITY SKILLS OF THE SECRETARIAT OF LABOR AND SOCIAL PROTECTION

These attributes are included in professional competencies; therefore, they should not be developed separately.

Carry out activities to achieve objectives and goals AP3 Register and review information to ensure it is correct

CE2 Support your ideas and viewpoints with arguments based on evidence.
OL4 Work until achieving the proposed goals or challenges
facts and data

AD5 Accept and apply the changes to the procedures and tools of
PO3 Define systems and work schemes
work

34
 MODULE IV
DEVELOP WEB APPLICATION SOFTWARE WITH PERSISTENT DATA STORAGE

LEARNING ASSESSMENT STRATEGY

The evaluation is conducted with the purpose of demonstrating, in the student's education, the development of professional competencies and
generic in a comprehensive manner through a continuous and dynamic process, creating the conditions in which both are applied and articulated.
competencies in different learning environments and professional performance. In the context of competency-based evaluation, it is
it is necessary to recover performance evidence with various evaluation instruments, such as observation guides, logs and
anecdotal records, among others. Evidence by product, with work folders, reports, logs, and checklists, among others.
And the evidence of knowledge, with questionnaires, summaries, mind maps, and synoptic charts, among others. For which it
will apply a series of integrative practices that provide evidence and the presentation of the portfolio.

No. PROFESSIONAL COMPETENCIESSUBMODULE SITUATIONS PRODUCT PERFORMANCE

The conceptual design and
Applying the entity-relationship model relational logic of the
Implement the conceptual design and
1 1 Using the relational model Elaborated database
logical of the database in printed format or
Checking your minimum normality
digital

Using the database management system The physical base design

Implement the physical design of the database. relational relational data
2 1
of data Creating the database elements implemented in the
database manager.
Creating relationships and views of the database

Through update, grouping, and queries

data combination
Manage the information of the database The SQL Script in format
3 1 Through data selection queries
data elaborate digital
Using SQL language and the visual tool of
consultation

Using the programming language to The interface of the

4 Design a Web application 2
web development with database connection designed application

Using the programming language

Through an Open Source development environment
The Web application
5 To program a web application 2 Using an Open Source Framework
scheduled
Incorporating HTML, CSS
Connecting to the database

35
 MODULE IV
DEVELOP WEB APPLICATION SOFTWARE WITH PERSISTENT DATA STORAGE

SOURCES OF INFORMATION

No. PROFESSIONAL COMPETENCIES

SUBMODULE REFERENCES
Martínez, F.J. & Gallegos, A. (2017) Programming of relational databases. Spain: Ra-Ma
Implement the conceptual design and Cuadra, D., Castro, E., Iglesias A., Martínez P., Calle F., De Pablo C., All-Jumaly M., Moreno L., García
1 1
logical database S., Martínez J., Rivero J. & Segura I. (2013). Development of Databases. Practical Cases from the
analysis of the implementation. 2nd Edition. Spain: Alfaomega. Ra-Ma

Martínez, F.J. & Gallegos, A. (2017) Programming of relational databases. Spain: Ra-Ma
Implement the physical design of the database Cuadra, D., Castro, E., Iglesias A., Martínez P., Calle F., De Pablo C., All-Jumaly M., Moreno L., García
2 1
of data S., Martínez J., Rivero J. & Segura I. (2013). Development of Databases. Practical cases from the
analysis of the implementation. 2nd Edition. Spain: Alfaomega. Ra-Ma

SQL Easy
Martínez, F.J. & Gallegos, A. (2017) Programming of relational databases. Spain: Ra-Ma
Manage the database information
3 1 Cuadra, D., Castro, E., Iglesias A., Martínez P., Calle F., De Pablo C., All-Jumaly M., Moreno L., García
of data
S., Martínez J., Rivero J. & Segura I. (2013). Development of Databases. Practical cases from the
analysis of the implementation. 2nd Edition. Spain: Alfaomega. Ra-Ma

Montero R. (2017). Java 9 Practical Guide. Mexico City: ANAYA

4 Design a Web application 2
Ceballos, F.

Java 9 Practical Guide

5 Program a Web application 2
Ceballos, F. (2015). Java. Graphical interfaces and applications for the internet 4th edition. Spain: Ra-Ma

36