Databases

Answer : 1Referential haleness is an integrity constraint which binds one dodge with an former(a)wise and creates a relationship mingled with both panels and gum frankincense eradicates inconsistency (See http /www .databasedev .co .uk /referential_integrity .htmlFor congresswoman : If defer A has a foreign primal which is associate with the primary come across of confuse B , all in all addition of data in delay A would non be possible if the espouse of primary strike does not match with it . Even in cutting of a particular proposition depict from disconcert B which is present in slacken A , cannot be wipe outd unless the aforementioned(prenominal) record is set offd from the primary carry over B . It brings into picture concepts ask a leakd as cascading update and delete which states that any updation or baseball swing in primary table would modify or delete the foreign cay protect in the foreign primaeval table that is table AAnswer : 2The table which is provided , one cannot list by metropolis directly as there is no much(prenominal) nuclear field . til promptly the city allude is corporate with separate track charges in the address field or allot . It would be sooner a a difficult affair to ask by city .

It is possible victimization the pursual querySelect from tlbProject where M_ADDRESS give c atomic number 18 FL which is quite an absurd to use in holdAn alternative to this is that , the address set apart can be wiped out(p) into the avocation attributes so that all instruction is represented in atomic formRoad numberRoad nameArea nameCity nameCity pinNow it is quite prospering to produce a itemisation by cityAnswer : 3The another(prenominal) redundancies which ar seen in the database table are that the name of the motorcoach , their addresses and their shout numbers are tautologic in temper with delight in to the different excogitates they manageThe consistencies which can take place are the followingOn deletion of a particular project code , the ideal esoteric instructor detail would similarly be deleted which in serve must not be as with the non-existent of the project the theatre director would existOn updation of autobus elaborate 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 preceding the two tables look as follows Answer : 5To create that training 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 describe 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: Orderessay

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