Italy Secondaria di secondo grado – classe 4ª Computer science

1. Tools and foundations

Advanced documents and web · Databases · Programming methods

• Web Development: How HTML, CSS and JavaScript Build a Web Page – A web page is a set of text files. The browser (client) asks a server for them using a URL and HTTP. HTML gives the page its structure: headings, paragraphs, links, images, lists, tables and forms. CSS gives style: colours, fonts, spacing and layout. JavaScript gives behaviour: it reacts to clicks and changes the page. Responsive design makes one page fit both phones and computers. Good pages are also accessible, fast and safe.
• Database Concepts: DBMS, Relations and Keys – Keeping data in separate files causes duplication, inconsistency and poor security. A database stores related data in one organised place, and a DBMS (like MySQL) is the software that manages it. In the relational model, data is kept in tables (relations) made of columns (attributes) and rows (tuples); a domain is the set of allowed values of a column. A candidate key uniquely identifies each row; one is chosen as the primary key and the others are alternate keys.
• Relational Databases: Tables, Rows, Columns and Keys – Keeping data in many separate files leads to repeated data, mismatched copies and hard searching, so we use a database managed by a DBMS. In the relational model data sits in tables called relations. A column is an attribute, a row is a tuple, and the set of allowed values for a column is its domain. The number of columns is the degree; the number of rows is the cardinality. A candidate key is any column (or set) that can identify every row uniquely; the one chosen is the primary key and the others are alternate keys. A foreign key is a column in one table that refers to the primary key of another table, linking them.
• Object-Oriented Programming (OOP) – Object-oriented programming builds a program out of objects. A class is a blueprint that lists the data (attributes) and actions (methods) its objects will have. Each object is made from a class and keeps its own data. The four big ideas are encapsulation (hide data behind methods), inheritance (a new class reuses an old one), polymorphism (the same method call behaves in the right way for each object) and abstraction (show only what is needed).