Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the given description to create a conceptual design ( Conceptual model ) of mini _ SIIT Database The Student Affair Division of mini _
Use the given description to create a conceptual designConceptual model of miniSIIT Database
The Student Affair Division of miniSIIT would like to create a database system for storing the
records of students' club in the institute.
There are many clubs for miniSIIT students. Each club is identified by the name of the club. The
internal phone number of the club is being stored for the officers to contact. However, not every clubs
has the internal phone number. The room of each club is specific. Each club is located in different room
and building. The database analyst realized that there were a database of miniSIIT facilities in which the
room number is identified by the building number and the room number. The information of the
students that is name, student number, and phone number are used to identify the student. The student
number is a unique number that is assigned for each student of miniSIIT. For the club selection, it is not
a compulsory, and each student can be in more than one clubs. The club that does not have any member
will be closed. Therefore, the club must have at least one student.
From the above description, there are entities. Complete the conceptual design in the space
provided.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started