Textbook Notes (270,000)
CA (160,000)
Western (10,000)
COMPSCI (100)
Chapter 5

Computer Science 1032A/B Chapter Notes - Chapter 5: Database Application, Copy Editing, Microsoft Access


Department
Computer Science
Course Code
COMPSCI 1032A/B
Professor
Louis Magguilli
Chapter
5

This preview shows half of the first page. to view the full 3 pages of the document.
Chapter 5: Database and Content Management
Q1: Content:
In the broadest sense is property
oRelated to intellectual property: a form of creative endeavor that can be protected through a trademark, patent, copyright,
industrial design, integrated circuit topography(landscape)
Varies by industry; advertising (pictures and commercial), publishing (words), banking (account info)
Organizations may store: Data, Documents, Spreadsheets, Presentations, Web pages, text from blogs and discussion boards, graphics,
video files, audio files, etc.
Computer created digital content  can be stored, network, increased the ability to distribute; Internet
Expanding volume of content and the growing number of formats in which it’s provided can make it difficult for individuals and
corporations to effectively utilize that content
Challenge: managing content, presenting it appropriately for various stakeholders inside and outside of org
A company’s website is an important source of content for both customers and employees, and critical part of customer support
Q2: How can content be organized?
Challenge in content management: index/catalog/process/store the right information (content), get it to the right person, in the right
format, at the right time
Content management * Management of content data is different than the presentation of content
Management of content data
oFocuses on how to efficiently and effectively store and process bytes (data)
oDatabase management systems (DBMSs): The management of many types of data has been handled through organizational
Presentation of content: is handled through a series of steps supported by software
oWeb content management systems (CMSs) help companies organize this process (organizing documents), enables the company
to standardized the look of a website, control the information available to customers and employees
oAn employee should access the web CMSs in order to place some content on the org’s website
Employee typically loads the raw content into the web CMS system
Copy editor then reviews the document and makes changes
Copy editor passes the content on to layout artists, who prepare the content for presentation
The manager in charge of the website will then review the content and presentation and publish the work to the live website
oCMS’s have evolved:
Now actively seek out documents located across an organization and automatically manage access to this content (seek out
documents and organize access)
Provides increased organization for a wider range of a corporation’s data assets
Handle document archiving and the increased use of electronic files for document management
Q3: The purpose of a database:
A database keeps track of things
Spreadsheets vs. Databases:
oSpreadsheets: structure of the list is simple, keep lists of single concept (theme); records simple list of students grades
oDatabases: keep lists that involve multiple themes (more than one); records student grades, emails and office visits
Relational Database:
oConceptually simple, Easy to understand, Easier to develop and maintain, Provides all the data in one place, Relationships aren’t
predefined, Database can evolve as required, Relationships are implied in the data
Q4: What does a database contain?
Database designed is a required skills for MIT and business students
Database: a self-describing collection of integrated records
Byte: a character of data (aka character)
oGrouped into columns (aka fields)
oColumns are grouped into rows (aka records)
oA group of similar rows/records, column/fields, byte/character is called a table (aka file)
Component of a database: a group of tables/files + relationships among rows in tables + special data called metadata
You're Reading a Preview

Unlock to view full version