question number 14

True b) False Part2:8 points for each, 64 points for total 13) Which one of the following is not an advantage of using a DBMS? a) Data can be shared, read and written by multiple users. b) Only authorised access to data is permitted. c) Different external views of the same data can be provided d) It is always cheaper, in terms of an initial investment of both time and money, to use a DBMS to e) All of the above are advantages. 14) Consider the following ER diagram. O n ISBN Location (0.n) (0.1) O Store Purchases Book (0 m) Name ID Customer O When mapped to the relational model, which schema would correspond to the Purchases relationship a) Purchases (Location, ISBN, ID) b) Purchases (Location, ISBN, ID) c) Purchases (Location, ISBN, ID) d) Purchases (Location, ISBN, ID) 15) The relation truck (name, id) has 100 tuples. The name column is non-null. How many tup the following query produce (choose the most precise answer)? 23) Consider the following sequence That is the resulting schema? a) part (pid, name); supplies (pid, sid)