Entity Relationship Diagrams a) Draw an ER to represent the following: i) A device is identified by its model and serial number.

ii) A student is identified by student-no. There are only two types of students: domestic and international. A student cannot be both domestic and international. For international students the visa type is also stored.

b) Assume that the specifications below have been obtained from a user of an information system. You are required to construct a conceptual model of the database using the Entity Relationship Model. You can assume that the specification below is complete and contains all of the information that is needed to construct the model. Do not include any additional concepts of your own, over and above what is given in the specification. You may use either variant of the ER diagram notation, however, do not mix the notations.

The Junior Coach Allocation System is an online system that allows coaches to be appointed to junior soccer matches each weekend.

Coaches register in the system by providing their name, age, phone and address. Each coach is allocated a unique ID. Each of the soccer fields in Brisbane is allocated a venueID, map location, and name. Various soccer clubs register with the system by providing their club name and their home field. Teams are registered with their division and club name. Each club is only allowed one team per division, therefore the teams division is unique within the club. Each match played is given a unique ID and kickoff date and time. A match will have a home team and an away team. The match will be played at the home teams main field. Coaches may be appointed to one match each weekend.