Search & Filtering
Faisalabad Electric Supply Company (FESCO) distributes and supplies electricity to about 4.50 million customers within its territory with a population over 26 million under a distribution license granted by National Electric Power Regulatory Authority (NEPRA). The main determinant of electricity bill in Pakistan is the number of units consumed. Usually, electricity companies charge different prices as per kilowatt hour (kWh) to residential users, small commercial users and industrial companies etc according to the units consumed. For example, the approximate schedule of electricity tariffs for residential users is 5.79 Rs/kWh for 001-100 units, 8.11 Rs/kWh for 101-200 units, 10.20 Rs/kWh for 201-300 units, 17.60 Rs/kWh for 301-700 units, and 20.70 Rs/kWh for above 700 units. For commercial users, the approximate schedule of electricity tariffs is 18 Rs/kWh for sanctioned load less than 5 kW and 19.68 Rs/kWh for sanctioned load 5 kW and above. Similarly, for industrial users, the schedule of electricity charges is different. Being a student of managerial economics, analyze the above case study carefully and identify which type of price discrimination is discussed in above case study. Also discuss the reason logically.
Consider the global relations EMP(ENAME, TITLE, CITY) and ASG(ENAME, PNAME, CITY, DUR). City in ASG is the location of the project of name PNAME (i.e., PNAME functionally determines CITY). Consider the local relations EMP1(ENAME, TITLE, CITY), EMP2(ENAME, TITLE, CITY), PROJ1(PNAME, CITY), PROJ2(PNAME, CITY) and ASG1(ENAME, PNAME,DUR). Consider query Q which selects the names of the employees assigned to a project in Rio de Janeiro for more than 6 months and the duration of their assignment.
(a) Assuming the GAV approach, perform query rewriting.
(b) Assuming the LAV approach, perform query rewriting using the bucket algorithm.
Consider the global relations EMP(ENAME, TITLE, CITY) and ASG(ENAME, PNAME, CITY, DUR). City in ASG is the location of the project of name PNAME (i.e., PNAME functionally determines CITY). Consider the local relations EMP1(ENAME, TITLE, CITY), EMP2(ENAME, TITLE, CITY), PROJ1(PNAME, CITY), PROJ2(PNAME, CITY) and ASG1(ENAME, PNAME,DUR). Consider query Q which selects the names of the employees assigned to a project in Rio de Janeiro for more than 6 months and the duration of their assignment.
(a) Assuming the GAV approach, perform query rewriting.
(b) Assuming the LAV approach, perform query rewriting using the bucket algorithm.
A development team is developing a special purpose application for some organization. The data is very large but relatively static. Data loss is an acceptable risk. Multiple users are accessing the application at the same time. File system and database system are two approaches which can be used to store data. Being a database expert, you are approached by the Team manager to help them in deciding which of the above mentioned data storage system will be more suitable for current scenario.
Suggest the storage system considering the above mentioned scenario with solid reasoning.
a) Suppose you own a clotting brand company with your name, then how will you manage the data of your customers, orders, contracts, accounts, fixed and running expenses efficiently?
b) Would you prefer electronic database over manual database? Why or Why not? List down at least three databases available in the market for commercial use.
c) Design the database for your clotting brand company using MS Access. Design tables (as mentioned in part a) with necessary fields (must include primary and foreign keys) and draw the ERD diagram. (Paste the image of ERD diagram using snipping tool in your answer sheet). Use query to fetch any specific information of your interest from more than one table (Paste the complete image using snipping tool in your answer sheet).
development team is developing a special purpose application for some organization. The data is very large but relatively static. Data loss is an acceptable risk. Multiple users are accessing the application at the same time. File system and database system are two approaches which can be used to store data. Being a database expert, you are approached by the Team manager to help them in deciding which of the above mentioned data storage system will be more suitable for current scenario.
Suggest the storage system considering the above mentioned scenario with solid reasoning.
A development team is developing a special purpose application for some organization. The data is very large but relatively static. Data loss is an acceptable risk. Multiple users are accessing the application at the same time. File system and database system are two approaches which can be used to store data. Being a database expert, you are approached by the Team manager to help them in deciding which of the above mentioned data storage system will be more suitable for current scenario.
a) Design the database for your clotting brand company using MS Access. Design tables (as mentioned in part a) with necessary fields (must include primary and foreign keys) and draw the ERD diagram. (Paste the image of ERD diagram using snipping tool in your answer sheet). Use query to fetch any specific information of your interest from more than one table (Paste the complete image using snipping tool in your answer sheet).
Rubrics (Scoring Guide)
- Knowledge = 40%
- Application = 30%
- Synthesis = 30%
Question Statement
A development team is developing a special purpose application for some organization. The data is very large but relatively static. Data loss is an acceptable risk. Multiple users are accessing the application at the same time. File system and database system are two approaches which can be used to store data. Being a database expert, you are approached by the Team manager to help them in deciding which of the above mentioned data storage system will be more suitable for current scenario.
Suggest the storage system considering the above mentioned scenario with solid reasoning.
Note: Your answer should not be exceeded than 8 lines.
Orchid bank is a private sector bank which has branches in different countries. Orchid bank uses database for the storage of clients’ data because databases can store very large numbers of records efficiently. By using database, we can add, edit or delete data easily. It is more efficient in data searching and data sorting. Database can be used by more than one user to access same data simultaneously.
As a database designer, which type of database (distributed database & centralized database) you will use in this scenario to ensure data consistency, easy management and easy backup?
Also, what you think that replication of database suitable in the above given scenario?
#339914 on Dec 2023