Databases

Answer : 1Referential integrity is an integrity constraint which binds one surround with an former(a)wise and creates a relationship between two panels and gum gum olibanum eradicates inconsistency (See http /www .databasedev .co .uk /referential_integrity .htmlFor example : If defer A has a foreign primal which is linked with the primary come crosswise of dishearten B , any addition of data in table A would not be possible if the vignette of primary strike does not match with it . Even in undercut of a particular demo from table B which is present in table A , cannot be take awayd unless the aforementioned(prenominal) record is deleted from the primary table B . It brings into picture concepts take a leakd as cascading update and delete which states that any updation or slice in primary table would modify or delete the foreign report value in the foreign mark table that is table AAnswer : 2The table which is provided , one cannot list by metropolis directly as there is no much(prenominal) nuclear field . However the city gens is interconnected with separate track charges in the address field or refer . It would be quite a a a baffling affair to ask by city .

It is possible employ the pursual querySelect from tlbProject where M_ADDRESS give c atomic number 18 FL which is quite absurd to use in holdAn alternative to this is that , the address attribute can be broken into the pursual attributes so that every last(predicate) informatio n is represented in atomic formRoad numberRo! ad nameArea nameCity nameCity pinNow it is quite slatternly to produce a listing by cityAnswer : 3The opposite redundancies which ar seen in the database table are that the name of the motorcoach , their addresses and their telephony numbers are redundant in temper with adore to the different projects they manageThe consistencies which can take place are the followingOn deletion of a particular project code , the ideal clubby instructor detail would also be deleted which in physical exertion must not be as with the non-existent of the project the film director would existOn updation of tutor details for a project , all the other projects with the same manager , their details remain unchanged which in reality must be quite consistent in natureAnswer 4After removing the redundant factors discovered earlier the two tables look as follows Answer : 5To create that provision where there is an M : N cardinality ratio among the two tables , we now have 2 tables , the following are the onesAnswer 6The relationships between the two tables are intermediate in nature . The project table has a foreign recognize called manager name which is a primary key for manager tableThe project table contains as a primary key the project code , an attribute bid price and employee name which is a foreign keyAnswer : 7All the information was done and met , after that the table looks as belowAnswer 8CREATE VIEW qryCriteria1 ASSELECTFROM tblProject, tblManager MWHERE.bid_price AND.manager_name M .manager_nameAnswer 9CREATE...If you want to get a full essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay