HW #1

#1. Design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session. The database needs to keep track of each U.S. STATE’s Name (e.g., ‘Illinois’, ‘Texas’, ‘New York’) and include the Region of the state (whose domain in {‘Northeast’, ‘Midwest’, ‘Southeast’, ‘Southwest’, ‘West’}). Each CONGRESS_PERSON in the House of Representatives is described by his or her name, plus the District represented, the Start_date when the congressperson was first elected, and the political Party to which he or she belongs (whose domain is {‘Republican’, ‘Democrat’, ‘Independent’, ‘Other’}). 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’}), and the Sponsor (the congressperson(s) who sponsored—that is, proposed—the bill). The database also keeps track of how each congressperson voted on each bill (domain of Vote attribute is {‘Yes’, ‘No’, ‘Abstain’, ‘Absent’}).

Draw an ER schema diagram for this application. State clearly any assumptions you make.

#2. A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game.

It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game.

Design an UML diagram for this application, stating any assumptions you make. Choose your favorite sport (soccer, football, baseball …).

#3. Consider the following requirements for a EVENT PORTAL application.

Design an ER schema for this application, and draw an ER diagram for that schema.

Specify key attributes of each entity type and structural constraints on each relationship type.

The EVENT PORTAL is website where you can advertise, view and make a booking for event by anywhere. You can do your necessary work related to events by this website just within few minutes. This application is trying to very easy for user to find venue by Google Map.

Event Portal System is an online event management system that serves the functionality of an event manager. The system allows only registered users to login and new users are allowed to resister on the application. The project provides most of the basic functionality required for an event. It allows the user to select from a list of event types. Once the user logged in and selects the event type.

Then system then allows the user to select the date and time of event and as well place of the event. All this data is stored in the database and the user is given a receipt for his booking. This data is then sent to the administrator (website owner) and they may interact with the client as per his requirements and his contact data stored in the database.

There are different modules in the project; main modules are administrator and user.

In administrator module there will be some sub modules like administrator can login and if he/she wants to view the updates then they can. And they can manage events and as well manage the place of an event and also he can give conformation mail to the user who is registered for any event from the website. In any case user forgot his password then administrator will provide new password to the user.

So in the user module if user wants to login then he can and the extra feature about this module is if user wants to create a new event then he can by his own. So all other users can register for the event provided by other user.HW #1

#1. Design an ER schema for keeping track of information about votes taken in the U.S. House of Representatives during the current two-year congressional session. The database needs to keep track of each U.S. STATE’s Name (e.g., ‘Illinois’, ‘Texas’, ‘New York’) and include the Region of the state (whose domain in {‘Northeast’, ‘Midwest’, ‘Southeast’, ‘Southwest’, ‘West’}). Each CONGRESS_PERSON in the House of Representatives is described by his or her name, plus the District represented, the Start_date when the congressperson was first elected, and the political Party to which he or she belongs (whose domain is {‘Republican’, ‘Democrat’, ‘Independent’, ‘Other’}). 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’}), and the Sponsor (the congressperson(s) who sponsored—that is, proposed—the bill). The database also keeps track of how each congressperson voted on each bill (domain of Vote attribute is {‘Yes’, ‘No’, ‘Abstain’, ‘Absent’}).

Draw an ER schema diagram for this application. State clearly any assumptions you make.

#2. A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game.

It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game.

Design an UML diagram for this application, stating any assumptions you make. Choose your favorite sport (soccer, football, baseball …).

#3. Consider the following requirements for a EVENT PORTAL application.

Design an ER schema for this application, and draw an ER diagram for that schema.

Specify key attributes of each entity type and structural constraints on each relationship type.

The EVENT PORTAL is website where you can advertise, view and make a booking for event by anywhere. You can do your necessary work related to events by this website just within few minutes. This application is trying to very easy for user to find venue by Google Map.

Event Portal System is an online event management system that serves the functionality of an event manager. The system allows only registered users to login and new users are allowed to resister on the application. The project provides most of the basic functionality required for an event. It allows the user to select from a list of event types. Once the user logged in and selects the event type.

Then system then allows the user to select the date and time of event and as well place of the event. All this data is stored in the database and the user is given a receipt for his booking. This data is then sent to the administrator (website owner) and they may interact with the client as per his requirements and his contact data stored in the database.

There are different modules in the project; main modules are administrator and user.

In administrator module there will be some sub modules like administrator can login and if he/she wants to view the updates then they can. And they can manage events and as well manage the place of an event and also he can give conformation mail to the user who is registered for any event from the website. In any case user forgot his password then administrator will provide new password to the user.

So in the user module if user wants to login then he can and the extra feature about this module is if user wants to create a new event then he can by his own. So all other users can register for the event provided by other user.