Design Database | Materials kik online for computers, programming, design
I. Design of the database Description of the subject area Conceptual scheme of the database (objects / nature / - attributes, keys, links) Transition from KC to RBD RBD Analysis - conclusion of functional dependencies check normality of the relations and normalization of the same if necessary
II. Creating Sample data tables (requirements for data integrity) Creating Tables Creating the relations in DBMS Create reports kik online (Query) Creating forms (Forms) Create reports kik online (Reports)
The project is designed for the needs of the automotive insurance "Bulstrad" AD and just for insurance "civil liability" and "Casco". The system does not carry out accounting of financial transactions.
The following separate objects with their attributes: Cars (frame number, DBP (state control number) of the car brand of the car, the vehicle model Displacement, owner-name and surname); 2. Types of insurance kik online "Civil liability" (Code of insurance, Description, Price); Types of insurance "Casco" (Code of insurance Description); Insurance Agents (Code insurance kik online agent, Name, Address); Insurances "Civil Liability" (Order kik online No insurance policy number, frame number of the insured car insurance Code, Code of insurer, date of conclusion, date of entry into force, validity date, number written statement); kik online Insurance "Casco" (Order kik online No insurance policy kik online number, frame number of the insured car insurance Code, Code of insurer, date of conclusion, date of entry into force Expiration Date, Insurance amount Insurance premium).
The most commonly used model is the model database "Objects-Links". This is the model used in the current DBMS. It has a structure consisting of: objects and links. Objects in most cases form sets, and each set is a set of homogeneous elements, characterized kik online by properties that are called attributes. They should be arranged so as to contain one or more key attributes. By key attributes each element in the database is identified uniquely. This database key fields are: Number Rama Code insurance Casco Code, Code of insurer Numbering.
The actual model is built on a term - attitude (relation). Attitude is in many of the Cartesian product of the domains. Domain is simply a set of values. So the set of all cars form domain. Also domain is the set of all insurance agents. Cartesian product of domains is called the set of all tuples. In every respect relatsioniya model is presented in a table, kik online each tuple is her turn, and each pillar - attribute attitude.
To issue coursework respect will be cars with attributes frame number, kik online DBP, make, model, cylinder capacity Owner / name and surname / EGN / BULSTAT, tax number, address. kik online It will look as follows:
(Contains only sample data). Cars Number Rama DBP Brand Model Displacement Owner / name and surname / PIN / bulstat Tax number Address 15426 In 2255 AH Icarus 1 50 seats ET Multitrans 103,254,651 103,545,845 Varna bul.Primorki 75 2435485646 PP CP 4568 Mitsubishi Galant 2600 Kiril Yordanov Ivanov 4404045521 Varna, Tsar Liberator 18 252525abg25 In 5824 AK Audi 80 1800 Miglena Koleva Tsoneva 7505061011 Varna zh.k.Vladislavovo 18 A-5 25457854abgh In 5054 AC Mercedes 100SL 2500 Lora Petrova Dimova 6605250831 Varna jkCHajka 25 -A 16-AO 4545dss44s A 2564 Peugeot 505 800 Iliana Koleva Marinova 7704251113 Varna ul.Gen Kolev 56
Otherwise will be Insurance agents attributes kik online Code insurer Name of insurer Address of insurer Telephone. It will have the form: (contains only sample data). Insurance agents kik online Code insurer Name of insurer Address of insurer Telephone 01 Martin Draganov Todorov Bulgaria 50-27-24 02 Vesselin Dimov Kirova Varna Tsar Liberator 18 63-23-00 kik online 03 Krasimir Georgiev Penchev Varna 24-25-56
All such schemes derived form of RBD Scheme. Current values of the motorcade relations obtained in accordance with the constructed schemes form RBD. It is imperative to analyze well as RBD should avoid repetitions of data and redundant information. To avoid repetitions define etc. keys. The key can be internal or external. In relations, expressing the relationships of the type many to one (one to many) has repeats of data in only one part of tuples, kik online where the values of one attribute of the table. kik online Each such amount will be repeated as many times as there are objects on the side of the relationship much. To avoid these repetitions apply ability selecting or adding a new attribute to be a key attribute of a country. This attribute is called a foreign key
I. Design of the database Description of the subject area Conceptual scheme of the database (objects / nature / - attributes, keys, links) Transition from KC to RBD RBD Analysis - conclusion of functional dependencies check normality of the relations and normalization of the same if necessary
II. Creating Sample data tables (requirements for data integrity) Creating Tables Creating the relations in DBMS Create reports kik online (Query) Creating forms (Forms) Create reports kik online (Reports)
The project is designed for the needs of the automotive insurance "Bulstrad" AD and just for insurance "civil liability" and "Casco". The system does not carry out accounting of financial transactions.
The following separate objects with their attributes: Cars (frame number, DBP (state control number) of the car brand of the car, the vehicle model Displacement, owner-name and surname); 2. Types of insurance kik online "Civil liability" (Code of insurance, Description, Price); Types of insurance "Casco" (Code of insurance Description); Insurance Agents (Code insurance kik online agent, Name, Address); Insurances "Civil Liability" (Order kik online No insurance policy number, frame number of the insured car insurance Code, Code of insurer, date of conclusion, date of entry into force, validity date, number written statement); kik online Insurance "Casco" (Order kik online No insurance policy kik online number, frame number of the insured car insurance Code, Code of insurer, date of conclusion, date of entry into force Expiration Date, Insurance amount Insurance premium).
The most commonly used model is the model database "Objects-Links". This is the model used in the current DBMS. It has a structure consisting of: objects and links. Objects in most cases form sets, and each set is a set of homogeneous elements, characterized kik online by properties that are called attributes. They should be arranged so as to contain one or more key attributes. By key attributes each element in the database is identified uniquely. This database key fields are: Number Rama Code insurance Casco Code, Code of insurer Numbering.
The actual model is built on a term - attitude (relation). Attitude is in many of the Cartesian product of the domains. Domain is simply a set of values. So the set of all cars form domain. Also domain is the set of all insurance agents. Cartesian product of domains is called the set of all tuples. In every respect relatsioniya model is presented in a table, kik online each tuple is her turn, and each pillar - attribute attitude.
To issue coursework respect will be cars with attributes frame number, kik online DBP, make, model, cylinder capacity Owner / name and surname / EGN / BULSTAT, tax number, address. kik online It will look as follows:
(Contains only sample data). Cars Number Rama DBP Brand Model Displacement Owner / name and surname / PIN / bulstat Tax number Address 15426 In 2255 AH Icarus 1 50 seats ET Multitrans 103,254,651 103,545,845 Varna bul.Primorki 75 2435485646 PP CP 4568 Mitsubishi Galant 2600 Kiril Yordanov Ivanov 4404045521 Varna, Tsar Liberator 18 252525abg25 In 5824 AK Audi 80 1800 Miglena Koleva Tsoneva 7505061011 Varna zh.k.Vladislavovo 18 A-5 25457854abgh In 5054 AC Mercedes 100SL 2500 Lora Petrova Dimova 6605250831 Varna jkCHajka 25 -A 16-AO 4545dss44s A 2564 Peugeot 505 800 Iliana Koleva Marinova 7704251113 Varna ul.Gen Kolev 56
Otherwise will be Insurance agents attributes kik online Code insurer Name of insurer Address of insurer Telephone. It will have the form: (contains only sample data). Insurance agents kik online Code insurer Name of insurer Address of insurer Telephone 01 Martin Draganov Todorov Bulgaria 50-27-24 02 Vesselin Dimov Kirova Varna Tsar Liberator 18 63-23-00 kik online 03 Krasimir Georgiev Penchev Varna 24-25-56
All such schemes derived form of RBD Scheme. Current values of the motorcade relations obtained in accordance with the constructed schemes form RBD. It is imperative to analyze well as RBD should avoid repetitions of data and redundant information. To avoid repetitions define etc. keys. The key can be internal or external. In relations, expressing the relationships of the type many to one (one to many) has repeats of data in only one part of tuples, kik online where the values of one attribute of the table. kik online Each such amount will be repeated as many times as there are objects on the side of the relationship much. To avoid these repetitions apply ability selecting or adding a new attribute to be a key attribute of a country. This attribute is called a foreign key
No comments:
Post a Comment