237-L05-2up - BUS 237 1 Lecture 5: Databases and Content...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: BUS 237 1 Lecture 5: Databases and Content Management BUS 237 Information Systems in Business BUS 237 Agenda Questions? Assignment #1 Group Assignment teams MyMISLab Content Management Organizing content Relational Databases DBMS & Database applications OLTP & OLAP Using organizational data BUS 237 2 BUS 237 2 This Could Happen to You A manager selected Moveable Type application program for the blog Needs database program to store blog Consultant suggested MySQL Network standardized on Oracle may not be able to run Moveable Type will require revision of labor estimates IT resists installing MySQL BUS 237 3 Questions to Consider BUS 237 4 Q1. What is content? Q2. How can content be organized? Q3. What is the purpose of a database? Q4. What does a database contain? Q5. What is a DBMS, and what does it do? Q6. What is a database application? Q7. What is the difference between an enterprise and a personal DBMS? BUS 237 3 Q1. What is content? Content is related to intellectual property a form of creative endeavour that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography Varies by industry Organizations may store data, documents, spreadsheets, presentations, web pages, text from blogs and discussion boards, graphics, video files, audio files, etc. BUS 237 5 Q2. How can content be organized? Content management includes management of content data Database Management Systems (DBMS) presentation of content Content Management Systems (CMS) Content management challenge processing and storing the right content getting the right content to the right person in the right format at the right time BUS 237 6 BUS 237 4 Content Management and SFU How do you get something listed on the main SFU website? What steps are involved? Who is in charge of it? What are the policies about web content? Does SFU have a brand? Should a University be branded? How do you enforce a brand within the university? BUS 237 7 Q3. What is the purpose of a database? Spreadsheet and database keep track of things Spreadsheets Keep lists of single concept Databases Keep lists that involve multiple themes BUS 237 8 BUS 237 5 Q4. What does a database contain? A database is a self-describing collection of integrated records Hierarchy of data elements Byte is a character of data Bytes are grouped into columns/fields Columns are grouped into rows/records Rows are grouped into tables/files BUS 237 9 Storing Data Character: the most basic logical data element single alphabetic, numeric or symbol typically a Byte Field: typically a group of characters (could be one) represents an attribute (characteristic or quality) of an entity (object, person, or place) Record: related fields of data grouped together can be either fixed length (e.g. Address) or variable length either fixed length (e....
View Full Document

Page1 / 25

237-L05-2up - BUS 237 1 Lecture 5: Databases and Content...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online