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

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), ...