Week 4: Class 7
Chapter 5 Q1
What is content?
Content is property; it is often related to intellectual property, which is defined as a
form of creative endeavor that can be protected through a trademark, patent,
copyright, industrial design, or integrated circuit topography.
In the advertising industry:
-text used to promote ideas about products and services.
Chapter 5 Q2
How can content be organized?
Challenge of content managing:
Is indexing the correct info, processing and storing it, then getting it to the right
person in the right format at the right time.
We can separate the management of from the presentation of data.
DM focuses on how to efficiently and effective store and process these bytes.
When an employee wants to place some content on the organization's website, she
will access the web content management system (CMS). The CMS is usually located
on the company's website server. The employee typically loads the raw content into
the web CMS system. A editor reviews and makes changes. She passes the content
to layout artists, who prepare the content for presentation.
Content and presentation are stored with the help of DBMS. The manager in charge
of the website will review the content and presentation and publish the work to the
live website. CMS web helps manage each step of the process and enables a
company to standardize the look and feel of a website and control the info available
to customers and employees.
Chapter 5 Q3, Q4
What is the purpose of a database?
It keeps track of things that involve more than one theme.
What does a database contain? Microsoft Access
A database is a self-describing collection of integrated records.
A byte is a character of data. Bytes are grouped into columns, such as Student
Number and Student Name. Columns are also called fields.
Columns or field are grouped into rows, which are also called records. A group of
similar rows of records is called a table or a file.
A database is a collection of tables plus relationship among rows in those tables, plus
special data, called metadata, that describe the structure of the database.
Databases are stored in magnetic disks.
Relationships among records
Values in one table relate rows of that table to rows in a second table.
A key is a column or group of columns that identifies a unique row in a table.
Every table must have a key.
The key of the Email table is Email Num.
The key of the Student_Visit is Visit ID.
Columns that fulfill a role like that of Student Number in the Email and Office-Visit
table are called foreign keys. This term is used because such columns are keys, but
they are keys of a different (foreign) table from the one in which they reside.
Databases that carry their data in the form of tables and then represent
relationships using foreign keys are called relational databases.
The term relational is used b/c another, more formal name for a table is relation.
Database : self-describing collection of integrated records. The self-describing part
means that a database contains, within itself, a description of integrated records.
It is self-describing because it contains a catalogue that describes its contents.
Metadata are data that describe data.
The presence of metadata makes databases more useful than spreadsheets or data
in other lists. Because of metadata, no one needs to guess, remember or even
record what is in the database. To find out what a database contains, we just look at
the metadata inside the database.
Chapter 5 Q5
What is a DBMS, and what does it do?
Components of a database application system:
2. Database application: forms, reports, queries, application programs
4. Database: tables, relationships, metadata
Such application make database data more accessible and useful. Users employ a
database application that consists of forms, formatted reports, queries, and application programs. Each of these, in turn, calls on the database management
system to process the database tables.
The DBMS is a program used to create, process, and administer a database. Almost
no organization develops its own DBMS. Instead, companies license DBMS products
from vendors like IBM, Microsoft, Oracle, etc. eg. Access, and SQL Server from
Microsoft, Oracle from Oracle Corporation. MySQL, an open-source DBMS product
that is free for most applications.
DBMS is a software system.
A database is a collection of tables, relationships, and metadata.
Creating the database and its structures
Database developers use the DBMS to create tables, relationships, and other
structures in the database. To modify an existing table---for example, to add a new
column, the developer opens the metadata form for that table and adds a new row
Processing the database
Use DBMS for four functions:
Read, insert, modify, delete
There is only one language that relational databases use when communicating data
from a database: SQL. Structured Query Language.
It is an international standard language for processing a database. It can be thought
as a formal way of asking a question to a database. The answer to that query will be
the data that is specified.
Administering the database
To provide tools to assist in the administration of the database. DBMS can be used to
set up a security system involving user accounts, passwords, permissions, and limits
for processing the database. Permissions can be limited in specific ways. In the
student database example