2
PHASE 3: CLASS DIAGRAMS
Travis M. Lucas-Bosland
CIS210
Phase 3: Class Diagrams
Q2 Summer 2021
August 22, 2021
Mark Stone
Class Diagram Analysis
1. Identify the primary keys for each class. Be sure to include the name of the class and the name of the attribute(s) that make up the primary key. Remember that some classes will have composite primary keys.
A primary key in a table is a column or group of columns whose values uniquely identify a table row (Rabelo, 2019). The patron class primary key is PatronAccountNumber, while the LibraryMaterial class is MaterialId. On the other hand, InterLoanLibray class has LibraryId as its primary key. The classes (Fines, MaterialCheckedOut, ReservedMaterial, and InterLoanRequest) do not have primary keys but foreign keys.
2. Identify the foreign keys for each class. Be sure to include the name of the class and the name of the attribute(s) that make up the foreign key.
A foreign key is a column or set in a relational database table that connects data from two other tables (Parker, 2020). The first two classes do not have a foreign key. InterLoanLibrary has materialId has a foreign, which is a primary of LibraryMaterial. Class fines and MaterialCheckOut has PatronAccountNumber as their foreign Keys. PatronAccountNumber is a primary key of class Patron. ReservedMaterial class has two foreign keys: PatronAccountNumber and MaterialId. Finally, InterLoanRequest class has PatronAccountNumber, MaterialID, and LibraryId as its foreign Keys. MaterialId is a primary key of class LibraryMaterial.
3. Identify the relationships that should be created. Give the names of the classes that make up the relationship and define what the cardinalities should be for each relationship. Include a brief description of the relationship.
Class Patron has a one-to-many relationship. It is related to four classes: Fine, MaterialCheckOut, ReservedMaterial, InterLoanRequest. Class LibraryMaterial has one-to-many relationships. It related to four classes: InterLoanLibrary, MaterialCheckOut, ReservedMaterial, and InterLoanRequest. Class Fine has a one-to-one relationship; it is related to class Patron. MaterialCheck has a one-to-many relationship. It is related to classes Patron and LibraryMaterial. Class ReservedMaterial also has a one-to-many relationship. It is related to classes Patron and LibraryMaterial. Finally, class InterLoanRequest has a one-to-many relationship. It is related to classes Patron, LibraryMaterial, and InterloanLibrary.
4. The project manager feels that there may be some classes that have been omitted. Based on the information from the previous phases, list the classes and their attributes that should be added in order to completely define the data needed for the kiosk system.
In order to complete the Kiosk system, the following two classes should be added:
Client
ClientID
ClientFirstName
ClientLastName
ClientAddress
ClientZipCode
ClientPhone
MaterialID
Payment
PaymentID
ClientID
DatePaid
ModeOfPayment
REFERENCES
Parker, B. (2020). What is a Database Foreign Key? A beginner’s tutorial. Educative: Interactive Courses for Software Developers. https://www.educative.io/blog/what-is-foreign-key-database
Rabelo, J. (2019). What is a Primary Key? – Definition from Techopedia. Techopedia.com. https://www.techopedia.com/definition/5547/primary-key
The post 2 PHASE 3: CLASS DIAGRAMS Travis M. Lucas-Bosland CIS210 Phase 3: Class appeared first on PapersSpot.