Systems Analysis and Database Design

Running head: MASTERS OF COMPUTER SCIENCE
Systems Analysis and Database Design
Name of Student-
Name of University-
Author’s Note-

MASTERS OF COMPUTER SCIENCE1
Answer to Question 1:
Attribute of an object can be defined as the property or can be defined as the
characteristics of the object. Attribute in a Database Management System is considered as the
changeable property or the some characteristics of the component that might include in that
program and has different set of values. The component of a database is described as the attribute
of that object. An attribute has many fields or tables included in them.
Attribute of Vehicle object are: Engine RPM, Mileage, and Engine Capacity
Answer to question 2:
Cardinality defines the number of rows that are rows that are related in each of the
objects that are defined. There are relationships between two tables of two queries. The total
number of rows in each object is known as the cardinality of an object. It defines the uniqueness
of the value of data that are in a column or in an object. The higher the cardinality states the
higher number of values in that the object have. The cardinality relationships between two
objects are mainly of three types- One to one relationship, One to many relationships, and many
to many relationships.
Cardinality is important in database because it establishes links from a table to another
table in a proper structured manner. Without the cardinality, there cannot be any relationship in
between the tables of an entity.
Answer to question 3:
Aggregation is indicated as the relationship where the child class can exit without a
parent class independently. Example of aggregation is: let there are two entities known as Class

MASTERS OF COMPUTER SCIENCE2
entity and the student entity. The class entity is the class and the student is the child class. If class
is deleted, Student still exist.
Composition: This indicates that the child cannot exist independently without a parent
class. Association is considered as a generic term that is used to represent a class that uses
functionalities that are provided by some other class. Whereas, in composition the parent object
class inherits the child object class and without the parent class, the child class does not have any
meaning. If child class without parent class can exist independently, it is known as aggregation.
Answer to question 4:
Example of superclass that derives three objects are:
Let Bicycle be a super class. The objects that can be derived from the superclass
“Bicycle” are Mountain Bike, Road Bike and Cyclo cross bike. All are sub class of the super
class bicycle. They share same sets of objects.
Answer to Question 5:
The conceptual entity relationship diagram are basically used as foundation of logical
data models. The ERD do not have primary keys and so there is no meaning of having
cardinalities in an ERD. Attributes are the main characteristics of the ERD diagrams and many to
many relationships are only included in the UML Class Diagrams.
Answer to question 6:
State machine in a database states the model of computation that are implemented in
practical applications. Finite state machine is one of the most famous state machine. This is a
mathematical model that is used for computation. State machine have different states but only