Morrowind Conversion Oblivion

High School Track - State Exam Test Questions 2009

A telephone company may wish to adopt an information system that would allow its technicians access to an online registry of address book contacts, so that each group member can consult at any time and the information contained in it All ' update if applicable (enter new contacts, edit or delete existing contacts).

The Chief of the Information System will expand the portal that is accessed normally members of the group by adding this new feature: Each member will be authenticated by the system in use by the insertion of credentials (username and password) to ensure secure access to information which is permitted, and the information shared between multiple users of the working group.

In order to produce regular statistics to optimize the work of the group must keep track of every access to the system, recording the basic information (identifier user name, date and time of access, time and date of logoff, ...) and transactions (consultations / updates section of the contact) performed by each user authenticated in the case of update operations should be maintained even the status of the book before the change until the administrator of the system will validate the changes and make them public.

Applicants without the necessary additional assumptions:

1. Produce an analysis of the reality of reference by focusing on safety aspects of the information system

2. Projects a conceptual scheme and corresponding logical database schema

3. Perform the definition of relations and the following in SQL queries expressed in language SQL:

- Display the list in alphabetical order by name, of the contacts in a specific province
- List, in chronological order, the accesses made by a member of the group

- Calculating and displaying the average daily number of hits in a given period of time
- Calculate and display the total number of new contacts entered, for each member
- List the steps in a given day by each user of the working group
- View account information over more interested in a week

4. Propose a solution for web-based administration system and code in a programming language of your choice in a significant segment of the project realized.

Laryngeal Cancer Ribbon Colour

Souvenir by cilento

emerges from a trip to the Cilento, beautiful country, warm and kind, which now smells of freshly picked vegetables and fruit zuccherina.La recipe that I post is my born and, indeed, smells delicious and solar colors Cilento.

STUFFED EGGPLANT:

Ingredients for two people.

eggplant 2 tomatoes

s.marzano

salt, pepper extra virgin olive oil

parmesan bread

milk

breadcrumbs

garlic basil.

Cut the eggplant in the length and empty with the scovino or a teaspoon, remove the pulp and set parte.Far the zucchini in boiling salted water for about 5-6 minutes. Place in a pan with a clove of garlic to two or three tablespoons of olive oil, red pepper and sauté, We add the chopped eggplant and cook for two to three minutes after cooking We add two leaves of basil to flavor everything. Whip the cream of eggplant, add the Parmesan, the bread, made with a little milk to soften and well strizzato.Riempite eggplant with eggplant cream and put us all on a tomato s.marzano maturo.Infornate well for 20 minutes at 180 ° e.. enjoy!

Why 12 On Alabama Helmet

• How to distinguish a plant from a plant in the nursery is not present, but described?
• There was an ambiguous use of the term species, sometimes used to indicate a grouping of plants and other times to indicate a specific plant.
  
• What is the difference between species and plant?
  

Species: grouping of plants with common characteristics.
Plant: the description attribute will be used to describe both the species plants.
In the first case will serve to collect all the elements common to a set of
plants (species), while the latter will be used to characterize the specific
plant.

• How do you plan to store the image of the plant? We can assume that you use a link connected to the image of the plant.
  
• How to organize "information relating to the mode of cultivation and characteristics of exposure? There being no explicit requests in the text of research on the above information you think you might consider this description contained in a text area.
• How is personnel management? The differences between the categories provided for staff are those relating to agronomists, for which additional information is required as the year of recruitment and managed species. How
• binds staff outside activities?
• How to distinguish a company from a private owner?
  

Orajel Side Effects On Penis

TRACE ANALYSIS

STATE EXAMINATION YEAR 2003

A nursery wants to build a database to manage its business of selling plants and its external activities.
you want to save. In addition to general information on different plant species, including those relating to specific plants in the nursery.
of every kind must be registered the name, image, brief description, information relating to the mode of cultivation and exposure characteristics and finally whether it is indoor or outdoor plant.
You also want to record data on actual plants in the nursery, grouped by species, possibly divided into several types according to the selling price. For each species (or for each type, if the species is divided into types), you must record the number of copies in the nursery and the cost of each copy.
You also want to manage information related to staff working in the nursery (agronomists, laborers, administrative) by recording the data, the status and, for agronomists, the year of recruitment in the nursery. Every single species of the nursery is under the responsibility of an agronomist.
external activities of the nursery, such as pruning or maintenance of the gardens, are carried out by staff based on the qualification (in general, each worker is able to carry more than one activity) and are characterized by a code, by a name, an hourly cost.
For outdoor activities you want to keep all information relating to customers requiring activities, particularly when it comes to private companies, the date of booking and the of performing the service requested and if the intervention is needed of the nursery plants. The candidate
Consider the situation described above, accurate and achieve any additional assumptions:
analysis of the reality of reference setting out the conditions for the next steps in the design of the database;
a conceptual framework based on data; a
logical scheme based on data
the definition of relations of the database language SQL, the following questions
expressed in SQL:
1.dat the name of a plant, bring many copies of that plant are present in the nursery;
2.Date the name of a season, see the names of plants bloom at that season;
3Data the name of an external intervention, including those provided in the nursery, state the name and telephone number of persons who have requested this intervention in a given calendar year;
4.Data name an agronomist, return those specimens of plants are under its responsibility;
5.Show name, description and quantity of specimens in the nurseries, the plant's cheaper to internal
6.riportare name of the work required has not yet fulfilled the name and telephone of the applicant.


The candidate will also, at the choice of the following modules:
You want to make a website that presents the public an explanation of the nursery products and activities.
We want to enable the management of external activities of the nursery through an online booking from customers. Illustrate how to implement this function and the technical tools adoptable.

Potato Soup Boil Potatoes

After reading the track and after the appropriate arguments I have identified five fundamental entities for the construction of the project:
Specie_esistenti I will need to group all plant species existing in the world which will give a name picture (link), a brief description, any information on growing, I suggested that a species can contain only plants or indoor or only external
Piante_vivaio I use to store all the plants in the nursery divided by name, type, price, and copy number stagione_fioritura present;
Staff that will contain all the information relating to employees of the nursery (including agronomists) divided by name, surname, date of birth, title, year of recruitment;
Attività_esterne that will be used to track all activities outside the nursery that can be made, divided by name, code, cost,
Customers , I assumed that the customer should exist when making a request to intervene in this entity then will be: type of user (whether individual or company) name, phone, giorno_prenotazione, mese_prenotazione, anno_prenotazione (so divided for ease of query), the date of execution of the operation.

Converse Aero Jam Size 12

CONCEPTUAL SCHEMA DEFINITION

Jelly Bracelets Color Meanings 2009

Chevrolet Express Conversion Van

SCHEME LOGIC RELATIONS IN QUESTIONS

CREATE TABLE SPECIES (IDS auto increment integer,
NAME varchar (10) not null,
image_link varchar (50),
INFO varchar (50),
primary_key (IDS));

CREATE TABLE PLANTS (IDP auto increment integer,
NAME varchar (10) not null,
varchar (10) not null,
PRICE integer not null,
STAGIONE_FIORITURA varchar (10) not null,
NUMERO_ESEMPLARI integer not null,
IDS integer not null,
IDPE integer not null,
primary_key (IDP),
FOREIGN KEY (IDS) references SPECIES (IDS)
FOREIGN KEY (IDPE) references SPECIES (IDPE));

CREATE TABLE CUSTOMERS (IDC auto increment integer,
varchar (10) not null,
NAME varchar (10) not null,
PHONE varchar (10) not null ,
GIORNO_PRENOTAZIONE integer not null,
MESE_PRENOTAZIONE varchar (10) not null,
ANNO_PRENOTAZIONE integer not null,
DATA_INTERVENTO varchar (10),
EVASION varchar (10) not null,
primary_key (IDC));

CREATE TABLE STAFF (IDPE auto increment integer,
NAME varchar (10) not null,
SURNAME varchar (10) not null,
DATA_NASCITA varchar (10 ) not null,
STATUS varchar (10) not null,
ANNO_ASSUNZIONE integer not null,
PRIMATY_KEY (IDPE));

CREATE TABLE OUTDOOR ACTIVITIES (IDA auto increment integer,
NAME varchar (10) not null, varchar
CODE (10) not null,
COST integer not null,
primary_key (IDA));

CREATE TABLE REQUIRES (IDC integer not null,
IDP integer not null,
FOREIGN KEY (IDC) references CUSTOMERS (IDC),
FOREIGN KEY (IDP) references PLANTS (IDP));



CREATE TABLE PLACE (IDA integer not null,
IDPE integer not null,
FOREIGN KEY (IDA) references external activities (IDA),
FOREIGN KEY (IDPE) PERSONAL references (IDPE));

CREATE TABLE REQUEST (IDC integer not null,
IDA integer not null,
FOREIGN KEY (IDC) references CUSTOMERS (IDC),
FOREIGN KEY (IDA) references external activities (IDA));

The Example Of Verbiage

SQL in SQL

1) NUMERO_ESEMPLARI
SELECT FROM WHERE PLANTS
PIANTE.NOME = 'Nome_pianta'

2) PIANTE.NOME
SELECT FROM WHERE PLANTS
STAGIONE_FIORITURA = 'nome_stagione'

3) SELECT CLIENTI.NOME, CLIENTI.TELEFONO
FROM CUSTOMERS ATTIVITA_ESTERNE, REQUEST
CLIENTI.IDC WHERE = (SELECT
RICHIESTA.IDL
FROM REQUEST WHERE ATTIVITA_ESTERNE
ATTIVITA_ESTERNE.NOME = 'nome_intervento'
AND ATTIVITA_ESTERNE.IDA = RICHIESTA.IDA
AND ANNO_PRENOTAZIONE = 'anno_richiesta_intervento')

4) PERSONALE.NOME SELECT, COUNT (NUMERO_ESEMPLARI)
FROM STAFF , PLANTS
GROUP BY HAVING NUMERO_ESEMPLARI
PERSONALE.NOME = 'nome_agronomo' AND
PIANTE.IDPE PERSONALE.IDPE

= 5) SELECT PIANTE.NOME, SPECIE.INFO, PIANTE.NUMERO_ESEMPLARI, MIN (PRICE) FROM STAFF
,
PLANTS HAVING GROUP BY PRICE
SPECIE.TIPO = "internal" AND PLANTS: IDS SPECIE.IDS
= 6) SELECT ATTIVITA_ESTERNE.NOME, CLIENTI.NOME,
PHONE FROM CUSTOMERS REQUEST ATTIVITA_ESTERNE
WHERE ESCAPE = "not processed"
AND ATTIVITA_ESTERNE.IDA = RICHIESTA.IDA
AND RICHIESTA.IDC = CLIENTI.IDC

Herpes In The Pubic Hair Region

presentation site

 
 \u0026lt;HTML> 
 \u0026lt;HEAD> 
 \u0026lt;TITLE> 
 Nursery and its 
 \u0026lt;/ TITLE> 
 \u0026lt;/ HEAD> 
 
 \u0026lt;BODY> 
 \u0026lt;P> 
 Our nursery offe different species of different kinds of plants, are a few representative photos 
 \u0026lt;/ P> \u0026lt;BR> 
 
 \u0026lt;DIV> 
 \u0026lt;IMG "FOTO1"> 
 SRC = \u0026lt;/ DIV> 
 \u0026lt;DIV> 
 \u0026lt;IMG SRC = "FOTO2"> 
 \u0026lt; / DIV> 
 \u0026lt;DIV> 
 \u0026lt;IMG "FOTO3"> 
 SRC = \u0026lt;/ DIV> \u0026lt;BR> 
 
 \u0026lt;P> 
 also offer many services such as pruning and treatment of your garden 
 \u0026lt;/ P> \u0026lt; , BR> 
 
 \u0026lt;DIV> 
 Rose Cyclamen 
 \u0026lt;BR> = $ 4 = $ 7 \u0026lt;BR> 
 Pruning = $ 30 per hour \u0026lt;BR> 
 Garden Maintenance = $ 50 per hour 
 \u0026lt;/ DIV> 
 \u0026lt;/ BODY> 
 \u0026lt;/ HTML> 
 

How Much Do Driving Liscense Cost

thinking on track

After careful and repeated reading of the text of the problem, it is believed that the concepts around which will develop the database may be summarized as follows:

Teams Athletes
3. Gare
4. Among the steps

more concepts that emerge from reading the text and the query we can see:

1. Institutes
2. Calendars
3. Locations
4. Ratings
   

The questions that may require a response and that could become specific, additional assumptions or constraints are:

1. How does a race? Allocation of time and evidence to support
   
2. What is a race? a series of tests based on: test, quiz, report, plan, treatment of a topic
3. In What are the stages? a series of races; such events can be repeated in each phase?
4. What is the timetable? the scheduling of events at different stages in terms of: date, time, type of race, where will the race teams participating in the race
5. How to manage and distinguish the races for teams and competitions for individuals? hypothesis would be to consider the individual as a team, for example by adding an attribute: number of components Team
6. how to handle the records? One possibility would be to use an attribute that stores the record before a race.

Having said this, and highlighted those which are fundamental aspects of the problem, we will proceed with the formalization of the lance. We will then locate the Entities and Associations, the choices will be motivated, and will be described in terms of attributes.


Entities The entities could be identified as follows

1. Athletes: contains all the information in the Registry for athletes with the added attribute age
   
2. Teams: as anticipated, we will assume that the teams can be composed also by a single athlete and it will be assumed the presence of an attribute: Number of components. In this way, even the athletes who participate in the races will be treated as a team
   
3. Steps: will feature: site description of the start date being
4. Gare : will be described and identified, as mentioned above will add an attribute : Score Record
   
5. Institutes : contains all the demographic information of the institutes participating in the competitions including geographic information: city district region state, whereas the countries international may not have all the same geographical organization will take the details of the Italian one providing for the assignment of NULL values.
6. It could also be evidence of the magnitude associated with each race, but this is not explicitly referred

Associations

Possible associations could be:

1. Calendar: type ternary alloy that entities: competitions, teams, phases, with the attributes: date, time that identifies the event
   
2. Belonging: a binary that links entities Teams Athletes
   
3. come: a binary that links entities Athletes Schools

A Now we will proceed with the detailed description of the Associations and the Entities identified in terms of attributes

Before I suggest you check whether the scheme meets the requirements of the identified query

Di I Need Good Credit For An Sba Loan

analysis of maturity 2007/08 trace

05/21/2009

Abrescia
Cosenza Ivan Dario Ivan
Lasorsa
Monguzzi
Andrea Angelo Ranieri

Year 2007/2008 (track on the International Olympiad in Informatics)

ANALYSIS:
significant concepts found after the 'analysis are:


-Athletes Gare-Teams

-Phase

-Locations-Calendar-score

-record score

entities emerging after a careful analysis are:

-Athletes

-Gare-Teams

After a thorough reading the text has opted for a link between the N to N entity "Athletes" and "Gare"
to represent the concept of calendar. The latter is better placed to promote proper
overview of the athletes, the competitions attended and the grades obtained.

It also wants to assume the entity "Teams" which however is not mandatory for participation in competitions of individual athletes
. This assumption

the following reports:

-group-participation


from a reading of the text shows that the athletes will be able to bid both individually and in groups.
It can be assumed that athletes and their teams may participate in at least one race.

additional assumptions:

-stages of the tournament are attributes of races and can take only the values \u200b\u200b"school," "regional," national "
" international ".
-order to avoid redundancy "score" attribute of the report will be participating.
-to determine the training effect by age of participants is likely to be stored corresponding date of birth.

Avoid Discomfort In Shortness Of Breath

Track Maturity AS 2006/07

An online store calls for both designed and built a database for the organization and management a portal for the sale of books on the Internet.

The store requires that:

• Catalogue of books is organized by:

- Departments (in alphabetical order: architecture and urbanism, art, classical Greek and Latin, kitchen and home, law, economics and management, science fiction and fantasy, philosophy, comic books, ...)

• Each department is organized in books:

- "Do not miss" characterized by a 20% discount on the cover price

- "Best Sellers" characterized by the largest number of copies sold in the last 30 days

- "Last Uploads" characterized by titles added in the last 30 days

- "Special" characterized by a 25% discount on the cover price

- "Remainders" characterized by a 50% discount on the cover price

• each book in the store is closed with the following additional information:

- title, author, cover price, discount (if applicable), data (number of pages, hardbound, ...), year of publication, publisher, series, image (photo cover ), data storage

• enabled users to purchase online are listed with the following information:

- name, address, zip code, city, country, phone, fax, and email, password, credit card number, type of credit card (Visa, CartaSi, Mastercard, ...), expiration date of the credit card

• Users may request, during the purchase, the store will invoice

• shopping cart is organized as follows:

- number of copies purchased, title, author, price, availability ( days, weeks, ...), remove from cart (checkbox)

• the list of orders is organized as follows:

- order date, order number

- order details (reference item number, title, cover price, discounted price, order status, avoidance expected from the order date).

The candidate, after making any additional assumptions:

a. Supply:

1. the conceptual and logical database schema

2. the definition of relations in SQL.

b. Implements the following query:

1. Search by Department: choose a department, the number of books "can not miss" and the number of books, "Best Sellers" with details about

2. Orders: Orders in progress, with details of a given user.

c. Write a server side language, the code of at least one of the following pages of the portal:

1. with free access, the page useful to view the Departments and for each department, the page that implements the query No 1;

2. with access restricted to registered users, the composition of the orders.

Movie Called Crush On

additional analysis and assumptions

is required to design and implement a database that contains the information necessary for the online sale of books to registered users .

Books and Users are therefore the main objects of computer system you will achieve.

for books are required:

• division into departments (architecture and urban planning, art, classical Greek and Latin ...).
  Although not explicitly stated is plausible assume that a book is part of a single department

• further subdivision of the Department in categories, the text uses the term "books" that we replace with "class" Alternatively, we could use even the term "reported" to avoid ambiguity ("can not miss", "Best Sellers" category ...); every comment or a characterization that may affect the type of discount offered, the number of copies sold or the date of publication and inclusion in the catalog.
  Also in this case is not explicitly defined by the fact that a book can only belong to one or more categories, equivalently, if it is not explained in the same book can be applied to different reports, in our proposal will be given the opportunity to add a book in more than one category (may receive more alerts) thinking that, for example, a book can both belong to the category "not miss" and "Top Sellers"

• for each book are also precisely defined characteristics to be included in the database
  In particular we analyze:

  • the we assume that discount is not directly related to the category (or tip) of belonging

  • a series of particularly structured data (number of pages, type of binding ...) we represent in a generic text-only attribute on which no will be provided for any particular operation. Otherwise, the data should be distributed on fields separate
    

  • pictures of book covers are stored in external files the database where an addition will be reference to those files.

Even for users are precisely defined characteristics to be included in the database.

• No characteristic poses particular management problems. We are only obliged to point out that the credit card number of each user is an extremely sensitive and should be treated with appropriate procedures to ensure that they security (but this problem goes beyond the demands made in the text)

For each user, each new access to the online store will be assigned a virtual shopping cart in which to insert the selected books which can then be confirmed (all or in part) to give rise to a purchase order.

Additional assumptions in the definition of the shopping cart text speaks of " availability (days, weeks ...), this information will be provided for each book database

The Right Thing To Say In A Wedding Card

Description Entity Associations

Description of Entities and Associations identified trace analysis and additional assumptions made.

Remarks to chart:

Entity DEPARTMENT
Description: Represents the division into departments of the library catalog.
Department Code is the key attribute, department name and description (architecture and urban planning, art ...)

Entity CATEGORY
Description: Represents the categories to which those books.
class is the key attribute, Description is the description of the category ("can not miss", "Best Sellers" ...) Notes allows you to add a comment ("Discount 20% "...)

Entity BOOK
Description: Represents the books in the catalog. Bookseller
is key attribute, an attribute data which includes various information (number of pages, binding type ...), Availability is a text attribute used when ordering, and the other attributes are clear interpretation.

Association Classified
Description: associates a book to a department.

Association belongs
Description: Bind a book in various categories.

user entity
Description: Represents registered users can make purchases.
User ID is the key attribute, the attribute address is composed of city, street, house number etc.., The other attributes are clear interpretation.

Order entity
Description: Represents the purchase orders placed by users.
Order Number is the key attribute, the attribute status indicates whether the order is processed or to deal with, the bill required attribute indicates whether the user has requested an invoice being issued the order.

Association Included in the basket
Description : Users associated books and is the shopping cart that the user "fills" every time you access the site shop. Copies
is an attribute of the association and represents the number of copies of a book that you put in the cart, the attribute deleted is used to remove the book from the basket and avoid placing it in the order.

Association Make
Description: associates a user to its purchase orders.

The association is' included
Description: associates a book to order.
attribute Number of Copies is the number of copies of a book included in an order.

Play Racquetball In Nyc

Possible Scheme E / R diagram

ER Diagram

Can A Slipped Disc Cause Seizures

2006/07

For a CATEGORY may belong one or more books.
A BOOK belongs to one or more categories (or a book can be several times SUGGESTED.

in a department can be cataloged one or more books.
A book is cataloged in a single department.

A BOOK can be included in a cart or more users.
A USER can include in his cart one or more books.

A USER can make one or more orders. An order is made
only one user.

A BOOK can be included in one or more orders. ORDER A
includes one or more books.

Naruto Hurricane Chicken Mugen

Reading Scheme 2006/07

implementing the database using the relational model and we go through the rules derived from the conceptual framework proposed at the following relational schema:

How Long Does It Take For Skin Pigment To Return

Logical Query SQL Scripts PHP

1. Search Department: choose a department, the number of books "can not miss" and the number of books, "Best Sellers" with details about

assume that the choice department is made by name (R_nome). You will need 4 tables: BOOK, DEPT, CLASS, BELONGS

With this first question we get the number of books "can not miss" in a particular department:

SELECT count (*) AS [Numero_Libri]

FROM Paper, Department, Category, belongs

WHERE (

L_Reparto = R_codice

AND

C_codice = A_Categoria

AND

A_Libro = L_codice

AND

R_nome = [Department Name]

AND

C_descrizione = "Do not miss"

)

(same goes for the books "Top Sellers")

To get the details of the books (in this case we present only author and title:

SELECT L_autore, L_titolo

FROM Paper, Department, Category, belongs

WHERE (

L_Reparto = R_codice

AND

C_codice = A_Categoria

AND

A_Libro = L_codice

AND

R_nome = [Department Name]

AND

C_descrizione = "Do not miss"

)

(same goes for the books "Top Sellers")

2. Orders: Orders in progress, with details of a particular user,
   

• with access restricted to registered users, the composition of the orders.

Access is restricted to registered users so that they can only see their orders, then we assume that during the login is stored in the user code (COD_UTENTE), the attribute O_stato the Orders table is used to find orders.

O_numero AS SELECT [N. Odin] L_autore AS [Author] L_titolo AS [Title] AS I_numero_copie [copies]

FROM Orders, Including, Book

WHERE (

I_Ordine = O_numero

AND

I_Libro = L_codice

AND

O_Utente = COD_UTENTE

AND

O_stato = "in progress"

)

Artificial Blueberries

What's Myammee's Real Name

Architecture Hardware and Software

To manage the database software application that can be expected to interact with the database to insert, modify and delete information in addition to various interrogation procedures.
In terms of hardware could be considered a single workstation (Personal Computer) to host the database and contact management program.
In the case of larger reality could be considered a local area network (Network PC) in which a node will serve as a database server and other clients.
For the database you could use a DBMS (eg MySQL) can provide the service via LAN. The application for the management and querying data could be written in high level language (eg PHP) that encapsulate the SQL statements to interact with the database.

Gonorrhea In Female Images

Web Portal

shop online course must be accessible via the web to read the catalog and execution of orders by registered users.
addition to the HTML necessary for the realization of the web site you must use a server side scripting language (eg PHP, ASP, ASP.NET) to interact with the database, retrieve information and create dynamic pages.
pages that make up the site must be stored on a server connected to the Internet that could be owned by the store or hosted by a third party service provider.
On the server must be running a Web Server (eg IIS, Apache) and an engine that can execute commands on the server side programming language used in addition to a SQL server to interact with the database.
Pages can be accessed from any computer connected to the Internet and has a browser (eg Internet Explorer, Firefox, Safari)

How Did Alabama Get The Elephant As A Mascot

implementing the portal you need to build dynamic web pages with server-side programming, in the examples proposed has been chosen as DBMS MySQL and PHP as a language for scripting.
1.With free access, the page useful to view the Departments and for each department, the page that implements the query No 1;

The solution consists of two pages, the first (reparti.php) queries the database and displays all the departments by creating a set of links to the second page (totale_libri.php) each of which passes as a parameter the selected department and the second page retrieves the parameter for the query using the query 1.

Can Stress Cause A Stoke

Relational Schema



You have chosen to use the POST method for safety reasons as the data exchanged between the pages containing the user's password

1998 Kawasaki Prairie 400 Fan

HTML pages created with the interpretation of the text SQL commands


CREATE TABLE DEPARTMENT (
R_codice CHAR (20),
R_nome CHAR(50) NOT NULL,
PRIMARY KEY(R_Codice)
)

CREATE TABLE CATEGORIA
(
C_codice CHAR(20),
C_descrizione CHAR(50) NOT NULL,
C_note CHAR(80),
PRIMARY KEY(C_Codice)
)

CREATE TABLE LIBRO
(
L_codice CHAR(13),
L_autore CHAR(30),
L_titolo CHAR(50) NOT NULL,
L_prezzo MONEY NOT NULL,
L_sconto INTEGER,
L_dati CHAR(100),
L_anno_pubblicazione INTEGER,
L_collana CHAR(30),
L_immagine CHAR(30),
L_data_archiviazione DATE,
L_disponibilita CHAR(20),
L_Reparto CHAR(20),
PRIMARY KEY(L_Codice),
FOREIGN KEY (L_Reparto) REFERENCES DEPARTMENT (R_codice)
)

CREATE TABLE BELONGS
(
A_Categoria CHAR (20),
A_Libro CHAR (13),
FOREIGN KEY (A_Categoria) REFERENCES CATEGORY (C_codice)
FOREIGN KEY ( A_Libro) REFERENCES BOOK (L_codice)
)



CREATE TABLE USER (
U_codice CHAR (20),
U_cognome CHAR (30) NOT NULL,
U_nome CHAR (30) NOT NULL,
U_indirizzo CHAR (60) NOT NULL ,
U_e_mail CHAR (30) NOT NULL,
U_password CHAR (12) NOT NULL,
U_numero_carta CHAR (30) NOT NULL,
U_tipo_carta CHAR (30) NOT NULL,
U_data_scadenza_carta DATE,
PRIMARY KEY (U_Codice)
)

CREATE TABLE INCARRELLO
(
Car_Libro CHAR (13),
Car_Utente CHAR (20),
Car_numero_copie INTEGER, BIT
Car_eliminato,
FOREIGN KEY (Car_Libro) REFERENCES BOOK (L_codice)
FOREIGN KEY (Car_Utente) REFERENCES USER (U_codice)
)


CREATE TABLE ORDER (
O_numero INTEGER,
O_data DATE NOT NULL,
O_stato CHAR (10),
O_data_evasione DATE,
O_fattura BIT,
O_Utente CHAR (20),
PRIMARY KEY (O_numero)
FOREIGN KEY (O_Utente) REFERENCES USER (U_codice)
)

CREATE TABLE INCLUDED
(
I_Libro CHAR (13),
I_Ordine INTEGER, INTEGER
I_numero_copie,
FOREIGN KEY (I_Libro) REFERENCES BOOK (L_codice)
FOREIGN KEY (I_Ordine) REFERENCES Order (O_numero)
)

Semi Formal Outfits Boots

AS 2007/08

STATEMENTS AND POSSIBLE TERMS OF SIGNIFICANCE REVEALED BY READING THE TEXT

the occasion of the International Informatics Olympiad 2008, the organizers want to make a computer system for the management of tenders and the "athletes".
The database must be capable of storing information

• of athletes, who may participate to races both individually and grouped in teams
• of races in various stages
• of locations of race

The Olympics provide a stage school (in each school participant), a regional, a national final and the international tender that will designate the winner and the winning team.

Applicants without the necessary additional assumptions, achieve:

1. analysis reference of reality by identifying possible solutions and choose the one that in its reasoned opinion is the most suitable to meet the specifications
2. a conceptual schema of the database
3. a logical database
4. the definition of the relations of the database language SQL
5. the following queries expressed in SQL:

• print a list of athletes grouped by teams for each phase
• named print of an athlete's results in several races in which he participated
• print the schedule of races
• print an information (name, school of origin, nationality) of the winner and the winning team
• print the standings for each race (with the same score Priority is given to younger athletes)
• update, for each stage (school-regional-national-international) any high scores
• calculate the average score obtained during the initial screening for each school
• print for each team the number of "athletes" el participants' average age

6. user interface that the candidate intends to propose to interact with the database and code in a programming language to choose a significant segment of the project realized.
7. a website that presents the public with the classification of different races.