Study sets, textbooks, questions
Upgrade to remove ads
MIS 161 Final
Terms in this set (27)
Logical design + technology specific instructions.
Design without specific technology instructions.
Displays the functional elements of a website or page, typically used for planning a site's structure and functionality.
How objects interact with each other, methods/variables in objects.
Transactional database (OLTP)
High levels of Normalization 3NF or more. Organizations use it to perform their daily operations.
Low levels of Normalization. Used for business analytics purposes. Example: Non-relational databases.
Stored procedure. Few lines of code so we can reuse it.
PK vs. index
A table can have only 1 PK as an index (can be composite) but it can have many indexes.
Basic Chen Model
Shows tables and how they're related.
Entity Relationship Model
Tables are more elaborated; there are columns, data types, etc.
Dashed line shows relationship between two independent entities. Solid lines show _______ connect with dependent entity.
N Char vs. Varchar
N Char allows specific, special characters i.e. Chinese characters; more flexible than varchar.
3 types of backup
Full, Incremental, Differential, Transaction log
PHPMyAdmin only supports it. Backs up entire database. Large databases take a long time.
A record of cumulative changes since the last full backup. Faster; requires a previous full backup.
Transaction log backup
Requires a previous full backup. Keeps a record of incremental changes since the previous full backup.
A small program we attach triggers to tables in order to maintain data accuracy and consistency.
Cannot have multiple _____ _____. You can only have one of each for each table.
• A simple way to run scheduled tasks.
• Useful to track changes in data.
• They can catch errors in business logic.
• Works faster than website/mobile app changing database (advantage).
• Increase the overhead of the database server. Triggers run every time when the database fields are updates and it is overhead on the systems. It makes the system run slower.
• A trigger cannot create, rename, or drop a table.
• When user is interacting with a database via an app or mobile site, it can be difficult to determine what makes changes. Is it user? Is it trigger?
separation of layers
When you build a website, use "________".
All Java, CSS, and HTML are on their own page. We don't have usability when they're all mixed together, but it doesn't always work, such as in a content management system.
Integer type that holds only values greater than or equal to zero. Cannot be negative User ID.
In PHP, there is "get_var" (returns a single variable) and "_________" (returns an array).
Admin_AJAX.php: (WordPress, Frontend, HTML + Java)
It manages AJAX request.
Has an AHAX request been received?
Has server connection established?
What is the status of the response?
Functions.php: (WordPress's Java)
Server provides a response to the AJAX request.
Requests data from the database.
Submits/Insert data into the database by using AJAX.
Sets with similar terms
Chapter 19: How to backup and restore a database
COB 204 chapter 5
Systems Analysis Chapter 9
Other sets by this creator
MIS 171 Final
MIS 140 (Ch. 8 - 11)
MIS 171 Exam 2
MIS 183 Exam 1
Other Quizlet sets
Chapter 8: Understanding Big Data and Its Impact o…
Cultural geography final exam
Ch 8 Test