CIDM 3350 Assignment #1: Modeling

Objective: Assess your understanding of data modelling and use of ER diagrams

Skills needed: given a system description, you'll need to Know how to create conceptual data model by:

Identifying the main entities of the system and their attributes

Identifying the relationships between the system entities

Identifying the cardinality and ordinality of relationships

Creating ER diagrams for the system to show how the Entities interact

Creating ERDs using Chen and Crows foot notations.

Using software tool to draw ER diagrams (e.g. draw.io)

Requirements & Submission:

Use Draw.io

Task:

Your task is to create the best and most efficient ER model for a database of library management system using the requirement description below. You need to provide two ER models for the described system, one conceptual model using Chens notation ERD and one logical model using Crows Foot notation ERD.

Your ERDs should include

The main entities and their attributes, and must show the primary key attribute(s) of each entity

All the relationships between the entities, and the cardinality, optionality, and the attributes (if the relationship has any) of each relationship.

The deliverable: is ONE pdf file contains the two ERD diagrams as follows:

ERD1: The conceptual level ERD using Chens notation. Should include the entities and their attributes, and the

relationships and their cardinalities, attributes, and optionality (ordinality)

ERD2: The logical level ERD using Crows Foot notation. Should be detailed and include the entities, their attributes, the PKs, the mapped FKs, the relationships and their cardinalities, attributes, and optionality. All Many-to-Many relationships (if there is any) should be mapped into a new table (associative entity).

Add any text you would like to include to justify or explain any assumptions youve made in your design that were not mentioned in the system description.

Library system description:

ABC library is asking you to help in designing a system that manages and tracks the borrowing records of their books. The system should maintain information about the books and their associated copies, the library members (Borrowers), and the borrowing transaction records (i.e. checkout and return of book copies). The library provides book loaning service to registered members. The library may have multiple copies of the same book, so it maintains information about both books and their copies. Each book is described by title, edition, and year of publication, and a unique ISBN number. The library assigns a unique serial number for each book copy to help tracking it. The library also maintains a record for each book

CIDM 3350 Assignment #1: Modeling

Objective: Assess your understanding of data modelling and use of ER diagrams

Skills needed: given a system description, you'll need to Know how to create conceptual data model by:

Identifying the main entities of the system and their attributes

Identifying the relationships between the system entities

Identifying the cardinality and ordinality of relationships

Creating ER diagrams for the system to show how the Entities interact

Creating ERDs using Chen and Crows foot notations.

Using software tool to draw ER diagrams (e.g. draw.io)

Requirements & Submission:

Use Draw.io

Task:

Your task is to create the best and most efficient ER model for a database of library management system using the requirement description below. You need to provide two ER models for the described system, one conceptual model using Chens notation ERD and one logical model using Crows Foot notation ERD.

Your ERDs should include

The main entities and their attributes, and must show the primary key attribute(s) of each entity

All the relationships between the entities, and the cardinality, optionality, and the attributes (if the relationship has any) of each relationship.

The deliverable: is ONE pdf file contains the two ERD diagrams as follows:

ERD1: The conceptual level ERD using Chens notation. Should include the entities and their attributes, and the

relationships and their cardinalities, attributes, and optionality (ordinality)

ERD2: The logical level ERD using Crows Foot notation. Should be detailed and include the entities, their attributes, the PKs, the mapped FKs, the relationships and their cardinalities, attributes, and optionality. All Many-to-Many relationships (if there is any) should be mapped into a new table (associative entity).

Add any text you would like to include to justify or explain any assumptions youve made in your design that were not mentioned in the system description.

Library system description:

ABC library is asking you to help in designing a system that manages and tracks the borrowing records of their books. The system should maintain information about the books and their associated copies, the library members (Borrowers), and the borrowing transaction records (i.e. checkout and return of book copies). The library provides book loaning service to registered members. The library may have multiple copies of the same book, so it maintains information about both books and their copies. Each book is described by title, edition, and year of publication, and a unique ISBN number. The library assigns a unique serial number for each book copy to help tracking it. The library also maintains a record for each book

CIDM 3350 Assignment #1: Modeling

Objective: Assess your understanding of data modelling and use of ER diagrams

Skills needed: given a system description, you'll need to Know how to create conceptual data model by:

Identifying the main entities of the system and their attributes

Identifying the relationships between the system entities

Identifying the cardinality and ordinality of relationships

Creating ER diagrams for the system to show how the Entities interact

Creating ERDs using Chen and Crows foot notations.

Using software tool to draw ER diagrams (e.g. draw.io)

Requirements & Submission:

Use Draw.io

Task:

Your task is to create the best and most efficient ER model for a database of library management system using the requirement description below. You need to provide two ER models for the described system, one conceptual model using Chens notation ERD and one logical model using Crows Foot notation ERD.

Your ERDs should include

The main entities and their attributes, and must show the primary key attribute(s) of each entity

All the relationships between the entities, and the cardinality, optionality, and the attributes (if the relationship has any) of each relationship.

The deliverable: is ONE pdf file contains the two ERD diagrams as follows:

ERD1: The conceptual level ERD using Chens notation. Should include the entities and their attributes, and the

relationships and their cardinalities, attributes, and optionality (ordinality)

ERD2: The logical level ERD using Crows Foot notation. Should be detailed and include the entities, their attributes, the PKs, the mapped FKs, the relationships and their cardinalities, attributes, and optionality. All Many-to-Many relationships (if there is any) should be mapped into a new table (associative entity).

Add any text you would like to include to justify or explain any assumptions youve made in your design that were not mentioned in the system description.

Library system description:

ABC library is asking you to help in designing a system that manages and tracks the borrowing records of their books. The system should maintain information about the books and their associated copies, the library members (Borrowers), and the borrowing transaction records (i.e. checkout and return of book copies). The library provides book loaning service to registered members. The library may have multiple copies of the same book, so it maintains information about both books and their copies. Each book is described by title, edition, and year of publication, and a unique ISBN number. The library assigns a unique serial number for each book copy to help tracking it. The library also maintains a record for each book copy, like its status indicating if the copy is available for loan or not, and its allowable loan period (e.g., some book copies are allowed to be checked out for few hours, while other copies can be allowed for few days). A book copy can be checked out (borrowed) by any member when it is available, and each time a copy is checked out or returned the copy information and checkout /return dates are recorded in the checkout-transactions. The system keeps information about each member (borrower) like their name, address, phone number, and assigned unique member ID number. A member may borrow (checkout) any number of book copies, and a unique checkout number is assigned to each book copys checkout- transaction record.