You have been hired by Vision, a start-up clothing company. Your manager, Holly
ID: 382266 • Letter: Y
Question
You have been hired by Vision, a start-up clothing company. Your manager, Holly Henningson, is unfamiliar with databases and their associated business value. Henningson has asked you to create a report detailing the basics of databases. She would also like you to provide a detailed explanation of relational databases along with their associated business advantages. In your report to Ms. Henningson please include:
1) Definitions of a database, a database management system and the relational database model
2) The business advantages of a relational database
3) Four primary characteristic that determine the value of information
4) Define, explain and give examples of entities and attributes in a relational database
Explanation / Answer
# Database management systems (DBMS)
Database is a collection of inter-related data and data is a collection of facts and figures that can be processed to generate required information.
The database management systems (DBMS): A collection of general-purpose, application-independent programs providing services
The key characteristic of DBMS:
# Relation database management systems (RDBMS)
Relational Database Management System (RDBMS) consists of two key entities:
#Example:
Student roll Number
Student_Name
Student_Address
123
ABC
New York
345
DEF
New York
555
XYZ
California
#The business advantages of RDBMS:
Below are the key business advantages of RDBMS:
#Four primary characteristic that determine the value of information
Below elements determines the value of information:
Five characteristics of high quality information are accuracy, completeness, consistency, uniqueness, and timeliness.
#Entity
An entity is a database object that represents a thing in the real world.
Entities are expressed as nouns.
Entities can be concrete, like buildings and employees or they can be more abstract things like departments and accounts.
#Relationship
A relationship is an association among two or more entities or other relationships. Relationships are expressed as verbs.
Relationships among entities are described by following:
Example: One Student can have one student-number
Example: One Student can enroll for several subject classes
Example: One consumer can place multiple orders of multiple products
#Attribute
An attribute is a characteristic of an entity. Every entity has at least one attribute: its primary key.
Attributes are expressed as nouns qualified by adjectives that clarify their role.
An attribute plays one of three possible roles in any table:
Primary key attributes are said to be attributes because they uniquely identify an instance of an entity.
A foreign key attribute can be an identifier attribute if it is part of a composite primary key.
Student roll Number
Student_Name
Student_Address
123
ABC
New York
345
DEF
New York
555
XYZ
California
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.