Textbook Notes (367,752)
Canada (161,368)
Criminology (615)
CRIM 101 (121)
Chapter 5

Chapter 5.docx

2 Pages
Unlock Document

CRIM 101
Kamal Masri

Chapter 5 What is Content?  Intellectual property – Creative content that is protected through copyright, trademark, patent, industrial design, integrated circuit topography  Content differs from industry to industry o Ex. Bank content = account information, advertising = commercials  Computers and the internet have created more types of content and increased distribution ability o Makes it more difficult to use content effectively  Problem actually lies with presenting content appropriately for shareholders & etc How can Content Be Organized?  Important issue in content management is cataloguing the right information, processing, storing, & getting information to the right person in the right format at the right time  Concerned with efficiently and effectively storing/processing bytes of data  Web content management systems today help companies/employees with the presentation of data on websites as the old practice did not provide consistency and left room for inaccuracy  Content management System o Located on company website server o Employee loads raw content  copy editor reviews and edits  layout artist prepares content for presentation  stored in DBMS  manager does final review and publishes o Current CMSs find documents located across organizations and automatically manages access to content, document archiving, increased use of electronic files  Word doc, html pages What is the Purpose of a Database?  Used for organization and record keeping  Spreadsheets can be used for single themed (simple)  Databases required for multiple themed lists What Does a Database Contain?  Database = self-describing collection of integrated records.  Byte = character of data  Bytes organized into columns/fields  Columns/fields grouped into rows/records  Group of similar rows/records called table/file  Database (stored on hard disk) = Tables/Files/Relations + Relationships among rows in Tables + Metadata  Relationship among Records o Key = column/group of columns that identify a unique row in a table  Ex. In e-mail table seeing the student number  check student number in student table  see when they have visited the office in office visit table o Foreign Keys = keys from a different (foreign) table from the one in which they reside Relational database = Databases that carry their data in the form of tables and that represent relationships using foreign keys  Non-relational databases have nearly disappeared  Metadata o Self-describing – Contains within itself a description of its contents  data about the data (metadata) o Field properties – describes format, default value for Access to supply when new row is created and value constraints for that row o Always part of a database What is a DBMS, and What Does it Do?  Database Application System – applications that make database data more accessible and useful o Forms, formatted reports, queries, application programs  These then call upon database management system to process database tables  Database Management System (DMBS) o Software used to create, process, administer a database o Popular DMBSs – DB2 from IBM,
More Less

Related notes for CRIM 101

Log In


Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.