{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

237-L05-6up - Agenda Questions Assignment#1 Group...

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

View Full Document Right Arrow Icon
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 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? 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
Background image of page 1

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

View Full Document Right Arrow Icon
BUS 237 2 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 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 (employment history) Table: a group of related records frequently classified by application (payroll file) or use (transaction vs. master file)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}