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 member, but only two senators. The database keeps track of each bill (i.e., proposed law), including the Bill_name, the Date_of_vote on the bill, whether the bill Passed_or_failed (whose domain is {‘Yes’, ‘No’}). A Bill may be sponsored by any number of MINISTERS including Parliamentarian and Senators. During the voting, a device is used to record the vote secretly. The database keeps track of how each parliamentary voted on each bill (domain of Vote attribute is {‘Yes’, ‘No’, ‘Abstain’, ‘Absent’}). [A BILL passed in the Assembly goes later to the Senate – but this is not represented in our database]
Question : Draw the EER diagram that describes the following scenario: ( PLEASE EXPLAIN STEP BY STEP AND IN DETAIL)
We want to design a
![Question : Draw the EER diagram that describes the following scenario:
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 member, but only two
senators. The database keeps track of each BILL (i.e., proposed law), including the Bill name,
the Date of vote on the bill, whether the bill Passed or failed (whose domain is {'Yes', No'}).
A Bill may be sponsored by any number of MINISTERS including Parliamentarian and
Senators. During the voting, a device is used to record the vote secretly. The database keeps
track of how each parliamentary voted on each bill (domain of Vote attribute is {'Yes', 'No',
'Abstain', 'Absent'}). [A BILL passed in the Assembly goes later to the Senate – but this is not
represented in our database]](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4c85fc0d-370a-481b-8fbf-bcf73464c203%2Fa9643d35-81b0-4e63-a8a8-8fca13a75e69%2Fv9ybenl_processed.jpeg&w=3840&q=75)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
