This paper circulates around the core theme of Course Book: Fundamentals of Database Management Systems 2nd Edition together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Course Book: Fundamentals of Database Management Systems 2nd Edition
Please provide a step-by-step progression toward the desired product.
Though detailing, try to limit your product to within one to three pages.
1. A large bank has a headquarters location plus several branches in each city in a particular region of the country. As transactions are conducted at each branch, they are processed online against a relational database at headquarters. You have been hired as the bankâ€™s Director of Data Security. Design a comprehensive set of data security measures to protect the bankâ€™s data.
2. Canadian Maple Trees, Inc. has a distributed relational database with tables in computers in Halifax, Montreal, Ottawa, Toronto, and Vancouver. The database consists of twelve tables, some of which are replicated in multiple cities. Among them are tables A, B, and C, with the following characteristics.
Table A consists of 800,000 records and is located in Halifax, Montreal, and Vancouver.Table B consists of 100,000 records and is located in Halifax and Toronto.Table C consists of 20,000 records and is located in Ottawa and Vancouver.
Telecommunications costs among Montreal, Ottawa, and Toronto are relatively low, whiletelecommunications costs between those three cities and Halifax and Vancouver are relatively high.
A query is issued from Montreal that requires a join of tables A, B, and C. The query involves a single record from table A, 20 records from table B, and an undetermined number of records from table C. Develop and justify a plan for solving this query.