Premium Essay

It525 Assignment 2

In: Computers and Technology

Submitted By mazrak
Words 1164
Pages 5
Database Design and Data Modeling: Assignment 2

Mohammed Azrak

Kaplan University

Database Design and Data Modeling: Assignment 2

Question #1 Definitions:

Define each of the following terms (1 pt. each). In addition, provide an example of each term (2 pts. each). a. Business Rule b. Entity c. Entity Set (Entity Type) d. Entity Instance e. Attribute f. Relationship g. Connectivity h. Cardinality Constraint i. Participation Constraint. j. Associative Entity

Answer #1:

a. Business Rule – a description of a policy, procedure or principle within an organization. For example, truck drivers can only drive for 60 or 70 hours in the last seven or eight days.

b. Entity – A person, place or thing for which data can be stored. For example, an airport is an entity that has many airlines within it.

c. Entity Set (Entity Type) – A grouping of related entities in a relational model. For example, all airlines having a gate at an airport.

d. Entity Instance – is an individual occurrence of an entity type. For example, if a family had three children, Peter, Michael, and Sophie, each child (Peter, Michael, and Sophie) would be an instance of the ‘child’ entity.

e. Attribute – is a characteristic of an entity or an object. For example, Southwest Airlines is an attribute of entity ‘Airline’.

f. Relationship – An association between entities. For example, an airport has a relationship with airline where there are many airlines to one airport.

g. Connectivity – is the classification of the relationship between entities. These classifications include 1:1, 1:M, and M:N. For example the connectivity of the relationship between airport to airline would be 1:M. h. Cardinality Constraint – is when a...

Similar Documents

Premium Essay

Not Sure

...Assignment 2: Database Design and Data Modeling Joesph Thomas 18 November 2014 IT525-01 Database Design and Data Modeling Professor: Jon McKeeby, DSc. Kaplan University   Question 1. Definitions a. Business Rule: These are used to provide consistent control of the application’s data access by providing dependencies and relationships between system processes and the application. An example would be when you click print, the application automatically prints to the default printer set by the system instead of allowing you to choose a different source. This type of situation could be setup to prevent data theft.Not exactly based on database design and ERDs. b. Entity Set (Entity Type): A group of items that share a common trait. An example would be; hard drive, CPU, RAM, Motherboard. These are all internal computer parts. c. Entity Instance: This would be a line of data or a table row. d. Attribute: This is a property of a data asset. Depending on the type of asset in question, the attribute can range from a color to a formula. e. Relationship: This is when two database tables rely on each other by sharing a foreign and primary key. For instance, we have two tables. One is basic customer data where the customer ID number is the Primary Key. The second table is the order history for that customer where the customer ID number is the Foreign Key. f. Connectivity: database connectivity is the means to how the db server and client communicate with one another...

Words: 838 - Pages: 4