Class Notes (835,304)
Canada (509,083)
Commerce (742)
COMM 190 (22)
Lecture 4

Comm 190 Week 4.docx

14 Pages
131 Views
Unlock Document

Department
Commerce
Course
COMM 190
Professor
Tracy Jenkin
Semester
Fall

Description
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: -pictures -commercials -text used to promote ideas about products and services. Publishing industry: -words Banking industry: -account information 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 Q3: What is the purpose of a database? It keeps track of things that involve more than one theme. Q4: 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. Metadata 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: 1. User 2. Database application: forms, reports, queries, application programs 3. DBMS 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 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. Differences: 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 of metadata. 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
More Less

Related notes for COMM 190

Log In


OR

Join OneClass

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

Sign up

Join to view


OR

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.


Submit