Examen de Fin de Formation Théorie 2010 - TDI

Examen de Fin de Formation Théorie 2010 - TDI 

I – MODELISATION DE SI :

SupTIC est une école supérieure délocalisée au Maroc, spécialisée dans  la formation pointue dans le secteur des IT.
Les inscriptions fonctionnent de la façon suivante. :
Au début de chaque semestre, un catalogue des cours proposés est fourni par la Direction aux étudiants. Chaque cours est décrit par un certain nombre d'informations, en particulier : l'enseignant, le cursus et les prérequis.
Ce catalogue ne peut être créé avant que tous les cours ne soient affectés à des enseignants. Pour cela, chaque enseignant accède au système d'inscription pour indiquer les cours qu'il prévoit d'enseigner.
Les étudiants doivent remplir des fiches d'enregistrement qui indiquent leurs choix de cours. L'étudiant standard doit suivre 4 enseignements choisis dans le catalogue. Il devra indiquer aussi deux cours supplémentaires. En effet, il se peut que, parmi les 4 cours choisis, l'un des cours soit trop plein ou abandonné par manque d'étudiants. Chaque cours doit en effet être dispensé à au moins 5 étudiants et au plus 30 étudiants. Si un cours est choisi par moins de 5 étudiants, il est supprimé.
Ces fiches sont gérées par la scolarité. Une fois la période d’inscription terminée, un programme est exécuté pour affecter les étudiants aux cours. Dans la plupart des cas, les étudiants obtiennent ce qu’ils ont choisi. Après que tous les étudiants aient été correctement affectés aux différents cours, un listing est imprimé pour chaque étudiant pour vérification.
Une fois la sélection de cours d'un étudiant validée, l'information est transmise au système de facturation qui facturera l'étudiant pour son semestre.

1. Donner un diagramme des cas d'utilisation du système. (1.5 Pts)
2. Décrire un scénario principal par un diagramme de séquence. (2 Pts)
3. Donner un diagramme de classes (2 Pts)
4. Déduire un MCD (1.5 Pts)

II – SGBDR :

Une compagnie aérienne désire gérer l’ensemble de ses vols qu’elle met en service ainsi que les pilotes et les avions qui effectuent ces vols.
Le schéma de la base de données vous a été fournit comme suit :
Donner le code SQL permettant de :

Examen de Fin de Formation Théorie 2010 - TDI

1. Ajouter le champs Ville à la table PILOTE.  (0,25 pt)
2. Donner le nom des pilotes planifiés pour des vols sur A320. (0,25 pt)
3. Donner le nom des pilotes planifiés pour des vols sur A320, qui habitent dans la ville de localisation d’un A320. (0,25 pt)
4. Pour chaque ville desservie, donner la moyenne, le minimum et le maximum des capacités des avions qui sont localisés dans un aéroport desservant cette ville. (0,25 pt)
5. Dans la table VOL, créer un trigger en insertion qui vérifie que la ville d’arrivée est différente de la ville de départ et que l’heure d’arrivée est postérieure à l’heure de départ. Dans le cas contraire, on annule l’insertion.  (0.5 pt)
6. Créer une procédure stockée "Planning" qui affiche pour un nom et un prénom de pilote passés en paramètres, les numéros de vol, avec les aéroports de départ et d’arrivée, classés par date et heure de départ. (0.5 pt) 

III – RESEAUX INFORMATIQUES :

1. Qu’est ce qu’une adresse IP ? Quel est son rôle ? (0.5 pt)
2. Donnez la classe IP des adresses suivantes :  (0.75 pt)

Examen de Fin de Formation Théorie 2010 - TDI

3. Définir les éléments d’interconnexions suivants : (0.75 pt)
        a. cartes réseau
        b. concentrateurs
        c. commutateurs

IV – DEVELOPPEMENT WEB

1. Développer une fonction Javascript qui reçoit une matrice carrée de neuf lignes et neuf colonnes et vérifie que la somme des éléments de n’importe quelle ligne n est égale à la somme des éléments de la colonne n. (1 Pt)
2. Donner la DTD correspondante au document XML suivant : (2 Pts)

<liste>
<hotel code="1">
<nom>ADRAR</nom>
<adresse>Avenue Mohamed V</adresse>
<ville>AGADIR</ville>
<tel>028840437</tel>
<tel>028840717</tel>
<fax>028840545</fax>
</hotel>
<hotel code="2">
<nom>CHEMS</nom>
<adresse>1, Rue Houmane Fetouaki</adresse>
<ville>MARRAKECH</ville>
<tel>024444813</tel>
<tel>024444817</tel>
<tel>024444815</tel>
<fax>024440547</fax>
<fax>024 435400</fax>
<mail>chems@fram.fr</mail>
</hotel>
</liste>

V – PROGRAMMATION OBJET

Vous allez devoir participer à la conception et à la programmation d’une application de gestion d’un agenda. Un agenda électronique permet de mémoriser des événements, ponctuels (comme un examen de P.O.O. le mercredi 22 mai de 14h `a 16h) ou chroniques (comme un cours de P.O.O. tous les lundis, mardis, mercredis à partir du 18 janvier et pendant 6 semaines).
Un événement chronique est caractérisé  par les mêmes informations qu’un événement ponctuel, plus la périodicité (le nombre de jours auxquels un événement revient; par exemple, 7 pour un cours hebdomadaire) et le nombre de fois ou la périodicité est renouvelée.
Un agenda électronique appartient à une personne dont on mémorise le nom et le prénom.
Ensuite, il gère essentiellement la structure de données qui lui sert à mémoriser les événements.

1. Créer  les classes Evénement, EvenementChronique et EvenementPonctuel.(1.5 Pts)
        - Ecrivez tous les constructeurs nécessaires pour les événements, ainsi que les méthodes toString. 
2. Créer la classe Agenda.  (0.75 Pt)
3. Ajouter à la classe Agenda les méthodes. 
        - creerEvenementPonctuel (0.75 Pt)
        - creerEvenementChronique (0.75 Pt)
        - afficheEvenementsDuJour (0.75 Pt)
4. Ajouter une méthode de suppression d’un événement d une agenda.  (0.75 Pt)
5. Créer une classe de test   (0.75 Pt)

Télécharger L'Examen de Fin de Formation Théorie 2010 - TSDI :

en format .pdf sur le lien suivant :

Examens de fin de module : Anglais Technique

Anglais Technique

Examen Fin Module 1 :

The internet is responsable for the wide dissemination of information all over the world. It is perhaps the greatest invention of the 20th century and gives great power to its users.
The internet has its own culture. Its own way of communicating, no law enforcement, no national boundaries as well as free access to every kind of information know to mankind. It has become familiar to many children all every kind of information known to mankind. It has become familiar to many c hidren all over the world. Some of them use the internet everyday. Parents need to be in close touch with their kids as they explore the internet.
M oreover, teachers need to help students use it appropriately and safely.
Kids and teenagers need to learn to be responsible for their own behavior on the internet with guidance from their failies and communities. It's not at a ll uncommon for them to know more about the intenet and the computers than their parents or teachers. If that's the case in your home or classroom, don't despair. You can use this as an opportunity to turn the tables by having your chid teach you a thing or two about the internet. Get your children to talk to you about what's good and what is not reay good about the internet experience.
Just as adults need to help kids stay safe, they also need to earn not to ovvereact when they find out a child or a teenage has been surfing inappropriate materia or strayed from a rule. Don't blame or punish your kids if they tel you about an uncomfortable online encounter, Your best strategy is to work with them, so you both can learn from what happened and figure out how to keep it from happening again.
Adolescents and young adults have become the largest segment of the world population with internet access, for that reason, the threat posed by drug -related activities occurring on the internet is quite serious.
But the internet has so far serve as a very vauable tool to bring mankind closer together and to move some of the barriers inherent in the "real" world. It has had a great impact on those countris that have adopted its use provides some kind of measure of the gap between first world and third world countries.

I- Comprehension :
1- Are these sentences true or fase? Justify.
       a- There are legal restrictions to the internet.
       b- All children earn how to use the internet from their parents.
2- List two important advantages of the interenet?
3- What are two risks related to surfing on the internet?
4- How can parents protects children rom misusing the internet?
5- Find in the text words or expressions that mean :
       a- Change the situation to one's avantage. (parag3)
       b- Menace (parag5)

II- Language :
a- Write the correct from of the werbs in brackets :
       1- The office looks different. you (to move) the fumiture around?
       2- Last week, I (to have) too much work to do.
       3- Stephan (to join) the company two months ago.
b- Rewrite the following senteces as suggested:
       1- 'Where did you pass your holiday?'
       He asked her ...................
       2- They have reduced taxation.
       Taxation ...........................
3- He won't trave if he doesn't get the passport.
       Unless ..............................

III- Technical English :
a- what are the types of pinters that you know?
b- define terms and phrases.
Output devices - pixel - directory - formatting.
c- What do these abbreviations stan for?
AT - CAD - IBM - CPU - dpi - Laser.
d- Translate into French the folowing :
Workstation - backup - th graphica user interface - paste

IV- Writing :
What do you think about the internet? Write an essay to support your point of view.

Anglais Technique

Examen Fin Module 2 :

To reach the consumer, advertisers use a wide variety of media. In the United States, the most popular media, as measured by the amount of ad spending, are television, newspapers, direct mail, radio, magazines, the internet, outdoor advertising, and numerous other media.
In Canada, newspapers are the most popular medium, followed by television, magazines, radio, and other outdoor advertising. Canada is the ninth largest advertising market in the world.
In 1999 television attracted about 23 % of the advertising dollars spent in the US. Television is available to advertisers in two forms: broadcast and cable. Broadcast TV signals that are sent over the air rather than through cable wire-generates all of its revenues. Advertising accounts for about 60 % of cable television revenues with the rest coming from subscribers fees.
To run commercials on television, advertisers buy units of time known as spots. The standard units of time are 15.30 or 60 seconds in length. These spot are purchased either locally or from a national network. Because of the high cost of national network spots, ranging from hundreds of thousands o f dollars to millions of dollars, only large national can afford to run network television spot. advertisers wishing to reach a local audience, can buy from an individual station. But even these spots cost so much to produce and run that small and even mid-sized companies cannot afford them.
Because TV commercials combine sight, sound and motion, they are more dramatic than any other form of advertising and lend excitement and appeal t o ordinary products. But TV spots are too brief to provide much product information. As a result, TV works the best for products such as automobiles, fashion, food, beverages and credit cards that viewers are familiar with and easily understand.



I- COMPREHENSION :
A/ Find in the text words that have the same meaning as :
       1. Income :……………………………………………
       2. Advertisement :……………………………………………
       3. Accessible :……………………………………………
B/ Find in the text the opposite of:
       1. Don’t know #……………………………………………
       2. Earned #……………………………………………
       3. Sold #……………………………………………
C/ Answer the following questions.
       1. Give a title to the text.
       2. Why aren’t all national networks spots available to all advertisers?
       3. Do TV spots work for all products? Explain why?

II- LANGUAGE :
A/ Express the followings. Write the correct expressions and their answers.
       1- Ask a supplier give you a convenient discount.
A:…………………………………………………………………………………………………………………
B: ………………………………………………………………………………………………………………..
       2- Say your director is not available. Apologise and give a reason.
A:…………………………………………………………………………………………………………………
B: ………………………………………………………………………………………………………………..
       3- Offer your visitor something to drink. He/ she accepts or refuses.
A:…………………………………………………………………………………………………………………
B: ………………………………………………………………………………………………………………..
B/ Re-write these sentences as suggested.
       1- “Don’t play football in the street?”
The father ordered……………………………………………………………………………………………
       2- “Are you interested in TV advertisement?”
He asked me……………………………………………………………………………………………………
       3- Millions of viewers watch TV advertisements during prime time.
TV advertisements……………………………………………………………………………………………
       4- They will confirm their order tomorrow afternoon.
Their order……………………………………………………………………………………………………..
       5- If the office manager didn’t sign this document, the chairman would dismiss him
Unless ……………………………………………………………………………………………………………
       6- “When will you call him back?”
James asked his colleague………………………………………………………………………………..

Anglais Technique

Examen Fin Module 3 :

The effect of packaging and price on consumers
Packaging in certainly an inexpensive form of advertising It takes different forms It is either the container that protects the product or the product itself as the case with a cocker or a car. In order to attract customers a packaging must be carefully designed.
Packaging communicates in different ways. The material it is made of and the shape it takes mean a lot to the consumers. For instance, valuable articles such as jewellery and expensive perfumes have such a desirable packaging that consumers are often led to associate the product with a good q uality.
Similarly, price communicates in various forms. A low price is only the opportunity for consumers with a low income to buy the product mainly if it is used to a luxury. At the other extreme, other consumers tend to associate a low-priced product with poor quality. But this depends on the motives that s timulate consumers. For some, it is actually the quality that counts. For others, it is social prestige. Therefore they are ready to buy a product no matter how high its price is. Indeed they would buy it as long as it makes them feel important and enable them to make impressions on others.
M arketers are well aware of the fact and base their marketing campaign on it. “You get what you pay for ” has become the motto of most highly- priced brands in advertising.


A/ Choose the best alternative.
1- The effect
       a-The feeling
       b-The way
       c-The consequence
2-the motto
       a- a saying taken as a guide or advice
       b- riddle
       c-Proverb
3- Luxury
       a-A thing that’s expensive
       enjoyable, but not necessary
       b- a thing having bright colours
       c- A thing without value.
4- Campaign
       a-place where people camp
       b-Package and price.
       c-Commercial planned activities.

B/ Say true or false :
       1- Packaging is a way of advertising,
       2- Consumers buy only low price product.
       3- Packaging maybe the product itself.
       4- Consumers usually need low price and good quality.

C/ answer these questions in your own words:
       1-Does the packaging influence consumers? How ?
       2- low-price products are always associates with poor quality. Is it true? Why?
       3- In what ways are consumers different ?


Autres EFM (s) sur le lien suivant :