Domain 8 Flashcards
What is a Tuple
It is a row in a table in a relational database
What is an Attribute
It is a column in a relational Database
What is a table
It is the database that consists of tuples (rows) and attributes (columns)
Main Components of SQL database
- Schema
- Tables
- Views
What is a Schema
Describes a structure of a database, including any access controls limiting how the users will view the information contained in the tables
What are Tables
Columns and rows (tuples) of the data are contained in tables
what are Views
“Defines what information a user can view in the tables. The view can be customized so that an entire table may be visible or a user may be limited to only being able to see just a row or a column. Views are created dynamically by the system for each user and provide access control granularity.”
SDLC
Software Development Lifecycle
Waterfall SDLC
“highly structured and does not allow for changes once the project is started and moved onto subsequent phases. Revisions are not allowed in later phases.”
Common SDLC Types
Waterfall, agile, spiral, others
Prototyping
“In prototyping, the objective is to build a simplified version of the entire application, release it for review, and use the feedback from the stakeholders to review to build a second, much better version. This is repeated until the owner and stakeholders are satisfied with the final product. Prototyping is broken down into a step-by-step process that includes initial concept, design and implementation of initial prototype, refining the prototype until acceptable to the owner, and complete and release final version”
MPM
Modified Prototype Model
Define MPM
“A refined form of the above prototyping methodology that is ideal for web application development, it allows for the basic functionality of a desired system or component to be formally deployed in a quick time frame. The maintenance phase is set to begin after the deployment. The goal is to have the process be flexible enough so the application is not based on the state of the organization at any given time. As the organization grows and the environment changes, the application evolves with it rather than being frozen in time”
RAD
Rapid Application Development
Define RAD
“Also, a refined form of prototyping, rapid application development (RAD) requires strict time limits on each phase and relies on efficient tools that enable quick development. The goal is to produce quality code quickly. While this sounds attractive, it must be handled properly because the quick development process may be a disadvantage if decisions are made so rapidly that it leads to poor design”
JAD
Joint Analysis Development
Define JAD
“The premise is to have facilitation techniques that become an integral part of the management process that helps developers to work directly with owners and stakeholders to develop a working application. This is a novel idea that involves all stakeholders in the entire process. The success of this methodology is based on having key players communicating at all critical phases of the project. “
Define JAD
“The premise is to have facilitation techniques that become an integral part of the management process that helps developers to work directly with owners and stakeholders to develop a working application. This is a novel idea that involves all stakeholders in the entire process. The success of this methodology is based on having key players communicating at all critical phases of the project. “
Implementations of Agile philosophy
SCRUM