• Non ci sono risultati.

PHP and Database practice

N/A
N/A
Info
Scarica
Protected

Academic year: 2021

Condividi "PHP and Database practice"

Copied!
1
0
0

Caricamento.... (Visualizza il testo completo ora)

Scarica adesso ( 1 pagine )

Testo completo

(1)

PHP and Database practice

1. A database contains the information related to artworks of different cities. Each artwork is characterized by a code, the name, its category (painting, sculpture, architecture), and the city and the country where it is located. For each artwork the author is known, who is characterized by a code, the name, the surname, his/her birth year and birth city.

The relational schema is composed by the following tables Artwork(artworkCode, name, category, city, country, author) Author(authorCode, name, surname, birthYear, birthCity)

1.

write a SQL script to create the tables above, specifying attributes and keys of each table.

2.

write a SQL query to show all the artworks in Rome of all authors born between 1590 and 1600. The query must return the surname of the author and the name and category of the artwork. Results must be presented in alphabetical (ascending) order by author.

3.

write a transaction to insert a new author and an artwork of his own in the database.

2. Design a web application for the online consultation of the DB.

•

The access form should show two textboxes to specify a range of years for searching authors by birth year and a select box to for searching artworks by city.

•

Once such fields are set up, the application must show all the artworks of authors born during the specified range and located in the selected city, ordered by author's surname, in a table like the following one. The rows of the table must have a different color (of your choice) based on the category of the artwork (painting, sculpture, architecture) using CSS.

Riferimenti

Scarica adesso ( PDF - 1 pagine - 406.37 KB )

Documenti correlati

"The lost ones: the opportunities and outcomes of non-college-educated Americans born in the 1960s" – CeRP

Of the three changes that we consider, that is wages, out-of-pocket medical ex- penses during retirement, and life expectancy, we find that the observed changes in the wage schedule

We provide existence and uniqueness of a solution to the latter and show that such solution arises as the limit in probability of the empirical measures of the system

We allow for discontinuous coefficients and random initial condition and, under suitable assumptions, we prove that in the limit as the number of particles grows to infinity

The free law of the field is specified by the density exp

Pinning Model, Wetting Model, Phase Transition, Entropic Repulsion, Markov Renewal Theory, Local Limit Theorem, Perron–Frobenius Theorem, FKG

In BCΣ, the domain and codomain of the functions both are the set of free terms from the signature Σ

Prove that any functional program which admits an additive polynomial interpreta- tion computes a polytime function.

This practice has the objective of realizing a simple web application based on PHP to query a database.

This practice uses the Apache web server and the MySQL database available in XAMPP.. In order to perform the practice it is necessary to start both

In this context, people from the same team or different teams must work together regardless of the time zone and where they are located

The research “iter” can be summarized as follows: (1) the main collaborative and engineering requirements have been identified by referring to a real use case within

The targets located in the sensing area of a given sensor s are covered by s

In particular, this work focuses on the issue of maximizing the amount of time over which a set of points of interest (target points), located in a given area, can be monitored by

in the fields, in the fields

Even though this is a free printable, please respect my work, time and copyright by not sharing..