Database Concepts and Schema Design

Running head: DATABASE
Database
Name of the Student:
Name of the University:
Author Note

1DATABASE
Answer 1
A database is a shared collection of logically related data, and a description of this data, designed to meet the
information needs of an organization.
A database server is a dedicated computer system (hardware and software) which runs the DBMS, and contains the
database and underlying data.
MySQL Workbench is a popular DBMS which supports SQL.
Most application programs enable users to define, create, maintain, and control access to a database.
MySQL Server 5.7 is a popular relational DBMS which supports SQL.
Answer 2
A database schema is a description of the database structure. Data
independence makes each level immune to changes to lower levels.
refers to the immunity of the external schemas to changes in the conceptual
schema. refers to the immunity of the conceptual schema to changes
in the internal schema.
Answer 3
A row of a relation – a named column of a table
A table with columns and rows – Attribute
The set of allowable values for one or more attributes – Domain
A named column of a table – Row
The number of attributes in a relation – Degree
Database Schema
Physical Data Independence
Logical Data Independence

2DATABASE
Answer 4
Strong entities have a distinct and independent existence.
An entity occurrence is a uniquely identifiable object of an entity type.
Strong entities modelled in an ER diagram become tables in the relational model.
Composite attributes are usually represented as relations in the relational model.
A relational schema derived from an ER model should be validated using the rules of normalization so
that it satisfies various constraints to avoid unnecessary redundancy.
Answer 5
Weak Entity types – 4
Composite Attributes – 1
Multi-valued Attributes – 1
Uniqueness Constrains – 2
Integrity Constrains – 0
Answer 6
Ternary