2017 – 2018
Florida Department of Education
Curriculum Framework 

Program Title:	Database and Programming Essentials
Program Type:	Career Preparatory
Career Cluster:	Information Technology

Secondary – Career Preparatory	
Program Number	8206400	
CIP Number	0511080207	
Grade Level	9-12, 30, 31	
Standard Length	4 credits	
Teacher Certification	Refer to the Program Structure section.	
CTSO	FBLA
BPA	
SOC Codes (all applicable) 	15-1141 – Database Administrators	
CTE Program Resources 	http://www.fldoe.org/academics/career-adult-edu/career-tech-edu/program-resources.stml	

Purpose 

This program offers a sequence of courses that provides coherent and rigorous content aligned with challenging academic standards and relevant technical knowledge and skills needed to prepare for further education and entry-level database and internet/web related careers in the Information Technology career cluster; provides technical skill proficiency, and includes competency-based applied learning that contributes to the academic knowledge, higher-order reasoning and problem-solving skills, work attitudes, general employability skills, and technical skills related to database and Internet technologies skills using the latest industry tools. This curriculum is project-based and modeled after the Oracle Academy.

Additional Information relevant to this Career and Technical Education (CTE) program is provided at the end of this document.

Program Structure

This program is a planned sequence of instruction consisting of one occupational completion point.  It is recommended that students complete Algebra I and a programming/flow-charting course concurrently or prior to taking this program.

To teach the courses listed below, instructors must hold at least one of the teacher certifications indicated for that course.

The following table illustrates the secondary program structure:

OCP	Course Number	Course Title	Teacher Certification	Length	SOC Code	Level	Graduation Requirement	
A	8207310	Digital Information Technology	DIT Teacher Certifications	1 credit	15-1151	2	PA	
	8206410	Database Fundamentals	BUS ED  1 @2
COMPU SCI  6
COMP PROG 7G
Any Academic Field PLUS appropriate industry certification.	.5 credit	15-1151	2	VO	
	8206420	Data Control and Functions 		.5 credit	15-1151	2	VO	
	8206430	Specialized Database Programming		1 credit	15-1151	3	VO	
	8206440	Specialized Database Applications		1 credit	15-1151	3	VO	
(Graduation Requirement Abbreviations- EQ= Equally Rigorous Science, PA= Practical Arts, EC= Economics, VO= Career and Technical Education)

Academic Alignment Table

Academic alignment is an ongoing, collaborative effort of professional educators specializing in the fields of science, mathematics, English/language arts, and Career and Technical Education (CTE). This initiative supports CTE programs by improving student performance through the integration of academic content within CTE courses. Career and Technical Education courses that have been aligned to the Next Generation Sunshine State Standards for Science and the Florida Standards for Mathematics and English/Language Arts will show the following data: the quantity of academic standards in the CTE course; the total number of standards contained in the academic course; and the percentage of alignment to the CTE course.

Courses	Anatomy/ Physiology 
Honors	Astronomy     Solar/Galactic Honors	Biology 1	Chemistry 1	Earth-Space Science	Environmental Science	Genetics
Honors 	Integrated Science 1	Marine Science 1 Honors	Physical Science	Physics 1	
8207310	5/87
6%	5/80
6%	24/83
29%	5/69
7%	24/67
36%	5/70
7%	5/69
7%	24/82
29%	5/66
8%	24/74
32%	5/72
7%	
8206410	#	#	19/83
23%	#	19/67
28%	#	1/69
1%	19/82
23%	#	19/74
26%	#	
8206420	4/87
5%	4/80
5%	#	4/69
6%	#	4/70
6%	4/69
6%	0/82
0%	4/66
6%	#	4/72
6%	
8206430	#	#	#	#	#	#	#	0/82
0%	#	#	#	
8206440	19/87
22%	19/80
24%	#	19/69
28%	0/67
0%	19/70
27%	19/69
28%	0/82
0%	14/66
21%	0/74
0%	19/72
26%	
**   Alignment pending review    						#   Alignment attempted, but no correlation to academic course

Courses	Algebra 1	Algebra 2	Geometry	English 1	English 2	English 3	English 4	
8207310	20/67
30%	15/75
20%	18/54
33%	40/46
87%	40/45
89%	40/45
89%	40/45
89%	
8206410	15/67
22%	13/75
17%	14/54
26%	16/46
35%	16/45
36%	18/45
40%	18/45
40%	
8206420	3/67
4%	3/75
4%	3/54
6%	13/46
28%	13/45
29%	13/45
29%	13/45
29%	
8206430	8/67
12%	14/75
19%	8/54
15%	11/46
24%	10/45
22%	11/45
24%	11/45
24%	
8206440	8/67
12%	15/75
20%	8/54
15%	13/46
28%	13/45
29%	13/45
29%	13/45
29%	
**   Alignment pending review    			#   Alignment attempted, but no correlation to academic course

Florida Standards for Technical Subjects 

Florida Standards (FS) for English Language Arts and Literacy in History/Social Studies, Science, and Technical Subjects are the critical reading and writing literacy standards designed for grade 6 and above. These standards are predicated on teachers of history/social studies, science, and technical subjects using their content area expertise to help students meet the particular challenges of reading, writing, speaking, listening, and language in their respective fields. The FS for Mathematical Practices are designed for grades K-12 and describe varieties of expertise that educators at all levels should seek to develop in their students. These practices rest on important “processes and proficiencies” with longstanding importance in mathematics education.

Instructors must incorporate the Florida Standards for Technical Subjects and Mathematical Practices throughout instruction of this CTE program.  To access these standards, please click on the following link: http://www.fldoe.org/core/fileparse.php/5652/urlt/FloridaStandardsTechSubjects.rtf. 

Florida Standards for English Language Development (ELD)
English language learners communicate for social and instructional purposes within the school setting. ELD.K12.SI.1.1 

English Language Development (ELD) Standards Special Notes:
Teachers are required to provide listening, speaking, reading and writing instruction that allows English language learners (ELL) to communicate for social and instructional purposes within the school setting.   For the given level of English language proficiency and with visual, graphic, or interactive support, students will interact with grade level words, expressions, sentences and discourse to process or produce language necessary for academic success. The ELD standard should specify a relevant content area concept or topic of study chosen by curriculum developers and teachers which maximizes an ELL’s need for communication and social skills. To access an ELL supporting document which delineates performance definitions and descriptors, please click on the following link: http://www.cpalms.org/uploads/docs/standards/eld/SI.pdf.
For additional information on the development and implementation of the ELD standards, please contact the Bureau of Student Achievement through Language Acquisition at sala@fldoe.org.

Common Career Technical Core – Career Ready Practices

Career Ready Practices describe the career-ready skills that educators should seek to develop in their students.  These practices are not exclusive to a Career Pathway, program of study, discipline or level of education.  Career Ready Practices should be taught and reinforced in all career exploration and preparation programs with increasingly higher levels of complexity and expectation as a student advances through a program of study. 

1. Act as a responsible and contributing citizen and employee. 

2. Apply appropriate academic and technical skills. 

3. Attend to personal health and financial well-being. 

4. Communicate clearly, effectively and with reason. 

5. Consider the environmental, social and economic impacts of decisions. 

6. Demonstrate creativity and innovation. 

7. Employ valid and reliable research strategies. 

8. Utilize critical thinking to make sense of problems and persevere in solving them. 

9. Model integrity, ethical leadership and effective management. 

10. Plan education and career path aligned to personal goals. 

11. Use technology to enhance productivity. 

12. Work productively in teams while using cultural/global competence. 

Standards

Digital Information Technology (8207310) is the first course in this and other programs within the Information Technology Career Cluster.  Standards 01.0 – 14.0 are associated with this course.

After successfully completing this program, the student will be able to perform the following:

01.0	Demonstrate knowledge, skill, and application of information systems to accomplish job objectives and enhance workplace performance.
02.0	Develop an awareness of microprocessors and digital computers.
03.0	Demonstrate an understanding of operating systems.
04.0	Use technology to enhance the effectiveness of communication skills utilizing word processing applications.
05.0	Use technology to enhance communication skills utilizing presentation applications.
06.0	Use technology to enhance the effectiveness of communication utilizing spreadsheet and database applications.
07.0	Use technology to enhance communication skills utilizing electronic mail.
08.0	Investigate individual assessment and job/career exploration and individual career planning that reflect the transition from school to work, lifelong learning, and personal and professional goals.
09.0	Incorporate appropriate leadership and supervision techniques, customer service strategies, and standards of personal ethics to accomplish job objectives and enhance workplace performance.
10.0	Demonstrate competence using computer networks, internet and online databases to facilitate collaborative or individual learning and communication.
11.0	Demonstrate competence in page design applicable to the WWW.
12.0	Develop an awareness of emerging technologies.
13.0	Develop awareness of computer languages and software applications.
14.0	Demonstrate comprehension and communication skills.
15.0	Develop an awareness of the changes taking place in the information age and how they fit into an evolving society.  
16.0	Develop the "big picture" of database design and how to best organize data according to business rules and/or client needs. 
17.0	Develop the process of creating an entity by identifying relationships. 
18.0	Formulate and assemble initial entity relationship by expanding on modeling concepts. 
19.0	Consider the degree and optionality of relationships of entities. 
20.0	Demonstrate proficiency in early construction stages of the data modeling process by using unique identifiers and Many-to-Many (M:M) relationships for building entity relationship diagrams. 
21.0	Demonstrate proficiency in advanced data constructs by analyzing business requirements and diagramming entities and relationships. 
22.0	Demonstrate proficiency in designing and adding complexity to an entity relationship model (ERM). 
23.0	Apply the complex ERM information by fine tuning entities and the process for relating them. 
24.0	Apply initial database design and normalization by following the set of house rules that determine how items are stored and retrieved. 
25.0	Demonstrate proficiency in the technique of normalization by labeling and organizing all items in a database in such a way as to prevent any confusion of mistakes. 
26.0	Demonstrate proficiency in table normalization by combining the techniques of an entity relationship model or a top-down, business approach to data with normalization or a bottom-up mathematical approach to data. 
27.0	Apply blueprint principles to begin designing a tool for creating a web-based interface access to a database. 
28.0	Extend the ERM presentation model by normalizing the data and mapping the management system. 
29.0	Apply techniques for building a storage management system by creating a website using templates and wizards. 
30.0	Demonstrate storage closet design and functionality by constructing a group business presentation. 
31.0	Demonstrate comprehension of database modeling competency through group presentation. 
32.0	Demonstrate language arts knowledge and skills.
33.0	Demonstrate mathematics knowledge and skills.
34.0	Demonstrate comprehension that the database management software is a system for organizing the storage unit (or database) according to business needs and rules, through data integrity constraints. 
35.0	Demonstrate comprehension of aspects of SQL Language interface by writing basic SQL statements. 
36.0	Demonstrate proficiency working with columns, characters, and rows in SQL. 
37.0	Demonstrate proficiency in using SQL comparison operators. 
38.0	Demonstrate proficiency in using logical comparisons and precedence rules. 
39.0	Demonstrate proficiency using SQL single row functions.   
40.0	Demonstrate proficiency displaying data from multiple tables. 
41.0	Demonstrate proficiency aggregating data using GROUP functions. 
42.0	Demonstrate proficiency utilizing subqueries. 
43.0	Demonstrate proficiency producing readable output with SQL language interface, reporting tool and manipulating data. 
44.0	Demonstrate proficiency creating and managing database objects. 
45.0	Demonstrate proficiency altering tables and constraints implementing views. 
46.0	Demonstrate mastery of creating and implementing views, synonyms, indexes and other database objects. 
47.0	Demonstrate ability to control user access and SQL language interface and reporting tool. 
48.0	Demonstrate comprehension of bundling features of SQL. 
49.0	Demonstrate comprehension working with composite data types by writing executable script files. 
50.0	Describe the differences between SQL and PL/SQL 
51.0	Create PL/SQL blocks.
52.0	Use variables in PL/SQL.
53.0	Recognize lexical units.
54.0	Recognize data types.
55.0	Use scalar data types.
56.0	Use various types of joins.
57.0	Use SQL group functions and subqueries.
58.0	Write PL/SQL executable statements.
59.0	Use nested blocks and variable scope.
60.0	Use good programming practices.
61.0	Write DML statements to manipulate data.
62.0	Retrieve data using PL/SQL.
63.0	Manipulate data using PL/SQL.
64.0	Use transaction control statements.
65.0	Use IF conditional control statements.
66.0	Use CASE conditional control statements.
67.0	Use basic loop iterative control statements.
68.0	Use WHILE and FOR loop iterative control statements.
69.0	Use nested loop iterative control statements.
70.0	Use explicit cursors.
71.0	Use explicit cursor attributes.
72.0	Use cursor for loops.
73.0	Use cursors with parameters.
74.0	Use cursors for update transactions.
75.0	Use multiple cursors.
76.0	Handle exceptions.
77.0	Trap Oracle server exceptions.
78.0	Trap user-defined exceptions.
79.0	Create procedures.
80.0	Use parameters in procedures.
81.0	Pass parameters.
82.0	Create stored functions.
83.0	Use functions in SQL statements.
84.0	Manage procedures and functions.
85.0	Manage object privileges.
86.0	Use invoker’s rights.
87.0	Create packages.
88.0	Manage package constructs.
89.0	Use advanced package concepts.
90.0	Manage persistent state of package variables.
91.0	Use Oracle-supplied packages.
92.0	Understand dynamic SQL.
93.0	Understand triggers.
94.0	Create DML triggers.
95.0	Create DDL and database event triggers.
96.0	Manage triggers.
97.0	Use large object data types.
98.0	Manage BFILES.
99.0	Manage indexes.
100.0	Manage dependencies.
101.0	Use oral and written communication skills in creating, expressing and interpreting information and ideas.
102.0	Solve problems using critical thinking skills, creativity and innovation.
103.0	Use information technology tools.
104.0	Describe the roles within teams, work units, departments, organizations, interorganizational systems, and the larger environment.
105.0	Describe the importance of professional ethics and legal responsibilities.
106.0	Program a database application.
107.0	Utilize the basic concepts of database design.
108.0	Utilize SQL and UNION queries.
109.0	Implement program statements using objects.
110.0	Utilize debugging tools and write error handlers.
111.0	Demonstrate file I/O.
112.0	Create forms and identify all the properties of a form.
113.0	Manipulate data using object models
114.0	Develop custom controls.
115.0	Utilize API functions.
116.0	Demonstrate database replication and implement database replication using programming tools.
117.0	Analyze and implement security options.
118.0	Implement client/server applications.
119.0	Optimize the performance of a database.
120.0	Perform application distribution.
121.0	Test and debug databases.
122.0	Demonstrate the importance of health, safety, and environmental management systems in organizations and their importance to organizational performance and regulatory compliance. 
123.0	Demonstrate leadership and teamwork skills needed to accomplish team goals and objectives. 
124.0	Explain the importance of employability skill and entrepreneurship skills.

2017 – 2018
Florida Department of Education
Student Performance Standards

Course Title:		Digital Information Technology
Course Number:	8207310
Course Credit:	1

Course Description:

This course is designed to provide a basic overview of current business and information systems and trends, and to introduce students to fundamental skills required for today's business and academic environments.  Emphasis is placed on developing fundamental computer skills.  The intention of this course is to prepare students to be successful both personally and professionally in an information based society.  Digital Information Technology includes the exploration and use of: databases, the internet, spreadsheets, presentation applications, management of personal information and email, word processing and document manipulation, HTML, web page design, and the integration of these programs using software that meets industry standards.  After successful completion of this core course, students will have met Occupational Completion Point A, Information Technology Assistant - SOC Code 15-1151.

Digital Information Technology (8207310) is part of several programs across the various CTE career clusters.  To ensure consistency, the standards and benchmarks for this course (01.0 – 14.0) have been placed in a separate document.   To access this document, visit: Digital Information Technology (8207310).

2017 – 2018
Florida Department of Education
Student Performance Standards

Course Title: 	Database Fundamentals 
Course Number: 	8206410 
Course Credit:	.5

Course Description:

This data modeling course is designed to provide the foundation for future software engineers or database administrators.  It transforms business requirements into an operational database utilizing a top-down systematic approach.  Content includes creation of entity-relationship diagrams that accurately model an organization's needs and support the functions of a business, mapping of information needs into a relational database design, creation of physical relational database tables to implement database design, construction of a website that interacts with a database and generates report using web-based reports, and organization and composition of formal presentations, integrating multimedia software.

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

Note:  This course is pending alignment in the following categories:  NGSSS-Sci.

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
15.0	Develop an awareness of the changes taking place in the information age and how they fit into an evolving society. –  The student will be able to:			
15.01	Cite examples of jobs, salary, and opportunities he/she will have as a result of participating in the Academy.	LAFS.910.W.3.7,3.8,3.9
LAFS.1112.W.3.7,3.8,3.9
LAFS.910.L.3.6
LAFS.1112.L.3.6		
15.02	Describe the role a database plays in a business and predict its evolution.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5		
15.03	Demonstrate the difference between "data" and "information."	LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.4.10
LAFS.1112.W.4.10		
15.04	Understand the importance of clear communication when discussing business informational requirements.			
15.05	Identify important historical contributions in database development and design.	LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.L.3.6
LAFS.1112.L.3.6		
16.0	Develop the "big picture" of database design and how to best organize data according to business rules and/or client needs. –  The student will be able to:	LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.RI.4.10
LAFS.1112.RI.4.10
LAFS.910.L.3.6
LAFS.1112.L.3.6		
16.01	Identify and analyze the phases of the database development process.			
16.02	Explain what conceptual data modeling and database design involve.	LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.RI.4.10
LAFS.1112.RI.4.10
LAFS.910.L.3.6
LAFS.1112.L.3.6		
16.03	Compare database development process with that of the application development process.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6		
16.04	Distinguish between a conceptual model and a physical implementation.	LAFS.910.RI.4.10
LAFS.1112.RI.4.10
LAFS.910.L.3.6
LAFS.1112.L.3.6		
17.0	Develop the process of creating an entity by identifying relationships. –  The student will be able to:	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
17.01	Identify and model various types of entities.			
17.02	Identify naming and drawing conventions for entities.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
17.03	Sequence the steps that are necessary for creation of an entity.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
17.04	Analyze and model the relationships between entities.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
18.0	Formulate and assemble initial entity relationship by expanding on modeling concepts. –  The student will be able to:	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
18.01	Analyze and model attributes.			
18.02	Identify unique identifiers for each entity.	LAFS.910.W.3.7,3.8,2.4, 2.5,2.6
LAFS.1112.W.3.7,3.8,2.4,2.5,2.6
LAFS.910.SL.1.1,1.2,2.4,2.5
LAFS.1112.SL.1.1,1.2,2.42.5		
18.03	Develop an entity relationship diagram tagging attributes with optionality.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
19.0	Consider the degree and optionality of relationships of entities. –  The student will be able to:	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6		
19.01	Create entity relationship models based on information requirements and interviews.			
19.02	Differentiate between one-to-many, many-to-many and one-to-one relationships.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.3.7,3.8,3.9, 2.4,2.5
LAFS.1112.W.3.7,3.8,3.9,2.4,2.5		
19.03	Identify relationship between two entities by reading a given diagram.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.RI.3.10
LAFS.1112.RI.3.10		
19.04	Create a relationship between instances of the same entity.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
19.05	Read an entity relationship model in order to validate it.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.4,2.5,3.7, 3.8,3.9
LAFS.1112.W.2.4,2.5,3.7,3.8,3.9		
20.0	Demonstrate proficiency in early construction stages of the data modeling process by using unique identifiers and many-to-many (M:M) relationships for building entity relationship diagrams. –  The student will be able to:	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.RI.4.10
LAFS.1112.RI.4.10		
20.01	Identify the significance of an attribute that has more than one value for each entity instance.			
20.02	Evaluate appropriate methods of storing validation rules for attributes.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
20.03	Recognize unique identifiers inherited from other entities.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
20.04	Sequence the steps involved in resolving a many-to-many relationship.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
21.0	Demonstrate proficiency in advanced data constructs by analyzing business requirements and diagramming entities and relationships. –  The student will be able to:	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
21.01	Validate that an attribute is properly placed based upon its dependence on its entity's unique identifier (UID).			
21.02	Resolve many-to-many relationships with intersection entities.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
21.03	Model advanced data constructs including recursive relationships, subtypes, and exclusive relationships.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
21.04	Create exclusive entities and relationships by using subtypes and arcs, respectively.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6
MAFS.912.S-ID.2.6		
21.05	Identify initial layout for presentation and generate a list of action items for members of group.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
21.06	Develop an entity relationship model using subtypes, supertypes and an exclusive arc.	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
22.0	Demonstrate proficiency in designing and adding complexity to an Entity – Relationship Model (ERM). –  The student will be able to:	LAFS.910.SL.1.1,2.4,2.5
LAFS.1112.SL.1.1,2.4,2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
22.01	Revise an entity relationship model according to the diagramming techniques covered in this course.			
22.02	Define and give examples of hierarchical and recursive relationships.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,2.5,2.4
LAFS.1112.W.2.6,2.5,2.4		
22.03	Differentiate between transferable and non-transferable relationships.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.L.3.6
LAFS.1112.L.3.6		
22.04	Deliver a professional, formal business style presentation.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.L.3.6
LAFS.1112.L.3.6		
22.05	Evaluate and critique presentation layout, design and performance.	LAFS.910.SL.1.2,1.3,2.4,2.5,2.6
LAFS.1112.SL.1.2,1.3,2.42.5,2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,2.5,2.4, 3.7,3.8,3.9
LAFS.1112.W.2.6,2.5,2.43.7,3.8,3.9		
22.06	Construct a model using both recursion and hierarchies to express the same conceptual meaning.	LAFS.910.SL.1.2,1.3,2.4,2.5,2.6
LAFS.1112.SL.1.2,1.3,2.42.5,2.6 
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,2.5,2.4, 3.7,3.8,3.9
LAFS.1112.W.2.6,2.5,2.4,3.7,3.8,3.9		
22.07	Distinguish between using date as an attribute and DAY as an entity.	LAFS.910.SL.1.2,1.3,2.4,2.5,2.6
LAFS.1112.SL.1.2,1.3, 2.4,2.5,2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,2.5,2.4, 3.7,3.8,3.9
LAFS.1112.W.2.6,2.5,2.4,3.7,3.8,3.9		
23.0	Apply complex ERM information by fine-tuning entities and the process for relating them. –  The student will be able to:	LAFS.910.SL.1.2,1.3,2.4,2.5,2.6
LAFS.1112.SL.1.2,1.3, 2.4, 2.5, 2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,2.5,2.4, 3.7,3.8,3.9
LAFS.1112.W.2.6,2.5,2.4,3.7,3.8,3.9		
23.01	Describe a relational database and how it differs from other database systems.			
23.02	Define primary keys and foreign keys and describe their purpose.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.L.3.6
LAFS.1112.L.3.6		
23.03	Describe what data integrity refers to and list some constraints.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.L.3.6
LAFS.1112.L.3.6		
23.04	Explain how database design fits into the database development process.	LAFS.910.SL.1.1, 1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.L.3.6
LAFS.1112.L.3.6		
23.05	Translate an entity-relationship model into a relational database design.	LAFS.910.SL.1.1, 1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.L.3.6
LAFS.1112.L.3.6		
23.06	Document a database design using table instance charts.	LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.RI.3.7
LAFS.1112.RI.3.7		
24.0	Apply initial database design and normalization by following the set of house rules that determine how items are stored and retrieved. –  The student will be able to:	LAFS.910.W.4.10,3.7,3.8,3.9,2.6,2.5,2.4
LAFS.1112.W.4.10,3.7, 3.8,3.9,2.6,2.5,2.4		
24.01	Demonstrate ability to implement six steps for mapping entity relationship models.			
24.02	Document an initial database design on table instance charts.	LAFS.910.W.4.10,3.7,3.8,3.9,2.6,2.5,2.4
LAFS.1112.W.4.10,3.7,3.8,3.9,2.6,2.5,2.4		
24.03	Recognize raw data and evaluate the steps for creating a data group in unnormalized form.	LAFS.910.W.4.10,3.7,3.8,3.9,2.6,2.5,2.4
LAFS.1112.W.4.10,3.7,3.8,3.9,2.6,2.5,2.4		
25.0	Demonstrate proficiency in the technique of normalization by labeling and organizing all items in a database in such a way as to prevent any confusion or mistakes. –  The student will be able to:	LAFS.910.W.4.10,3.7,3.8,3.9,2.6,2.5,2.4
LAFS.1112.W.4.10,3.7,3.8,3.9,2.6,2.5,2.4		
25.01	Differentiate between unnormalized data and normalized.			
25.02	Move data from an unnormalized form through to a third normal form.	LAFS.910.W.3.7,3.8,3.9
LAFS.1112.W.3.7,3.8,3.9
LAFS.910.L.1.1,1.2,3.6
LAFS.1112.L.1.1,1.2,3.6		
25.03	Demonstrate ability to test data groups for third normal form compliance.	LAFS.910.W.3.7,3.8,3.9
LAFS.1112.W.3.7,3.8,3.9
LAFS.910.L.1.1,1.2,3.6
LAFS.1112.L.1.1,1.2,3.6		
25.04	Identify optimized data groups from given groups of normalized data.	LAFS.910.W.3.7,3.8,3.9
LAFS.1112.W.3.7,3.8,3.9
LAFS.910.L.1.1,1.2,3.6
LAFS.1112.L.1.1,1.2,3.6		
26.0	Demonstrate proficiency in table normalization by combining the techniques of an entity relationship model or a top-down, business approach to data with normalization or a bottom-up mathematical approach to data. –  The student will be able to:	LAFS.910.W.3.7,3.8,3.9
LAFS.1112.W.3.7,3.8,3.9
LAFS.910.L.1.1,1.2,3.6
LAFS.1112.L.1.1,1.2,3.6
MAFS.K12.MP.8.1		
26.01	Compare the normalization and entity relationship modeling (ERM) techniques in terms of strengths and weaknesses.			
26.02	Further define normalization and explain its benefits.	LAFS.910.W.3.7,3.8,3.9
LAFS.1112.W.3.7,3.8,3.9
LAFS.910.L.1.1,1.2,3.6
LAFS.1112.L.1.1,1.2,3.6		
26.03	Place tables in third normal form.	LAFS.910.W.3.7,3.8,3.9
LAFS.1112.W.3.7,3.8,3.9
LAFS.910.L.1.1,1.2,3.6
LAFS.1112.L.1.1,1.2,3.6		
26.04	Explain how conceptual data modeling rules ensure normalized tables.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
26.05	Specify referential integrity constraints and design indexes.			
27.0	Apply blueprint principles to begin designing a tool for creating a web-based interface access to a database. –  The student will be able to:	LAFS.910.SL.1.2
LAFS.1112.SL.1.2
LAFS.910.L.3.6
LAFS.1112.L.3.6		
27.01	Evaluate the transformation of business requirements into an initial layout and design for a database.			
27.02	Construct simple web page design for personal work folder.	LAFS.910.SL.1.2,2.4,2.5,2.6
LAFS.1112.SL.1.2,,2.4, 2.5, 2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,2.5,2.4, 3.7,3.8,3.9
LAFS.1112.W.2.6,2.5,2.4,3.7,3.8,3.9		
27.03	Evaluate existing web sites and determine quality of design.	LAFS.910.SL.1.2,2.4,2.5,2.6
LAFS.1112.SL.1.2,,2.4, 2.5,2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,2.5,2.4, 3.7,3.8,3.9
LAFS.1112.W.2.6,2.5,2.4,3.7,3.8,3.9		
28.0	Extend the ERM presentation model by normalizing the data and mapping the management system. –  The student will be able to:	LAFS.910.SL.1.2,2.4,2.5,2.6
LAFS.1112.SL.1.2,,2.4, 2.5,2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,2.5,2.4, 3.7,3.8,3.9
LAFS.1112.W.2.6,2.5,2.4,3.7,3.8,3.9		
28.01	Formulate a plan of action for the Database Project using skills previously learned in this course.			
28.02	Normalize an ERM to the third normal form (3NF).	LAFS.910.SL.1.2,2.4,2.5,2.6
LAFS.1112.SL.1.2, 2.4 2.5,2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
28.03	Create a table in the database using a database authoring tool.			
28.04	Demonstrate ability to edit tables using a database authoring tool.			
28.05	Create forms that will display the table components created with a database authoring tool.	LAFS.910.SL.1.1,2.4,2.5,
LAFS.1112.SL.1.1,2.4, 2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,4.10
LAFS.1112.W.2.6,4.10		
29.0	Apply techniques for building a storage management system by creating a website using templates and wizards. –  The student will be able to:	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,4.10
LAFS.1112.W.2.6,4.10		
29.01	Create a web site that displays the database project home.			
29.02	Link a web site to create a web-enabled interface to the industry database.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,4.10
LAFS.1112.W.2.6,4.10		
29.03	Edit the forms created and specify appropriate field labels for data entry.			
30.0	Demonstrate storage closet design and functionality by constructing a group business presentation. –  The student will be able to: 	LAFS.910.W.2.5,4.10
LAFS.1112.W.2.5,4.10		
30.01	Evaluate and generate criteria for a formal, business presentation.			
30.02	Construct a persuasive group presentation using the guidelines set forth in class.	LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.W.2.6,3.8,3.9
LAFS.1112.W.2.6,3.8,3.9		
31.0	Demonstrate comprehension of database modeling competency through group presentation. –  The student will be able to:	LAFS.910.SL. 1.1,2.4, 2.5,2.6
LAFS.1112.SL. 1.1,2.4, 2.5,2.6
LAFS.910.W.3.7,3.8,3.9
LAFS.1112.W.3.7,3.8,3.9		
31.01	Deliver a formal business presentation for the class that discusses an entity-relationship model and initial database design.			
31.02	Demonstrate the functionality of the database and the layout/design capabilities of a database authoring tool.	LAFS.910.SL.2.4,2.5,2.6,1.1
LAFS.1112.SL. 1.1,2.4, 2.5,2.6		
31.03	Self-assess learning experience through the presentation and demonstration of their final database project.	LAFS.910.SL.1.1,2.4,2.5,
LAFS.1112.SL.1.1, 2.4, 2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,4.10
LAFS.1112.W.2.6,4.10		
32.0	Demonstrate language arts knowledge and skills. –  The student will be able to:	LAFS.910.SL.1.1,2.4,2.5,
LAFS.1112.SL.1.1,2.4, 2.5
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6,4.10
LAFS.1112.W.2.6,4.10		
32.01	Locate, comprehend and evaluate key elements of oral and written information.			
32.02	Draft, revise, and edit written documents using correct grammar, punctuation and vocabulary.	LAFS.910.SL.1.2,1.3
LAFS.1112.SL.1.2,1.3
LAFS.910.W.2.4,2.5,2.6, 3.7,3.8,3.9
LAFS.1112.W.2.6,2.4,2.5,3.8,3.7,3.9		
32.03	Present information formally and informally for specific purposes and audiences.	LAFS.910.L.1.1,1.2
LAFS.1112.L.1.1,1.2
LAFS.910.W. 2.4,2.5, 2.6
LAFS.1112.W. 2.4,2.5, 2.6		
33.0	Demonstrate mathematics knowledge and skills. –  The student will be able to:	LAFS.910.SL.2.4,2.5,2.6
LAFS.1112.SL.2.4,2.5,2.6
LAFS.910.W.3.7,3.8,3.9
LAFS.1112.W.3.8,3.7,3.9		
33.01	Demonstrate knowledge of arithmetic operations.			
33.02	Analyze and apply data and measurements to solve problems and interpret documents.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
33.03	Construct charts/tables/graphs using functions and data.	LAFS.910.W.4.10
LAFS.1112.W.4.10
MAFS.912.F-BF.1.1		

2017 – 2018
Florida Department of Education
Student Performance Standards

Course Title: 	Data and Control Functions
Course Number: 	8206420
Course Credit:	.5

Course Description:

This course introduces data-server technology.  Structured Query Language (SQL) is the standardized language that creates a medium for companies to compete in the building of databases or data management systems.  Content of this course includes creation and maintenance of database objects and storage, retrieval and manipulation of data using SQL and Programming Language (PL) PL/SQL programming languages.  At the completion of Database Fundamentals and Data Control and Functions, students will be able to create blocks of application code that can be shared by multiple forms, reports and data management applications and to sit for the first of two certification exams.

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

Note:  This course is pending alignment in the following categories:  NGSSS-Sci.

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
34.0	Demonstrate comprehension that the database management software is a system for organizing the storage unit (or database) according to business needs and rules, through data integrity constraints. –  The student will be able to:			
34.01	Identify the structural elements of a relational database table.	LAFS.910.W.4.10
LAFS,1112.W.4.10
LAFS.910.R.I.4.10
LAFS.112.R.I.4.10
LAFS.910.L.3.6
LAFS.1112.L.3.6		
34.02	List and describe the system development life cycle.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910,SL.2.5
LAFS.1112.SL.2.5		
34.03	Describe the industry implementation of the relational database management system (RDBMS) and object relational database management system (ORDBMS).	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910,SL.2.5
LAFS.1112.SL.2.5		
34.04	Explain how SQL and languages that extend SQL are used in the industry product set.  	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910,SL.2.5
LAFS.1112.SL.2.5		
34.05	Identify the advantages of a database management system.	LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.R.I.4.10
LAFS.112.R.I.4.10
LAFS.910.L.3.6
LAFS.112.L.3.6		
35.0	Demonstrate comprehension of aspects of SQL language interface by writing basic SQL statements. –  The student will be able to:			
35.01	List the capabilities of SQL SELECT statements. 			
35.02	Execute a basic select statement.			
35.03	Differentiate between SQL statements and language commands that extend SQL.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.RI.4.10
LAFS.1112.RI.4.10		
36.0	Demonstrate proficiency working with columns, characters, and rows in SQL. –  The student will be able to:			
36.01	Apply the concatenation operator to link columns to other columns, arithmetic expressions, or constant values to create a character expression. 			
36.02	Use column aliases to rename columns in the query result.			
36.03	Eliminate duplicate rows in the query result.			
36.04	Display the structure of a table.			
36.05	Apply SQL syntax to restrict the rows returned from a query.			
36.06	Demonstrate application of the WHERE clause syntax.	LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.4.10
LAFS.1112.W.4.10		
36.07	Construct and produce output using a SQL query containing character strings and date values.			
37.0	Demonstrate proficiency in using SQL comparison operators. –  The student will be able to:			
37.01	Apply the proper comparison operator to return a desired result. 			
37.02	Demonstrate proper use of BETWEEN, IN, and LIKE conditions to return a desired result.			
37.03	Distinguish between zero and the value of NULL as unavailable, unassigned, unknown, or inapplicable.			
37.04	Explain the use of comparison conditions and NULL.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910,SL.2.5
LAFS.1112.SL.2.5		
38.0	Demonstrate proficiency in using logical comparisons and precedence rules. –  The student will be able to:			
38.01	Evaluate logical comparisons to restrict the rows returned based on two or more conditions. 	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910,SL.2.5
LAFS.1112.SL.2.5		
38.02	Apply the rules of precedence to determine the order in which expressions are evaluated and calculated. 			
38.03	Construct a query to order a results set for single or multiple columns.			
38.04	Construct a query to sort a results set in ascending or descending order. 			
39.0	Demonstrate proficiency using SQL single row functions. –  The student will be able to:			
39.01	Perform calculations on data.			
39.02	Modify individual data items.			
39.03	Use character, number and date functions in SELECT statements.			
39.04	Format data and numbers for display purposes.			
39.05	Convert column data types.			
40.0	Demonstrate proficiency displaying data from multiple tables. –  The student will be able to:			
40.01	Construct select statements to access data from more than one table using quality and non-equality joins. 			
40.02	Use outer joins through viewing data that generally does not meet a join condition. 			
40.03	Join a table to itself.			
41.0	Demonstrate proficiency aggregating data using GROUP functions. –  The student will be able to:			
41.01	Identify the available group functions and describe their use.	LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.R.I.4.10
LAFS.112.R.I.4.10
LAFS.910.L.3.6
LAFS.1112.L.3.6		
41.02	Demonstrate the ability to group data through the use of the GROUP BY clause.	LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.R.I.4.10
LAFS.112.R.I.4.10		
41.03	Demonstrate the ability to include or exclude grouped rows by using the HAVING clause.	LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.R.I.4.10
LAFS.112.R.I.4.10		
42.0	Demonstrate proficiency utilizing subqueries. –  The student will be able to:			
42.01	Write a query with an embedded subquery.	LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.R.I.4.10
LAFS.112.R.I.4.10		
42.02	Evaluate and perform a multiple-column subquery.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910,SL.2.5
LAFS.1112.SL.2.5		
42.03	Describe and explain the behavior of subqueries when null values are retrieved.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910,SL.2.5
LAFS.1112.SL.2.5		
42.04	Create a subquery in a FROM clause.	LAFS.910.W.2.4
LAFS.1112.W.2.4
LAFS.910.W.2.5
LAFS.1112.W.2.5
LAFS.910.W.3.7
LAFS.1112.W.3.7
LAFS.910.W.3.8
LAFS.1112.W.3.8
LAFS.910.W.3.9
LAFS.1112.W.3.9
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.1.2
LAFS.1112.SL.1.2		
43.0	Demonstrate proficiency producing readable output with SQL language interface, reporting tool, and data manipulation language. –  The student will be able to:			
43.01	Produce queries that require an input variable.			
43.02	Customize the SQL language interface and reporting environment using SET commands for control.			
43.03	Produce more readable output through the use of the column and break commands.			
43.04	Describe data manipulation language (DML) and describe various DML statements.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910,SL.2.5
LAFS.1112.SL.2.5		
43.05	Utilize data manipulation language (DML) through inserting, updating and deleting rows from a table.			
43.06	Control transactions using COMMIT and ROLLBACK statements.			
44.0	Demonstrate proficiency creating and managing database objects. –  The student will be able to:			
44.01	Describe the main database objects.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910,SL.2.5
LAFS.1112.SL.2.5		
44.02	Create tables and alter their definitions.			
44.03	Describe the data types that can be used when specifying column definition.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910,SL.2.5
LAFS.1112.SL.2.5		
45.0	Demonstrate proficiency altering tables and constraints implementing views. –  The student will be able to:			
45.01	Create, drop, rename and truncate tables using SQL.			
45.02	Identify and describe various constraints including not null, unique, primary key, foreign key, and check.	LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.R.I.4.10
LAFS.112.R.I.4.10
LAFS.910.L.3.6
LAFS.1112.L.3.6		
45.03	Create and maintain constraints including adding, dropping, enabling, disabling, and cascading.	LAFS.910.W.2.4
LAFS.1112.W.2.4
LAFS.910.W.2.5
LAFS.1112.W.2.5
LAFS.910.W.3.7
LAFS.1112.W.3.7
LAFS.910.W.3.8
LAFS.1112.W.3.8
LAFS.910.W.3.9
LAFS.1112.W.3.9
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.1.2
LAFS.1112.SL.1.2		
45.04	Recognize views and explain how they are created, how they retrieve data and how they perform DML operations.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.SL.2.5
LAFS.1112.SL.2.5		
46.0	Demonstrate mastery of creating and implementing views, synonyms, indexes and other database objects. –  The student will be able to:			
46.01	Create views, retrieve data through a view, alter the definition of a view and drop a view. 	LAFS.910.W.2.4
LAFS.1112.W.2.4
LAFS.910.W.2.5
LAFS.1112.W.2.5
LAFS.910.W.3.7
LAFS.1112.W.3.7
LAFS.910.W.3.8
LAFS.1112.W.3.8
LAFS.910.W.3.9
LAFS.1112.W.3.9
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.1.2
LAFS.1112.SL.1.2		
46.02	Categorize information by using Top-N queries to retrieve specified data.			
46.03	Identify the features of a sequence and display sequence values using a data dictionary view.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.SL.1.1.
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.SL.2.5
LAFS.1112.SL.2.5
LAFS.910.SL.2.6
LAFS.1112.SL.2.6		
46.04	Identify the characteristics of a cached sequence.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.SL.2.5
LAFS.1112.SL.2.5
LAFS.910.SL.2.6
LAFS.1112.SL.2.6		
46.05	Modify and remove a sequence using a SQL statement.			
46.06	Identify the features of private and public synonyms.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.SL.2.5
LAFS.1112.SL.2.5
LAFS.910.SL.2.6
LAFS.1112.SL.2.6		
46.07	Identify characteristics of an index and describe different types.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.SL.2.5
LAFS.1112.SL.2.5
LAFS.910.SL.2.6
LAFS.1112.SL.2.6		
46.08	Create and remove an index using a SQL statement.			
47.0	Demonstrate ability to control user access and SQL language interface and reporting tool. –  The student will be able to:			
47.01	Identify the features of database security.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.SL.2.5
LAFS.1112.SL.2.5		
47.02	Create users using SQL statements.			
47.03	Grant and revoke object privileges using a SQL language interface and reporting tool.			
48.0	Demonstrate comprehension of bundling features of SQL. –  The student will be able to:			
48.01	List and describe the benefits of extensions to SQL.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.SL.2.5
LAFS.1112.SL.2.5		
48.02	Recognize the basic SQL block and its sections.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.SL.2.5
LAFS.1112.SL.2.5		
48.03	Declare SQL variables and describe their significance.			
48.04	Execute a SQL block.			
49.0	Demonstrate comprehension working with composite data types by writing executable script files. –  The student will be able to:			
49.01	Recognize the significance of the executable section and decide when to use it.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.SL.2.6
LAFS.1112.SL.2.6		
49.02	Write statements in the executable section.	LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.W.4.10
LAFS.1112.W.4.10		
49.03	Describe the rules of nested blocks.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.2.4
LAFS.1112.SL.2.4
LAFS.910.SL.2.5
LAFS.1112.SL.2.5		
49.04	Identify and utilize appropriate coding conventions.	LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.R.I.4.10
LAFS.112.R.I.4.10
LAFS.910.L.3.6
LAFS.1112.L.3.6		
49.05	Create a script that will insert, update, merge and delete data in a table.	LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.W.3.7
LAFS.1112.W.3.7
LAFS.910.W.3.8
LAFS.1112.W.3.8
LAFS.910.W.3.9
LAFS.1112.W.3.9
LAFS.910.W.4.10
LAFS.1112.W.4.10		

2017 – 2018
Florida Department of Education
Student Performance Standards

Course Title: 	Specialized Database Programming
Course Number: 	8206430
Course Credit:	1 

Course Description:

This course covers PL/SQL, a procedural language extension to SQL.  Through an innovative project-based approach, students learn procedural logic constructs such as variables, constants, conditional statements, and iterative controls.  After completing this course, the student will have the opportunity to sit for the second of two exams required to earn the Oracle Certified Associate certification and the student will be able to:

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

Note:  This course is pending alignment in the following categories:  NGSSS-Sci.

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
50.0	Describe the differences between SQL and PL/SQL. –  The student will be able to:  			
50.01	Describe PL/SQL.	LAFS.910.SL.1.1
LASF.1112.SL.1.1
LAFS.910.RI.2.4
LAFS.1112.RI.2.4		
50.02	Differentiate between SQL and PL/SQL.	LAFS.910.SL.1.1
LASF.1112.SL.1.1		
50.03	Explain the need for and benefits of PL/SQL.	LAFS.910.SL.1.2
LASF.1112.SL.1.2		
51.0	Create PL/SQL blocks. –  The student will be able to:			
51.01	Describe the structure of a PL/SQL block.	LAFS.910.SL.1.1
LASF.1112.SL.1.1		
51.02	Identify the different types of PL/SQL blocks.	LAFS.910.SL.1.1
LASF.1112.SL.1.1		
51.03	Identify PL/SQL programming environments.	LAFS.910.SL.1.1
LASF.1112.SL.1.1
LAFS.910.RI.2.4
LAFS.1112.RI.2.4		
51.04	Create and execute an anonymous block.			
51.05	Output messages in PL/SQL.			
52.0	Use variables in PL/SQL. –  The student will be able to:			
52.01	Describe how variables are used in PL/SQL.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
52.02	Identify the syntax for using variables.	LAFS.910.L.1.1
LAFS.1112.L.1.1		
52.03	Declare and initialize variables.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
52.04	Assign new values to variables.			
53.0	Recognize lexical units. –  The student will be able to:			
53.01	Describe the types of lexical units in PL/SQL.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.W.4.10
LAFS.1112.W.4.10
		
53.02	Describe identifiers and identify valid and invalid identifiers.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.W.4.10
LAFS.1112.W.4.10		
53.03	Describe and identify reserved words, delimiters, literals, and comments.	LAFS.910.RI.2.4
LAFS.1112.RI.2.4		
54.0	Recognize data types. –  The student will be able to:			
54.01	Describe the data type categories.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
54.02	Give examples of scalar, composite, and large object (LOB) data types.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
54.03	Identify when an object becomes eligible for garbage collection.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
55.0	Use scalar data types. –  The student will be able to:			
55.01	Declare and use scalar data types.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.SL.1.2
LAFS.1112.SL.1.2
MAFS.912.CN.2.5		
55.02	Define guidelines for declaring and initializing variables.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
55.03	Describe the benefits of anchoring data types with the %TYPE attribute.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1 		
56.0	Use various types of joins. –  The student will be able to:			
56.01	Construct and execute SELECT statements using an equijoin.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
56.02	Construct and execute SELECT statements using a non-equijoin.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
56.03	Construct and execute SELECT statements using an outer join.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
56.04	Construct and execute SELECT statements that result in a Cartesian product.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
57.0	Use SQL group functions and subqueries. –  The student will be able to:			
57.01	Construct and execute an SQL query using group functions to determine a sum total, an average amount, and a maximum value.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
57.02	Construct and execute an SQL query that groups data based on specified criteria.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
57.03	Construct and execute an SQL query that contains a WHERE clause using a single-row subquery.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
57.04	Construct and execute an SQL query that contains a WHERE clause using a multiple-row subquery.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
58.0	Write PL/SQL executable statements. –  The student will be able to:			
58.01	Construct variable assignment statements.	LAFS.910.W.2.6
LAFS.1112.W.2.6
MAFS.912.MP.1.2		
58.02	Construct statements using built-in SQL functions.	LAFS.910.W.2.6
LAFS.1112.W.2.6
MAFS.912.MP.1.2		
58.03	Differentiate between implicit and explicit data type conversions.	LAFS.910.RI.2.4
LAFS.1112.RI.2.4
LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
58.04	Describe when implicit data type conversions take place.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.W.4.10
LAFS.1112.W.4.10		
58.05	List the drawbacks of implicit data type conversions.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.W.4.10
LAFS.1112.W.4.10		
58.06	Construct statements using functions to explicitly convert data types.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
58.07	Construct statements using operators.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
59.0	Use nested blocks and variable scope. –  The student will be able to:			
59.01	Understand the scope and visibility of variables.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
59.02	Write nested blocks and qualify variables with labels.	LAFS.910.SL.2.5
LAFS.1112.SL.2.5		
59.03	Describe the scope of an exception.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.W.4.2
LAFS.1112.W.4.2		
59.04	Describe the effect of exception propagation in nested blocks.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.W.4.2
LAFS.1112.W.4.2		
60.0	Use good programming practices. –  The student will be able to:			
60.01	List examples of good programming practices.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
60.02	Insert comments into PL/SQL code.	LAFS.910.L.1.1,2.6
LAFS.1112.L.1.1,2.6		
60.03	Follow formatting guidelines when writing code.			
61.0	Write DML statements to manipulate data. –  The student will be able to:			
61.01	Construct and execute a DML statement to insert data into a table.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
61.02	Construct and execute a DML statement to update data in a table.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
61.03	Construct and execute a DML statement to delete data from a table.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
61.04	Construct and execute a DML statement to merge data into a table.	LAFS.910.L.2.3
LAFS.1112.L.2.3		
62.0	Retrieve data using PL/SQL. –  The student will be able to:			
62.01	Identify SQL statements that can be directly included in an executable block.	LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
62.02	Construct and execute an INTO clause to hold values returned by a single-row SELECT statement.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
62.03	Construct statements that retrieve data.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
63.0	Manipulate data using PL/SQL. –  The student will be able to:			
63.01	Construct and execute PL/SQL statements that manipulate data with DML statements.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
63.02	Describe when to use implicit or explicit cursors.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
63.03	Create code to use SQL implicit cursor attributes to evaluate cursor activity.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
64.0	Use transaction control statements. –  The student will be able to:			
64.01	Define a transaction and give an example.	LAFS.910.L.3.6
LAFS.1112.L.3.6		
64.02	Construct and execute a transaction control statement.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
65.0	Use IF conditional control statements. –  The student will be able to:			
65.01	Construct and use an IF statement.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
65.02	Construct and use an IF -ELSIF statement.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
65.03	Create PL/SQL to handle null conditions in an IF statement.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
66.0	Use CASE conditional control statements. –  The student will be able to:			
66.01	Construct and use CASE statements.			
66.02	Construct and use CASE expressions.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
66.03	Include syntax to handle null conditions in a CASE statement.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
66.04	Include syntax to handle Boolean conditions in IF and CASE statements.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
67.0	Use basic LOOP iterative control statements. –  The student will be able to:			
67.01	Describe the types of LOOP statements and their uses.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
67.02	Create PL/SQL containing a basic loop and an EXIT statement.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
67.03	Create PL/SQL containing a basic loop and an EXIT statement with conditional termination.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
68.0	Use WHILE and FOR loop iterative control statements. –  The student will be able to:			
68.01	Construct and use the WHILE looping construct.			
68.02	Construct and use the FOR looping construct.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
68.03	Describe when a WHILE loop is used.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
68.04	Describe when a FOR loop is used.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
69.0	Use nested loop iterative control statements. –  The student will be able to:			
69.01	Construct and execute PL/SQL using nested loops.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
69.02	Evaluate a nested loop construct and identify the exit point.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
70.0	Use explicit cursors. –  The student will be able to:			
70.01	List the guidelines for declaring and controlling explicit cursors.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
70.02	Create PL/SQL code to open a cursor and fetch a piece of data into a variable.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
70.03	Use a simple loop to fetch multiple rows from a cursor.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
70.04	Create PL/SQL code to close a cursor.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
71.0	Use explicit cursor attributes. –  The student will be able to:			
71.01	Define a record structure using the %ROWTYPE attribute.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
71.02	Create PL/SQL code to process the row of an active set using record types in cursors.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
71.03	Use cursor attributes to retrieve information about the state of an explicit cursor.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
72.0	Use cursor FOR loops. –  The student will be able to:			
72.01	List and explain the benefits of using cursor FOR loops.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
72.02	Create PL/SQL code to declare a cursor and manipulate it in a FOR loop.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
72.03	Create PL/SQL code containing a cursor FOR loop using a subquery.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
73.0	Use cursors with parameters. –  The student will be able to:			
73.01	List the benefits of using parameters with cursors.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
73.02	Create PL/SQL code to declare and manipulate a cursor with a parameter.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6
LAFS.1112.W.2.6		
74.0	Use cursors for UPDATE transactions. –  The student will be able to:			
74.01	Create PL/SQL code to lock rows before an update using the appropriate clause.	
		
74.02	Explain the effect of using NOWAIT in an update cursor declaration.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1
		
74.03	Create PL/SQL code to use the current row of the cursor in an UPDATE or DELETE statement.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
75.0	Use multiple cursors. –  The student will be able to:			
75.01	Explain the need for using multiple cursors to produce multilevel reports.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
75.02	Create PL/SQL code to declare and manipulate multiple cursors within nested loops.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
75.03	Create PL/SQL code to declare and manipulate multiple cursors using parameters.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
76.0	Handle exceptions. –  The student will be able to:			
76.01	Describe the advantages of including exception handling code.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
76.02	Describe the purpose of an EXCEPTION section in a PL/SQL block.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
76.03	Create PL/SQL code to include an EXCEPTION section.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
76.04	List the guidelines for exception handling.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
77.0	Trap Oracle server exceptions. –  The student will be able to:			
77.01	Distinguish between errors defined by the Oracle Server and those defined by the programmer.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
77.02	Differentiate between errors that are handled implicitly and explicitly by the Oracle Server.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
77.03	Write PL/SQL code to trap a predefined Oracle Server error.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
77.04	Write PL/SQL code to trap a non-predefined Oracle Server error.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
77.05	Write PL/SQL code to identify an exception by error code and by error message.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
78.0	Trap user-defined exceptions. –  The student will be able to:			
78.01	Write PL/SQL code to name a user-defined exception.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
78.02	Write PL/SQL code to raise an exception.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
78.03	Write PL/SQL code to handle a raised exception.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
78.04	Write PL/SQL code to use RAISE_APPLICATION_ERROR.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
79.0	Create procedures. –  The student will be able to:			
79.01	Differentiate between anonymous blocks and subprograms.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
79.02	Identify the benefits of using subprograms.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
79.03	Describe a stored procedure.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
79.04	Create a procedure.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
79.05	Describe how a stored procedure is invoked.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
80.0	Use parameters in procedures. –  The student will be able to:			
80.01	Describe how parameters contribute to a procedure.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
80.02	Define a parameter.	LAFS.910.L.3.6
LAFS.1112.L.3.6		
80.03	Create a procedure using a parameter.	LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.W.4.10
LAFS.1112.W.4.10		
80.04	Invoke a procedure that has parameters.	LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.W.4.10
LAFS.1112.W.4.10		
80.05	Distinguish between formal and actual parameters.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
81.0	Pass parameters. –  The student will be able to:			
81.01	List the types of parameter modes.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
81.02	Create a procedure that passes parameters.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
81.03	Identify three methods for passing parameters.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
81.04	Describe the DEFAULT option for parameters.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
82.0	Create stored functions. –  The student will be able to:			
82.01	Describe the difference between a stored procedure and a stored function.			
82.02	Create a PL/SQL block containing a function.	LAFS.910.W.2.6
LAFS.1112.W.2.6
LAFS.910.W.4.10
LAFS.1112.W.4.10		
82.03	Identify ways in which functions may be invoked.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
82.04	Create a PL/SQL block that invokes a function that has parameters.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
83.0	Use functions in SQL statements. –  The student will be able to:	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
83.01	Describe where user-defined functions can be called from within an SQL statement.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
83.02	Describe the restrictions on calling functions from SQL statements.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
83.03	Describe the purpose of the Data Dictionary.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
83.04	Differentiate between the three types of Data Dictionary views.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
83.05	Write SQL SELECT statements to retrieve information from the Data Dictionary.	
LAFS.910.W.4.10
LAFS.1112.W.4.10		
83.06	Explain the use of DICTIONARY as a Data Dictionary search engine.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
84.0	Manage procedures and functions. –  The student will be able to:			
84.01	Describe how exceptions are propagated.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
84.02	Remove a function and a procedure.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
84.03	Use Data Dictionary views to identify and manage stored procedures.			
85.0	Manage object privileges. –  The student will be able to:			
85.01	List and explain several object privileges.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
85.02	Explain the function of the EXECUTE object privilege.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
85.03	Write SQL statements to grant and revoke object privileges.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
86.0	Use invoker’s rights. –  The student will be able to:			
86.01	Contrast invoker’s rights with definer’s rights.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
86.02	Create a procedure that uses invoker’s rights.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
87.0	Create packages. –  The student will be able to:			
87.01	Describe a package, its components, and the reasons for use.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
87.02	Create packages containing related variables, cursors, constants, exceptions, procedures, and functions.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
87.03	Create a PL/SQL block that invokes a package construct.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
88.0	Manage package constructs. –  The student will be able to:			
88.01	Explain the difference between public and private package constructs.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1
LAFS.910.W.2.6
LAFS.1112.W.2.6		
88.02	Designate a package construct as either public or private.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
88.03	Specify the syntax to drop a package.	LAFS.910.L.1.1
LAFS.1112.L.1.1		
88.04	Identify Data Dictionary views used to manage packages.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
88.05	Identify the guidelines for using packages.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
89.0	Use advanced package concepts. –  The student will be able to:			
89.01	Write packages that use the overloading feature.			
89.02	Write packages that use forward declarations.			
89.03	Explain the purpose of a package initialization block.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
89.04	Identify restrictions on using packaged functions in SQL statements.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
90.0	Manage persistent state of package variables. –  The student will be able to:			
90.01	Identify persistent states of package variables.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
90.02	Control the persistent state of a package cursor.			
91.0	Use Oracle-supplied packages. –  The student will be able to:			
91.01	Describe two common uses for the DBMS_OUTPUT package.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
91.02	Use the syntax to specify messages for the DBMS_OUTPUT package.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
91.03	Describe the purpose for the UTL_FILE package.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1
		
91.04	Identify the exceptions used in conjunction with the UTL_FILE package.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
92.0	Understand dynamic SQL. –  The student will be able to:			
92.01	Identify the stages through which all SQL statements pass.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1, 1.2		
92.02	Describe the reasons for using dynamic SQL to create an SQL statement.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1, 1.2		
92.03	List four PL/SQL statements supporting Native Dynamic SQL.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
92.04	Describe the benefits of Execute Immediate over DBMS_SQL for Dynamic SQL.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
93.0	Understand triggers. –  The student will be able to:			
93.01	Describe database triggers and their uses.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
93.02	Differentiate between a database trigger and an application trigger.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
93.03	List the guidelines for using triggers.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
93.04	Compare and contrast database triggers and stored procedures.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
94.0	Create DML triggers. –  The student will be able to:			
94.01	Create a DML trigger and identify its components.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
94.02	Create a statement level trigger.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
94.03	Describe the trigger firing sequence options.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
94.04	Create a DML trigger that uses conditional predicates.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
94.05	Create a row level trigger.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
94.06	Create a row level trigger that uses OLD and NEW qualifiers.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
94.07	Create an INSTEAD OF trigger.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
95.0	Create DDL and database event triggers. –  The student will be able to:			
95.01	Describe the events that cause DDL and database event triggers to fire.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
95.02	Create a trigger for a DDL statement.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
95.03	Create a trigger for a database event.			
95.04	Describe the functionality of the CALL statement.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
95.05	Describe the cause of a mutating table.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
96.0	Manage triggers. –  The student will be able to:			
96.01	View trigger information in the Data Dictionary.			
96.02	Disable and enable a database trigger.			
96.03	Remove a trigger from the database.			
97.0	Use large object data types. –  The student will be able to:			
97.01	Compare and contrast LONG and LOB data types.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
97.02	Describe LOB data types and how they are used.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
97.03	Differentiate between internal and external LOBs.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
97.04	Create and maintain LOB data types.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
97.05	Migrate data from LONG to LOB.			
98.0	Manage BFILEs. –  The student will be able to:			
98.01	Define BFILEs and the BFILE column data type.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
98.02	Create directory objects and view them in the Data Dictionary.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
98.03	Manage and manipulate BFILEs using BFILENAME and DBMS_LOB.			
99.0	Manage indexes. –  The student will be able to:			
99.01	Create and manipulate user-defined PL/SQL records.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
99.02	Create an INDEX BY table.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
99.03	Create an INDEX BY table of records.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
99.04	Describe the difference between records, tables, and tables of records.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2		
100.0	Manage dependencies. –  The student will be able to:			
100.01	Describe the implications of procedural dependencies.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
		
100.02	Contrast dependent objects and referenced objects.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
		
100.03	View dependency information in the Data Dictionary.			
100.04	Use the UTLDTREE script to create the objects required to display dependencies.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
100.05	Use the IDEPTREE and DEPTREE views to display dependencies.	LAFS.910.W.2.6
LAFS.1112.W.2.6		
100.06	Describe when automatic recompilation occurs.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
100.07	Describe how to minimize dependency failures.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
101.0	Use oral and written communication skills in creating, expressing and interpreting information and ideas. –  The student will be able to:			
101.01	Select and employ appropriate communication concepts and strategies to enhance oral and written communication in the workplace.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8		
101.02	Locate, organize and reference written information from various sources.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8		
101.03	Design, develop and deliver formal and informal presentations using appropriate media to engage and inform diverse audiences.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8		
101.04	Interpret verbal and nonverbal cues/behaviors that enhance communication.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8		
101.05	Apply active listening skills to obtain and clarify information.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8		
101.06	Develop and interpret tables and charts to support written and oral communications.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8		
101.07	Exhibit public relations skills that aid in achieving customer satisfaction.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8		
102.0	Solve problems using critical thinking skills, creativity and innovation. –  The student will be able to:			
102.01	Employ critical thinking skills independently and in teams to solve problems and make decisions.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8		
102.02	Employ critical thinking and interpersonal skills to resolve conflicts.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8		
102.03	Identify and document workplace performance goals and monitor progress toward those goals. 	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
102.04	Conduct technical research to gather information necessary for decision-making.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
103.0	Use information technology tools. –  The student will be able to:			
103.01	Use personal information management (PIM) applications to increase workplace efficiency.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
103.02	Employ technological tools to expedite workflow including word processing, databases, reports, spreadsheets, multimedia presentations, electronic calendar, contacts, email, and internet applications.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
103.03	Employ computer operations applications to access, create, manage, integrate, and store information.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
103.04	Employ collaborative/groupware applications to facilitate group work.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
104.0	Describe the roles within teams, work units, departments, organizations, inter-organizational systems, and the larger environment. –  The student will be able to:			
104.01	Describe the nature and types of business organizations.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
104.02	Explain the effect of key organizational systems on performance and quality. 	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
104.03	List and describe quality control systems and/or practices common to the workplace.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
104.04	Explain the impact of the global economy on business organizations.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
105.0	Describe the importance of professional ethics and legal responsibilities. –  The student will be able to:			
105.01	Evaluate and justify decisions based on ethical reasoning.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
105.02	Evaluate alternative responses to workplace situations based on personal, professional, ethical, legal responsibilities, and employer policies.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
105.03	Identify and explain personal and long-term consequences of unethical or illegal behaviors in the workplace.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		
105.04	Interpret and explain written organizational policies and procedures.	LAFS.910.SL.1.1,1.2
LAFS.1112.SL.1.1,1.2
LAFS.910.W.2.6,3.8
LAFS.1112.W.2.6,3.8
LAFS.910.RI.1.2
LAFS.1112.RI.1.2		

2017 – 2018
Florida Department of Education
Student Performance Standards

Course Title: 	Specialized Database Applications
Course Number: 	8206440
Course Credit:	1

Course Description:

This is the final course in the Database and Programming Essentials program and is designed to teach specialized database operations and utilization of SQL language for database administration and maintenance. 

Abbreviations: 
FS-M/LA = Florida Standards for Math/Language Arts
NGSSS-Sci = Next Generation Sunshine State Standards for Science

Note:  This course is pending alignment in the following categories:  NGSSS-Sci.

CTE Standards and Benchmarks	FS-M/LA	NGSSS-Sci	
106.0	Program a database application. –  The student will be able to:			
106.01	Utilize loop statements.	MAFS.912.MP.1.1
MAFS.912.MP.4.1		
106.02	Given a scenario, use arithmetic, comparison, and pattern-matching operators.	LAFS.912.W.4.10		
106.03	Create user-defined functions.	LAFS.912.W.4.10
LAFS.912.SL.1.1		
106.04	Utilize common built-in functions.	LAFS.912.W.4.10
LAFS.912.SL.1.1		
106.05	Declare variables in modules and procedures.	LAFS.912.W.4.10
LAFS.912.SL.1.1		
106.06	Declare arrays, and initialize elements of arrays.	LAFS.912.W.4.10
LAFS.912.SL.1.1		
106.07	Declare and use object variables and collections, and use their associated properties and methods.	LAFS.912.W.4.10
LAFS.912.SL.1.1		
106.08	Declare symbolic constants, and make them available locally or publicly.	LAFS.912.W.4.10
LAFS.912.SL.1.1		
106.09	Respond to events.			
107.0	Utilize the basic concepts of database design. –  The student will be able to:			
107.01	Apply basic concepts of normalization.			
107.02	Utilize the cascade update and cascade delete options.			
108.0	Utilize SQL and UNION queries. –  The student will be able to:	LAFS.912.W.4.10		
108.01	Utilize SQL to write common queries.			
108.02	Refer to objects by using SQL.			
108.03	Utilize union queries.			
109.0	Implement program statements using objects. –  The student will be able to:			
109.01	Determine when to use data access objects.			
109.02	Differentiate between objects and collections.	LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
109.03	Write statements that access and modify database objects.			
109.04	Utilize data access objects.	MAFS.K12.MP.1.1
MAFS.K12.MP.2.1		
109.05	Select appropriate methods and property settings for use with specified objects.			
110.0	Utilize debugging tools and write error handlers. –  The student will be able to:	MAFS.K12.MP.1.1		
110.01	Trap errors.	MAFS.K12.MP.1.1		
110.02	Utilize debugging tools to suspend program execution, and to examine, step through, and reset execution of code.	MAFS.K12.MP.1.1		
110.03	Debug code samples.	MAFS.K12.MP.1.1		
110.04	Utilize the Debugger to monitor variable values.	LAFS.912.W.4.10		
110.05	Write an error handler.			
111.0	Demonstrate file I/O. –  The student will be able to:			
111.01	Read from files.			
111.02	Write to files.			
111.03	Utilize record locking.			
112.0	Create forms and identify all the properties of a form. –  The student will be able to:	MAFS.K12.MP.1.1		
112.01	Choose form-specific and report-specific properties to set.			
112.02	Choose control properties to set.			
112.03	Assign event-handling procedures to controls in a form.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
112.04	Define and create form and report modules.	LAFS.910.W.4.10
LAFS.1112.W.4.10		
112.05	Identify the scope of a form or report module.	LAFS.910.RI.1.1
LAFS.1112.RI.1.1		
112.06	Open multiple instances of a form, and refer to them.			
112.07	Assign values to form properties.			
112.08	Use form methods.			
113.0	Manipulate data using object models. –  The student will be able to:			
113.01	Connect to a data source.			
113.02	Open a recordset.	LAFS.910.L.1.1
LAFS.1112.L.1.1
LAFS.910.SL.2.6
LAFS.1112.SL.2.6		
113.03	Insert, update, delete and find data.			
114.0	Develop custom controls. –  The student will be able to:			
114.01	Set properties for custom controls.			
114.02	Customize user interface controls.			
115.0	Utilize API functions. –  The student will be able to:			
115.01	Properly declare functions.	MAFS.912.S-IC.2.4		
115.02	Use the by value and by reference parameters.			
116.0	Demonstrate database replication and implement database replication using programming tools. –  The student will be able to:			
116.01	Make a database replicable.			
116.02	View a synchronization schedule.	LAFS.910.W.1.1
LAFS.1112.W.1.1
LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
116.03	Explain the purpose of the Replication ID.			
116.04	Explain how synchronization conflicts are resolved.			
116.05	Identify the advantages of using replication of synchronization.	MAFS.K12.MP.1.1		
116.06	Identify the changes that the database engine makes when it converts a nonreplicable database into replicable database.			
117.0	Analyze and implement security options. –  The student will be able to:	MAFS.K12.MP.1.1		
117.01	Analyze a scenario, and recommend an appropriate type of security.	LAFS.910.W.1.1
LAFS.1112.W.1.1
LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
117.02	Explain the steps for implementing security.	LAFS.910.W.2.4,   2. 5,2.6,3.7,3.8,3.9
LAFS.1112.W.2.4,25,2.6,3.7,3.8,3.9
LAFS.910.SL.1.2 1.3,2.4,2.5,2.6
LAFS.1112.SL.1.2
1.3,2.4,2.5,2.6
LAFS.910.L.3.6
LAFS.1112.L.3.6		
117.03	Analyze code to ensure that it sets security options.	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.2.6   4.10
LAFS.1112.W.2.6 4.10		
117.04	Write code to implement security options.			
118.0	Implement client/server applications. –  The student will be able to:			
118.01	Demonstrate SQL pass through queries and application queries.			
118.02	Access external data by using ODBC.	MAFS.K12.MP.1.1		
118.03	Trap errors that are generated by the server.	LAFS.910.L.1.1
LAFS.1112.L.1.1
LAFS.910.W.4.10
LAFS.1112.W.4.10		
118.04	Optimize connections.			
118.05	Optimize performance for a given client/server application.			
119.0	Optimize the performance of a database. –  The student will be able to:			
119.01	Differentiate between single-field and multiple-field indexes.			
119.02	Optimize queries.			
119.03	Restructure queries to allow faster execution.			
119.04	Optimize performance in distributed applications.			
119.05	Optimize performance for client/server applications.			
120.0	Perform application distribution. –  The student will be able to:			
120.01	Prepare an application for distribution.			
120.02	Analyze various methods to distribute a client/server application.			
120.03	Distribute custom controls with an application.			
120.04	Provide online help.			
121.0	Test and debug databases. –  The student will be able to:			
121.01	Implement error handling.	MAFS.K12.MP.1.1		
121.02	Test and debug library databases.			
122.0	Demonstrate the importance of health, safety, and environmental management systems in organizations and their importance to organizational performance and regulatory compliance. –  The student will be able to:	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.R.I.4.10
LAFS.1112.R.I.4.10		
122.01	Describe personal and jobsite safety rules and regulations that maintain safe and healthy work environments.			
122.02	Explain emergency procedures to follow in response to workplace accidents.	MAFS.K12.MP.1.1		
122.03	Create a disaster and/or emergency response plan.			
123.0	Demonstrate leadership and teamwork skills needed to accomplish team goals and objectives. –  The student will be able to:	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.R.I.4.10
LAFS.1112.R.I.4.10LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
123.01	Employ leadership skills to accomplish organizational goals and objectives.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
123.02	Establish and maintain effective working relationships with others in order to accomplish objectives and tasks.	LAFS.910.SL.1.1
LAFS.1112.SL.1.1		
123.03	Conduct and participate in meetings to accomplish work tasks. 			
123.04	Employ mentoring skills to inspire and teach others.			
124.0	Explain the importance of employability skill and entrepreneurship skills. –  The student will be able to:	LAFS.910.L.3.6
LAFS.1112.L.3.6
LAFS.910.W.4.10
LAFS.1112.W.4.10
LAFS.910.R.I.4.10
LAFS.1112.R.I.4.10		
124.01	Identify and demonstrate positive work behaviors needed to be employable.			
124.02	Develop personal career plan that includes goals, objectives, and strategies.			
124.03	Examine licensing, certification, and industry credentialing requirements.			
124.04	Maintain a career portfolio to document knowledge, skills, and experience.			
124.05	Evaluate and compare employment opportunities that match career goals.			
124.06	Identify and exhibit traits for retaining employment.			
124.07	Identify opportunities and research requirements for career advancement.			
124.08	Research the benefits of ongoing professional development.			
124.09	Examine and describe entrepreneurship opportunities as a career planning option.			

Additional Information

Laboratory Activities

Laboratory investigations that include scientific inquiry, research, measurement, problem solving, emerging technologies, tools and equipment, as well as, experimental, quality, and safety procedures are an integral part of this career and technical program/course. Laboratory investigations benefit all students by developing an understanding of the complexity and ambiguity of empirical work, as well as the skills required to manage, operate, calibrate and troubleshoot equipment/tools used to make observations. Students understand measurement error; and have the skills to aggregate, interpret, and present the resulting data. Equipment and supplies should be provided to enhance hands-on experiences for students. 

Special Notes

The occupational standards and benchmarks outlined in this secondary program correlate to the standards and benchmarks of the postsecondary program with the same Classification of Instructional Programs (CIP) number.

MyCareerShines is an interactive resource to assist students in identifying their ideal career and to enhance preparation for employment. Teachers are encouraged to integrate this resource into the program curriculum to meet the employability goals for each student.  Access MyCareerShines by visiting: www.mycareershines.org.

Career and Technical Student Organization (CTSO)

Future Business Leaders of America (FBLA) and Business Professionals of America (BPA) are the intercurricular career and technical student organizations providing leadership training and reinforcing specific career and technical skills.  Career and Technical Student Organizations provide activities for students as an integral part of the instruction offered.  

Cooperative Training – OJT

On-the-job training is appropriate but not required for this program.  Whenever offered, the rules, guidelines, and requirements specified in the OJT framework apply. 

Accommodations

Federal and state legislation requires the provision of accommodations for students with disabilities as identified on the secondary student’s Individual Educational Plan (IEP) or 504 plan or postsecondary student’s accommodations’ plan to meet individual needs and ensure equal access. Accommodations change the way the student is instructed. Students with disabilities may need accommodations in such areas as instructional methods and materials, assignments and assessments, time demands and schedules, learning environment, assistive technology and special communication systems. Documentation of the accommodations requested and provided should be maintained in a confidential file.

In addition to accommodations, some secondary students with disabilities (students with an IEP served in Exceptional Student Education (ESE)) will need modifications to meet their needs. Modifications change the outcomes or what the student is expected to learn, e.g., modifying the curriculum of a secondary career and technical education course. Note: postsecondary curriculum and regulated secondary programs cannot be modified.

Some secondary students with disabilities (ESE) may need additional time (i.e., longer than the regular school year), to master the student performance standards associated with a regular Occupational Completion Point (OCP) or a Modified Occupational Completion Point (MOCP). If needed, a student may enroll in the same career and technical course more than once. Documentation should be included in the IEP that clearly indicates that it is anticipated that the student may need an additional year to complete an OCP/MOCP. The student should work on different competencies and new applications of competencies each year toward completion of the OCP/MOCP. After achieving the competencies identified for the year, the student earns credit for the course. It is important to ensure that credits earned by students are reported accurately. The district’s information system must be designed to accept multiple credits for the same course number for eligible students with disabilities.

Additional Resources

For additional information regarding articulation agreements, Bright Futures Scholarships, Fine Arts/Practical Arts Credit and Equivalent Mathematics and Equally Rigorous Science Courses please refer to:
http://www.fldoe.org/academics/career-adult-edu/career-tech-edu/program-resources.stml