Create ERD or EERD of local school library with these requirements, and write relation schema (underline primary key and connect foreign key with arrow) (use Chen Notation) 1. Book : - there may be some title with many copy/books, so ISBN isn't unique. Librarian however create ID for each book to identified them. - book can have many author, each other name should be separable to navigate/searching when needed 2. Borrow : - only those with Membership can borrow - each borrow session you need to stored 'borrow date' and 'return date' so you can calculate 'penalty fee' if it's late 3. Membership - there are Expire date for each member - there are 4 types of membership : contributor, student, university staff, normal citizen. - Personal info include : CitizenID, (if they are student/university staff you need to store student ID and staffID too), Name, Address, Faculty, Telephone Number - citizen member can only borrow 3 book at maximum, studen 5, and staff 6, and contributor 5. Specification for the diagram: - describe what should be describe and what can be describe inside the diagram - also explain others that can be describe inside the diagram briefly (don't need to be long) - cardinality ratio, Entity types, keys, attributes, relationship types - decribe weak entity and string entity (should have at least 1 weak entity) - locate disjointness Constraints or total contraints (if required) - explain use of Generalization/Specialization Relationship
Create ERD or EERD of local school library with these requirements, and write relation schema (underline primary key and connect foreign key with arrow)
(use Chen Notation)
1. Book :
- there may be some title with many copy/books, so ISBN isn't unique. Librarian however create ID for each book to identified them.
- book can have many author, each other name should be separable to navigate/searching when needed
2. Borrow :
- only those with Membership can borrow
- each borrow session you need to stored 'borrow date' and 'return date' so you can calculate 'penalty fee' if it's late
3. Membership
- there are Expire date for each member
- there are 4 types of membership : contributor, student, university staff, normal citizen.
- Personal info include : CitizenID, (if they are student/university staff you need to store student ID and staffID too), Name, Address, Faculty, Telephone Number
- citizen member can only borrow 3 book at maximum, studen 5, and staff 6, and contributor 5.
Specification for the diagram:
- describe what should be describe and what can be describe inside the diagram
- also explain others that can be describe inside the diagram briefly (don't need to be long)
- cardinality ratio, Entity types, keys, attributes, relationship types
- decribe weak entity and string entity (should have at least 1 weak entity)
- locate disjointness Constraints or total contraints (if required)
- explain use of Generalization/Specialization Relationship
Step by step
Solved in 2 steps with 1 images
