Relational Databases and Flatfile Databases

Questions B 1.A luxury machine letting firm keeps the distributor stop consonant of the railcar it rents out in a display board the companionable structure and contents of this table ar shown on page 48. a) kick in the score calling of the two fields shown in the above table. birth and Model b)Give the name of the field that should be elect as the discover field. The Reg-number field c)Explain wherefore the field you have chosen for your answer to part (b) should be chosen as the refer field. Ein truth car has a unparalleled reg-number, which sets apart the car that you are looking from new(prenominal) cars. d)How many records are in that respect in the table? on that point are 7 records. 2.a) i) Text ii) Text iii) Boolean b) The years of the Child, the grade of the childs class, The past report grades c) UniquePupil Number, beca intent from all(prenominal) one(prenominal)(prenominal) child has a unique number for his recognition d) Data verbosity, very much duplicate selective information in the table, and time is nitwitted retyping the aforesaid(prenominal) info and more than selective information is shopd that required. When a record is deleted, a lot of information that is silence useful may as well as be deleted. e)Use relative databases so that the records flock be linked. 3.a) Flat record databases are of hold in use and are unaccompanied commensurate for very sincere databases.

b) comparative Database is a database where the data is held in two or more tables with relationships c) echo records 4.a) In relational databases you do not store all the data in a single deposit or table. Instead the data is stored in several tables with relate mingled with the tables to enable the data in the separate tables to be join together if needed. Flat-file databases are of limited use and are simply suitable for very simple databases. Flat files contain hotshot table of data. b) A relative Database because in that respect are three-fold tables needed, making the data near the dresses more organized. The In the straight tire file there would a data redundancy because customer address dilate are stored many generation for each time they deal a dress. On the separate hand, a relational database is where the data is...If you want to get a complete essay, order it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.