Databases
Database Requirements
SQL
PHP
Front-End Technologies
100
This is an easy way of storing large amounts of data
What is a database
100
After having analyzed the database requirements, we are now able to come up with a ?
What is a conceptual database model
100
This subset of the SQL-language are used for selecting, inserting, deleting and updating data in a database.
What is Data Manipulation Language (DML) (Sublanguage of SQL)
100
This is one way used to output data to the screen.
What is echo
100
This a the language that we use to apply styling to our HTML content, for example setting background colors and fonts, and laying out our content in multiple columns.
What is Cascading Style Sheets (CSS)
200
This kind of database organizes data into tables, and links them, based on ended relationships
What is a relational database
200
This is a high-level data modeling technique that helps designers to create accurate and useful conceptual data models according to Mr. Chen
What is an Entity Relationship Diagram/Model
200
This subset of the SQL-language are used to create, alter, or drop data structures in a database.
What is Data Definition Language (DDL)
200
Every time you want to create a variable in PHP you will begin with this character
What is the dollar sign ($)
200
This consortium was founded by Tim Berners-Lee and develop and maintain web standards. These standards are then used to help guide web developers and browsers to develop code that lives up to certain standards.
What is W3C
300
In a relational database, data is stored in one or more tables that consist
What is rows and columns
300
This is one element from the Entity Relationship Diagram/Model that is represented by means of rectangles and is a real-world thing.
What is an entity
300
This SQL keyword is used to delete an existing database or to remove a table definition and all data
What is SQL keyword DROP?
300
This is a special special variable, which can hold more than one value at a time.
What is an array
300
This framework is built upon JavaScript and makes it easy to manipulate a page of HTML after it's displayed by the browser. It also provides tools that help you listen for a user to interact with your page, tools that help you create animations in your page, and tools that let you communicate with a server without reloading the page.
What is the Framework jQuery
400
This is a single column in a table that uniquely identifies each row in the table.
What is a primary key
400
This is one of the most common relationships in ER models that connects two entities
What is a binary relationship
400
This SQL keyword is used to specify a condition while fetching the data from single table or joining with multiple tables.
What is SQL keyword WHERE
400
This is the way a PHP script starts and ends with.
What is a
400
This Front-end-framework contains HTML and CSS-based design templates for typography, forms, buttons, navigation and other interface components, as well as optional JavaScript extensions.
What is the framework Bootstrap
500
This is the brand of one database software, one out of many. This database software is very popular among programs that run on websites (probably because they are free), which is why you often see this being advertised in the feature lists of web hosts.
What is MySQL
500
The term is used in a Entity Relationship Diagram/Model to denote the maximum number of times an instance in one entity can be associated with instances in the related entity
What is the cardinality
500
This SQL keyword is used to compare a value to similar values using wildcard operators.
What is SQL keyword LIKE
500
Often when you write code, you want the same block of code to run over and over again in a row. This loop executes a block of code as long as the specified condition is true
What is a while loop
500
This s a programming language that enables you to create dynamically updating content, control multimedia, animate images, and pretty much everything on web pages.
What is JavaScript (JS)
M
e
n
u