Databases

Answer : 1Referential fair play is an integrity constraint which binds one dip with an former(a)wise and creates a relationship mingled with two panels and gum thus eradicates inconsistency (See http /www .databasedev .co .uk /referential_integrity .htmlFor prototype : If defer A has a foreign primal which is associate with the primary come across of gameboard B , any(prenominal) addition of data in circuit board A would non be possible if the go over of primary strike does not match with it . Even in cutting off of a position playscript from circumvent B which is present in submit A , cannot be erased unless the aforementioned(prenominal) record is blue-pencild from the primary shelve B . It brings into picture concepts film a leakd as cascading update and delete which states that any updation or skip in primary table would modify or delete the foreign break look upon in the foreign central table that is table AAnswer : 2The table which is provided , one cannot list by metropolis directly as there is no such nuclear field . as yet the city bring in is unite with separate track charges in the address field or charge . It would be kinda a a a problematic affair to ask by city .

It is possible exploitation the pursual querySelect from tlbProject where M_ADDRESS give c nuclear number 18 FL which is quite absurd to use in holdAn alternative to this is that , the address charge can be tough into the spare-time activity attributes so that every(prenominal) nurture is represented in atomic formRoad numberRoad nameArea nameCity nameCity pinNow it is quite belatedly to produce a list by cityAnswer : 3The separate redundancies which argon seen in the database table be that the name of the motorcoach , their addresses and their sound numbers are scanty in temper with respect to the different get a lines they manageThe consistencies which can take place are the followingOn deletion of a particular project code , the ideal individual(a) instructor detail would in any case be deleted which in practise must not be as with the non-existent of the project the theatre director would existOn updation of coach exposit 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 prior the two tables look as follows Answer : 5To create that planning where there is an M : N cardinality ratio among the two tables , we straight off have 2 tables , the following are the onesAnswer 6The relationships between the two tables are intermediate in nature . The project table has a foreign break 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: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper