The difference between (1) a database management system (DBMS) and (2) a database, is:     a. The first refers to a complete accounting system, the second refers to a subset of that b. The first is program software, the second is proprietary data and related files c. The first is hardware, the second is software d. Nothing—these terms are synonyms..

You are hired to design a complete database management system to address a practical database need and implementing a relational database based on that design.  Your database system should be designed to perform general information management tasks such as systematic collection, update, and retrieval of information for a small organization. (e.g., Library/video/bookstore) The starting point of your job is to identify a database need of a real or hypothetical client, and write answers to the following questions:  What is the purpose of the database?  Why is it needed?  What should it do? Who are the users and what are their information needs? What are the problems that the system should solve? What input data is available to the database? What kind of information should be stored in the database? You are also required to complete the following tasks, based on your proposed database management system in Q1. Business Rules (Min: 5) E-R Diagram Description of entities, attributes &…

The conceptual data model is the set of concepts that A. Describes the structure of a database and the associated retrieval transactions. B. Describes the structure of a database and the associated retrieval and update instructions. C. Is the actual implementation of the database, using a commercial DBMS. D. Describes the structure of a database and the associated insert and update transactions.

The difference between a database and an information system is that a database records information while an information system utilizes it. Is there any effect on database design with this relationship?

Question : Draw the EER diagram that describes the following scenario:     ( PLEASE EXPLAIN STEP BY STEP AND IN DETAIL)   We want to design a database for keeping track of information about votes taken is the PAKISTAN PROVISIONS in the current administration. They include the PARLIAMENT and the SENATE. A MINISTER in the PAKISTAN is either a Parliament Member or a Senator depending on to which body they are elected to. The database needs to keep track of each PAKISTAN CITY’s Name (e.g., ‘Lahore’, ‘Karachi’, ‘Multan’) and include the Region of the country to which the city belongs (whose domain is {‘Punjab’, ‘Sind’, ‘KPK’, ‘Baluchistan’}) and its population in the 170 million. Each MINISTER is described by his or her Name, plus the District represented, the Start_date when the parliament was first elected, and the political Party to which he or she belongs (whose domain is {‘PPP’, ‘PTI’, ‘PML(N)’, ‘PML(Q)’, ‘ANP’, ‘MQM’, ‘Independent’, ‘Other’}). A city can have a number of parliament…