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. An example would be a computer using a VPN to connect to an SQL server in another location across the country to gather or update information.
g. Cardinality Constraint: These are structural constraints because they limit the possible structure of the database. They specify the number of relationships an entity can participate in.
h. Primary Key: This property uniquely identifies each