Business information systems

T1. Draw an ERD in Crow’s foot notation based on the description below:
Aggro Military Academy uses a simple database to record students’ dorm assignment
information.
The database records information about each dorm provided by the school, including the unique
dorm number, dorm size, telephone#, and post address. Each student’s information is also kept
in the database, including his/her unique student number, first name, last name, home address,
home phone number, and dorm number.
Each student is assigned to 1 and only 1 dorm, but each dorm may accommodate multiple
students. No dorm is allowed to be vacant.
Use the following algorithm to accomplish the task:

1. Analyze business process
2. Identify components of DB model:
   a. Identify the entities (i.e., people, objects, events)
   b. Add the appropriate attributes to each entity
   c. Draw relationships among entities to show how they are associated with one another
   i. Identify modality
   ii. Identify cardinality
   iii. Identify primary key
   iv. Identify foreign key(s)
3. Draw ERD
   a. Use Crow’s foot notation
   b. Label all elements (entities, relationships, primary and foreign keys, cardinality, and
   modality)
4. Verify and validate your ERD.
5. Copy the most updated version of your ERD in the single .pdf file.
6. Name file MIS303-Section number_ERD Homework_LastName_FirstName.pdf and submit in
   ERD Homework on the course website.
   T2. Draw an ERD in Crow’s foot notation based on the description in Figure 1 below.
7. Resolve all unresolved M:N relationships and make respective changes to the diagram.
8. Verify and validate the ERD.
9. Copy the most updated version of your ERD in the single .pdf file and submit in ERD Homework
   on the course website.