UML exercises: Exercises
Management reviews
Teachers Course Database of a faculty decided to create a database containing information on the results of the tests to students. To make the design
know that:
• Students are defined by their No registration, name and the group attending class.
· These students perform two types of tests throughout the academic year:
1. Exams written: Each student makes several along the way, and are defined by the No review, the number of questions that make up and the date of issue (the same for all students taking the same test). Obviously it is important to store the note of each student for review.
2. Practice: performed an unspecified number of them during the academic year, some will be in groups and other individuals. Defined by a code of practice, title, and the degree of difficulty. In this case the students can be examined from any practice whenever they want, debiƩndose store the date and grade obtained. If the practice has taken place in the group, all students in a same group get the same note on the practice.
• In terms of teachers, just want to know (other than your personal data (ID and name), who designed what, every practice, knowing that the design of a practice may work more than one and one teacher can design more than a practice. interesting, also the date on which each practice has been designed by the teacher concerned.
Car Dealer
A car dealer wants to computerize the management of vehicle sales. In particular they have cached information regard to customers who buy at the dealership, vehicles sold, as well as vendors that perform the various sales.
This should take into account the following points:
• The dealer has a catalog of vehicles described by make, model, engine capacity and price.
• Each one of the models have some additional options (air conditioning, metallic paint, etc.). The options are defined by a name and description. Keep in mind that an option may be common to several models varying only the price in each case.
• In terms of customers, relevant information is the name, ID number, address and telephone, as well as for sellers.
Customers will be giving your used car when buying a new vehicle. The car used is defined by make, model, registration and appraisal price. It is important to know the date on which the client performs this assignment.
· We want to know which vendor has sold what model to which client. Also the date of sale and registration of new vehicle and, if appropriate, the license plate used as part payment delivered. It is likewise important to know the options that the client has chosen for the model you purchase.
Summer Camps
camp organizers Summer asked us to design a database to collect data from the camp next summer. We talked to them, and we obtained the following specifications: The camp
accommodate children between 10 and 14 years. Each child interested in attending will open a registration form which contains your name, age, address, parents name a contact number and who is studying education (primary or ESO).
When summer arrives, the children who are enrolled in primary school will be housed in cabins while children are enrolled ESO will be staying in tents. These tents and cabins have different numbers of seats. In addition, once you close the registration period will be teams of children to perform in a team the activities in the camp.
A activity of a group will be guided by a monitor. To this end, the camp has a group of monitors and a set of planned activities so that each group will never repeat business, monitor the same activity will never lead to two different groups and a group two activities will never make the same monitor.
When the date is fixed early in camp organizers will contact the monitors to communicate together with activities to develop and that groups have to develop them. Also at this time will be announced from lists obtained from the database and to indicate for each child, the group has been assigned and the tent or hut in which they hosted.
Saturday, February 28, 2009
Friday, January 2, 2009
Planet Pinball On Funbrain
Betty Poetry Fantini
CAYASTACITO
Village
loved.
Sun Plaza. Green. Chrysanthemums
everywhere. Campos
greenup.
dusty streets of the summer.
Cayastacito:
beloved Village. Birds
of pink flooded the road.
And in the evening on the river
Flocks of ducks and ibises,
tuyangos Far away ...
In trees, branches dotted with bruises. Flocks
swiftly moving away, Partridge
rising whistling as we passed. Cock
water.
Hares in crazy night race
Formerly
bizcachas. Teru teru
The rampage is hiding its nest.
The aromitos bloom. All nature
dunk over you like a blanket.
no longer your visitor Sunday
sighs
Having found the curve of your church belfry.
His last Sunday, God wanted
Where was there was happy,
Enjoying in your fields.
For once, the flowers were his enthusiasm.
He chose them.
The Cayastacito chose from.
Goralski, Lazzaroni, Bengochea,
many fields will keep his footsteps!
El Tigre, The Lions.
Her figure reflected in the gaps. Miro
far to walk slow Here comes
With his gun discharged.
A bunch of partridges
Bonelli In
tied to his waist
The sun goes ...
So God intended it ...
Cardinals
Partridge,
cock in the stream water
Sun and off ...
Cayastacito: Our
family loves you.
Cayastacito:
We absence linking to you The heart
overwhelms us!
In memory of Daniel Guillermo Velasquez (Black or Nene) for whom the town was a balm Cayastacito. Betty
Fantini
Ci.Es.Pa
Writers Circle Paivenses
BACK TO CAYASTACITO
CAYASTACITO
Village
loved.
Sun Plaza. Green. Chrysanthemums
everywhere. Campos
greenup.
dusty streets of the summer.
Cayastacito:
beloved Village. Birds
of pink flooded the road.
And in the evening on the river
Flocks of ducks and ibises,
tuyangos Far away ...
In trees, branches dotted with bruises. Flocks
swiftly moving away, Partridge
rising whistling as we passed. Cock
water.
Hares in crazy night race
Formerly
bizcachas. Teru teru
The rampage is hiding its nest.
The aromitos bloom. All nature
dunk over you like a blanket.
no longer your visitor Sunday
sighs
Having found the curve of your church belfry.
His last Sunday, God wanted
Where was there was happy,
Enjoying in your fields.
For once, the flowers were his enthusiasm.
He chose them.
The Cayastacito chose from.
Goralski, Lazzaroni, Bengochea,
many fields will keep his footsteps!
El Tigre, The Lions.
Her figure reflected in the gaps. Miro
far to walk slow Here comes
With his gun discharged.
A bunch of partridges
Bonelli In
tied to his waist
The sun goes ...
So God intended it ...
Cardinals
Partridge,
cock in the stream water
Sun and off ...
Cayastacito: Our
family loves you.
Cayastacito:
We absence linking to you The heart
overwhelms us!
In memory of Daniel Guillermo Velasquez (Black or Nene) for whom the town was a balm Cayastacito. Betty
Fantini
Ci.Es.Pa
Writers Circle Paivenses
BACK TO CAYASTACITO
Tuesday, October 21, 2008
What Household Products Are Good For Masterbation
BDII ER Diagrams: Second year of MySQL
Within a database called COMPANY (tables employees, suppliers and branch), do the following MySQL: Build
tables: EMPLOYEE
(EMPLOYEEIDNO, name, experience, profession , salary, cod_sucursal), being EMPLOYEEIDNO the primary key and cod_sucursal the foreign.
SUPPLIER (RIF, nombre_prov, city, cod_sucursal), with RIF the primary key and cod_sucursal the foreign. BRANCH
(cod_sucursal, nombre_sucursal, cant_empleados, city), being cod_sucursal the primary key. Show
sorted alphabetically by name of employees who work in Caracas.
city for each registered branch count the number of existing branches. Show
name, salary and employee code whose name begins with A, B and G.
Show the number of employees assigned to each registered branch. Show
employee data that have not been assigned to any branch.
Add a column called by the EMPLOYEE table . Assign a value for each case.
value for each position available, show the maximum salary earned by employees. Show
data provider with offices in Caracas that have employees registered with pay between 1000 and 2000 Bs.F
Within a database called COMPANY (tables employees, suppliers and branch), do the following MySQL: Build
tables: EMPLOYEE
(EMPLOYEEIDNO, name, experience, profession , salary, cod_sucursal), being EMPLOYEEIDNO the primary key and cod_sucursal the foreign.
SUPPLIER (RIF, nombre_prov, city, cod_sucursal), with RIF the primary key and cod_sucursal the foreign. BRANCH
(cod_sucursal, nombre_sucursal, cant_empleados, city), being cod_sucursal the primary key. Show
sorted alphabetically by name of employees who work in Caracas.
city for each registered branch count the number of existing branches. Show
name, salary and employee code whose name begins with A, B and G.
Show the number of employees assigned to each registered branch. Show
employee data that have not been assigned to any branch.
Add a column called by the EMPLOYEE table . Assign a value for each case.
value for each position available, show the maximum salary earned by employees. Show
data provider with offices in Caracas that have employees registered with pay between 1000 and 2000 Bs.F
Friday, October 17, 2008
Pokemon White Version Gameshark
BDI: Third year
Library
Suppose we want to design a database for a library and we knew that This works as follows:
• In the library are, of course, a series of books that employees seek to publishers. When a book is received is given high building him a tab to search by author and another tab to search by topic. In both tabs appear the title of the book, the author's name and nationality, the publisher that owns the publication, the issue that is, the ISBN and the shelf of the library is located. It should be noted that in the library are not repeated copies of any book. The shelves of the library have a number and an assigned place within the library. An employee may request a book by writing a letter of request the publisher concerned. The address has to address the letter is on file publishers.
• To access the library books is necessary to hold a card attesting to the different users. This card is tailored to each person the first time you try to remove a book. Each user can only be removed than one book at each instant of time. The maximum time that a user can have a book is 10 days. After which the user will be penalized by a fine of 1 euro for each day of delay in repayment, during the first 3 days and suspension of license from the fourth day for a while which may be established by the library staff in light of the circumstances that wish to consider.
• In the library would like to have a list to be launched at the end of each day and which appear, for each book that is removed, the title, ISBN, author and license number, name and the user identification number that remains withdrawn
• When a user tries to remove a book is to present your card to take note of the withdrawal. If the book you want user A is not available because it was removed by another user B, taking note of the book and the user A to phone and tell when the book has been returned. In this case, user A may request that you reserve the book for up to 2 days to prevent another user from removing it before A can go to the library to remove. After this deadline, if A has not withdrawn, the book will be available to any user.
· The Library staff want to get statistics on: penalties of users (people punished, penalized for a longer time user, ...), loans (sometimes rendered more books, more books user who has retired, people who have withdrawn a same book more than once ...), casual users (users who repeatedly have reserved a book that have not passed then remove), ...
Library
Suppose we want to design a database for a library and we knew that This works as follows:
• In the library are, of course, a series of books that employees seek to publishers. When a book is received is given high building him a tab to search by author and another tab to search by topic. In both tabs appear the title of the book, the author's name and nationality, the publisher that owns the publication, the issue that is, the ISBN and the shelf of the library is located. It should be noted that in the library are not repeated copies of any book. The shelves of the library have a number and an assigned place within the library. An employee may request a book by writing a letter of request the publisher concerned. The address has to address the letter is on file publishers.
• To access the library books is necessary to hold a card attesting to the different users. This card is tailored to each person the first time you try to remove a book. Each user can only be removed than one book at each instant of time. The maximum time that a user can have a book is 10 days. After which the user will be penalized by a fine of 1 euro for each day of delay in repayment, during the first 3 days and suspension of license from the fourth day for a while which may be established by the library staff in light of the circumstances that wish to consider.
• In the library would like to have a list to be launched at the end of each day and which appear, for each book that is removed, the title, ISBN, author and license number, name and the user identification number that remains withdrawn
• When a user tries to remove a book is to present your card to take note of the withdrawal. If the book you want user A is not available because it was removed by another user B, taking note of the book and the user A to phone and tell when the book has been returned. In this case, user A may request that you reserve the book for up to 2 days to prevent another user from removing it before A can go to the library to remove. After this deadline, if A has not withdrawn, the book will be available to any user.
· The Library staff want to get statistics on: penalties of users (people punished, penalized for a longer time user, ...), loans (sometimes rendered more books, more books user who has retired, people who have withdrawn a same book more than once ...), casual users (users who repeatedly have reserved a book that have not passed then remove), ...
Subscribe to:
Posts (Atom)