For this project, I have selected the organization "ABC Manufacturing Company."
1. Entities and their attributes:
- Employee:
- Employee ID (attribute)
- Name (attribute)
- Position (attribute)
- Department (attribute)
- Salary (attribute)
- Product:
- Product ID (attribute)
- Name (attribute)
- Description (attribute)
- Price (attribute)
- Category (attribute)
- Customer:
- Customer ID (attribute)
- Name (attribute)
- Address (attribute)
- Phone Number (attribute)
- Email (attribute)
- Order:
- Order ID (attribute)
- Order Date (attribute)
- Total Price (attribute)
- Payment Method (attribute)
- Delivery Address (attribute)
2. Degree of their relationship:
- Employee and Department have a one-to-many relationship. An employee can belong to only one department, but a department can have multiple employees.
- Product and Category have a one-to-many relationship. A product can belong to only one category, but a category can have multiple products.
- Customer and Order have a one-to-many relationship. A customer can place multiple orders, but each order is placed by one customer.
- Order and Product have a many-to-many relationship. An order can have multiple products, and a product can be included in multiple orders.
Cardinalities and Constraints:
- Employee and Department: Every employee must belong to one department, and a department can have zero or more employees.
- Product and Category: Every product must belong to one category, and a category can have zero or more products.
- Customer and Order: Every order must be placed by one customer, and a customer can have zero or more orders.
- Order and Product: An order can include multiple products, and a product can be included in multiple orders. However, each product-quantity combination in an order must be unique (no duplicate products with the same quantity in an order).
Select ONE organization For your project
1.Identify the entities and their attributes
2. Identify the degree of their relationship
Identify their cardinalities and
Constraints
5 answers
project college student dorm.
1. Identify the entities and their attributes
2. Identify the degree of their relationship
3. Identify their cardinalities
Constraints
1. Identify the entities and their attributes
2. Identify the degree of their relationship
3. Identify their cardinalities
Constraints
1. Entities and their attributes for a college student dorm project:
- Dormitory:
- Dormitory ID (attribute)
- Dormitory Name (attribute)
- Location (attribute)
- Capacity (attribute)
- Room:
- Room ID (attribute)
- Room Number (attribute)
- Occupancy (attribute) - indicates if the room is currently occupied or vacant
- Capacity (attribute)
- Student:
- Student ID (attribute)
- Name (attribute)
- Gender (attribute)
- Age (attribute)
- Major (attribute)
- Year of Study (attribute)
2. Degree of their relationship:
- Dormitory and Room: A dormitory can have multiple rooms, but a room can belong to only one dormitory. This is a one-to-many relationship.
- Room and Student: A room can have multiple students, but a student can only belong to one room. This is a one-to-many relationship.
3. Cardinalities and Constraints:
- Dormitory and Room: Every room must belong to one dormitory, and a dormitory can have zero or more rooms.
- Room and Student: Every student must belong to one room, and a room can have zero or more students. However, each room can only accommodate a certain maximum number of students as defined by its capacity attribute.
Constraints:
- Room Capacity Constraint: The number of students in a room cannot exceed the room's capacity.
- Gender Constraint: Depending on the dormitory policy, rooms can be designated for specific genders. In this case, there might be a constraint that limits the occupancy of a room to only one gender.
- Occupancy Constraint: A room can be marked as occupied or vacant. This constraint ensures that each student is assigned to an available (vacant) room.
- Dormitory:
- Dormitory ID (attribute)
- Dormitory Name (attribute)
- Location (attribute)
- Capacity (attribute)
- Room:
- Room ID (attribute)
- Room Number (attribute)
- Occupancy (attribute) - indicates if the room is currently occupied or vacant
- Capacity (attribute)
- Student:
- Student ID (attribute)
- Name (attribute)
- Gender (attribute)
- Age (attribute)
- Major (attribute)
- Year of Study (attribute)
2. Degree of their relationship:
- Dormitory and Room: A dormitory can have multiple rooms, but a room can belong to only one dormitory. This is a one-to-many relationship.
- Room and Student: A room can have multiple students, but a student can only belong to one room. This is a one-to-many relationship.
3. Cardinalities and Constraints:
- Dormitory and Room: Every room must belong to one dormitory, and a dormitory can have zero or more rooms.
- Room and Student: Every student must belong to one room, and a room can have zero or more students. However, each room can only accommodate a certain maximum number of students as defined by its capacity attribute.
Constraints:
- Room Capacity Constraint: The number of students in a room cannot exceed the room's capacity.
- Gender Constraint: Depending on the dormitory policy, rooms can be designated for specific genders. In this case, there might be a constraint that limits the occupancy of a room to only one gender.
- Occupancy Constraint: A room can be marked as occupied or vacant. This constraint ensures that each student is assigned to an available (vacant) room.
project university student dorm.
1. Identify the entities and their attributes
2. Identify the degree of their relationship
3. Identify their cardinalities
Constraints
1. Identify the entities and their attributes
2. Identify the degree of their relationship
3. Identify their cardinalities
Constraints
1. Entities and their attributes for a university student dorm project:
- Dormitory:
- Dormitory ID (attribute)
- Dormitory Name (attribute)
- Location (attribute)
- Capacity (attribute)
- Room:
- Room ID (attribute)
- Room Number (attribute)
- Occupancy (attribute) - indicates if the room is currently occupied or vacant
- Capacity (attribute)
- Student:
- Student ID (attribute)
- Name (attribute)
- Gender (attribute)
- Age (attribute)
- Major (attribute)
- Year of Study (attribute)
2. Degree of their relationship:
- Dormitory and Room: A dormitory can have multiple rooms, but a room can belong to only one dormitory. This is a one-to-many relationship.
- Room and Student: A room can have multiple students, and a student can belong to only one room. This is a many-to-one relationship.
3. Cardinalities and Constraints:
- Dormitory and Room: Every room must belong to one dormitory, and a dormitory can have zero or more rooms.
- Room and Student: Every student must belong to one room, and a room can have zero or more students. However, each room can only accommodate a certain maximum number of students as defined by its capacity attribute.
Constraints:
- Room Capacity Constraint: The number of students in a room cannot exceed the room's capacity.
- Gender Constraint: Depending on the dormitory policy, rooms can be designated for specific genders. In this case, there might be a constraint that limits the occupancy of a room to only one gender.
- Occupancy Constraint: A room can be marked as occupied or vacant. This constraint ensures that each student is assigned to an available (vacant) room.
- Year of Study Constraint: Depending on the university's policies, rooms might be designated for specific years of study (e.g., freshman-only dorms). In this case, there might be a constraint that limits the occupancy of a room to students of a specific year of study.
- Dormitory:
- Dormitory ID (attribute)
- Dormitory Name (attribute)
- Location (attribute)
- Capacity (attribute)
- Room:
- Room ID (attribute)
- Room Number (attribute)
- Occupancy (attribute) - indicates if the room is currently occupied or vacant
- Capacity (attribute)
- Student:
- Student ID (attribute)
- Name (attribute)
- Gender (attribute)
- Age (attribute)
- Major (attribute)
- Year of Study (attribute)
2. Degree of their relationship:
- Dormitory and Room: A dormitory can have multiple rooms, but a room can belong to only one dormitory. This is a one-to-many relationship.
- Room and Student: A room can have multiple students, and a student can belong to only one room. This is a many-to-one relationship.
3. Cardinalities and Constraints:
- Dormitory and Room: Every room must belong to one dormitory, and a dormitory can have zero or more rooms.
- Room and Student: Every student must belong to one room, and a room can have zero or more students. However, each room can only accommodate a certain maximum number of students as defined by its capacity attribute.
Constraints:
- Room Capacity Constraint: The number of students in a room cannot exceed the room's capacity.
- Gender Constraint: Depending on the dormitory policy, rooms can be designated for specific genders. In this case, there might be a constraint that limits the occupancy of a room to only one gender.
- Occupancy Constraint: A room can be marked as occupied or vacant. This constraint ensures that each student is assigned to an available (vacant) room.
- Year of Study Constraint: Depending on the university's policies, rooms might be designated for specific years of study (e.g., freshman-only dorms). In this case, there might be a constraint that limits the occupancy of a room to students of a specific year of study.
1 answer