CASE STUDY FUNCTIONS OF MANAGEMENT
DUE: JANUARY 17, 2017
As requested by Mr. Tom Coffee, a review of the current management structure of
Toms Coffee Cup was performed. This report encapsulates a number of issues that
are currently impacting his business,
Practical Database Design for
A little background and terminology:
What is a relational database?
What is a primary key?
What is a foreign key?
Things to know about
Introduction to Databases
Characteristics of a Database
File Systems vs. DBMS
Advantages of DBMS
Queries in a DBMS
Data vs Information
Raw facts or Meaningful facts about people, objects,
Caribbean Airlines wants to create a database to keep track of ﬂight information of their planes. The airline has
a number of airplanes, each of which is identiﬁed by its engine number. The airplanes ﬂy to several airports in
the Caribbean. Use the schema
SSN is a single and simple attribute.
SSN is a prime attribute
Name is a composite attribute
Hobbies is a multivalued attribute
Age is a derived attribute
WEAK ENTITY EXAMPLE
IS-A TYPE OF
Data Modelling and Database design
Welcome back! In this session, we will primarily be concentrating on learning the art of data modelling
and designing.Then we shift our attention towards generating the database structure from the designs.
We will also b
Components of a database system
Hi students! In this session, we will primarily focus on the topic: Components of a database system. We
start with defining the term database followed by describing the components of a database. We will