PostgreSQL

Brief description

PostgreSQL — DBMS open-source, which was based on code written at Berkeley. It supports most of the SQL standard and offers many modern features:

complex queries
foreign keys
triggers
modifiable views
transactional integrity
mnogovershinnoe

In addition, users can in every way to extend the capabilities of PostgreSQL, such as creating their

data types
functions
operators
aggregate functions
indexing techniques
procedural languages

Thanks to the free license, PostgreSQL is free of charge to use, modify, and distribute all for any purpose — personal, commercial or educational.

Basic references on the page Wiki

Lectures, courses, presentations, videos

Video

Recommended books

Software

Laboratory work and practical tasks

Option 1

To develop a database to automate the warehouse. The system must contain information on storage locations of the warehouse of goods about purchases and sales of goods. In addition, the structure of the database must provide the ability to store other information which, in the opinion of the student, relates to the subject area and tasks of the system under development.

Option 2

To develop a database for file storage online project. File archive contains music, movies and books in various formats. To access the files will need to register to download the file is available only for a fee. In addition, the structure of the database must provide the ability to store other information which, in the opinion of the student, relates to the subject area and tasks of the system under development.

Option 3

It is necessary to develop an information system of a shop selling mobile phones, the database which needs to contain the following information:

information about the phone: the manufacturer, phone model, body color, sale price, quantity, supplier, purchase цена;
information about the employees: name, surname, patronymic, position, home address, телефон;
sales data: what, how much and by whom of the employees продано;
information about suppliers: company name, legal address, phone, Fax.

In addition, the structure of the database must provide the ability to store other information which, in the opinion of the student, relates to the subject area and tasks of the system under development.

Option 4

It is necessary to develop an information system for milk kiosk, the database which needs to contain the following information: product information: product name, manufacturer, expiry date, retail price, quantity, supplier, purchase цена;

information about employees: name, surname, patronymic, position, home address, телефон;
sales data: what, how much and by whom of the employees продано;
information about suppliers: company name, legal address, telephone.

Option 5

It is necessary to develop an information system for car Park data base must contain the following information:

information about the places: case number, owner, car, sunshade (Yes/no);
owner information: name, address, телефон;
information about cars: brand, number, color, year.
payment information: case number, gross amount, debt.

Option 6

It is necessary to develop an information system for firms providing real estate services, a database which must contain the following information:

information on the property: type (house/apartment), address, owner, цена;
information about the apartments: etazhnost of the house, house project, floor, living area, number of rooms, condition (on a scale of 0-10);
information about the home: square footage, number of floors, floor area, number of rooms, condition.
owner information: name, TIN, address, phone sold недвижимость;
information about customers: name, TIN, address, telephone number, desired property type, maximum amount.

Option 7

It is necessary to develop an information system for firms providing repair of household appliances, the data base must contain the following information:

information about the technique in the repair of: category, name, failure, master, date, repair cost, number заказа;
information about the artists: full name, address, type of repair, number заказов;
owner information: name, address, phone number, and заказа;
information on the types of repairs.

Option 8

It is necessary to develop an information system for the bus fleet, a database which must contain the following information:

information about buses: model, book value, rooms, room маршрута;
information about the drivers: name, TIN, address, telephone, автобус;
schedule: route number, time, остановка;
information service station: model, Zap.part.

Option 9

It is necessary to develop an information system for video rental database which should contain the following information:

information about the film: title, year, Director, actors, genre, number прокатов;
information about pricing: the film, the cost проката;
information about the rental: client, collateral, film, start date of hire end date of hire.

Option 10

It is necessary to develop an information system for car rental data base must contain the following information:

vehicle information: make, number, year of manufacture, type of fuel, consumption l/HR, the residual value, the price of the rental in час;
customer information: customer, car, the start date of hire end date of hire, залог;
customer information: name, TIN, address, phone, passport.