Software engineering
This process includes planning, designing, developing, testing, and maintaining software.
What is software engineering?
A mistake or flaw in a program that causes it to behave incorrectly.
what is Software defect?
a software intermediary that allows two applications or components to talk to each other
what is API?
A company needs to store millions of customer records that are valuable and accessed by many users at the same time. What type of software should they use to manage this data?
What is a DBMS (Database Management System)?
its a storage space where your project’s files and their complete history of changes are kept
What is a repository?
A design pattern that separates an application into 3 main components; Model, View, and Controller. Model manages the application date and related logic, View displays the information to the user, Controller handles user input and coordinates between model and view.
what is MVC?
Customer acceptance test, usability test
what is Validation?
enables communication between applications and DBMS
what is Database API?
A database has separate Customers and Orders tables. What SQL operation would you use to combine related data from both tables?
What is a JOIN?
Fetch changes from remote and merge current branch with its upstream
What is Pull?
Static Diagrams: Show the structure of a system at a specific point in time
Dynamic Diagrams: Show how a system behaves or changes over time.
What is Static vs. dynamic diagrams?
improving the structure and readability of existing code without changing what the program does.
what is Refractoring?
can access files, network communication, UI elements
what is Operating System APIs?
A table contains an ID column where every value must be unique and cannot be null. What database concept is being used?
What is a Primary Key?
A developer modifies a file and runs git add .. Where is the file now?
What is the staging area?
what is WRSPM?
A model that helps connect real-world needs to software expectations:
W- World (facts about the environment where software operates)
R- Requirements (the goals or outcomes a software should achieve)
S- Specification (behavior expected, describes how the software should behave)
P-Program (the code and instructions used to implement the software)
M-Machine (the computer system/platform running the program)
Determines whether software meets user or business requirements and is ready for acceptance.
what is Acceptance Testing?
visual representations that depict the static aspects of a system, including its classes, objects, components, and their relationships, providing a clear view of the system's architecture
what is UML diagram?
You want to view all rows and columns from the Employees table. Which SQL command would you use?
What is SELECT * FROM Employees?
Put these in the correct order:
What is 3 → 2 → 1?
A workflow management method that uses a visual board to organize tasks and track progress. Usually placed into columns To Do, In Progress, and Done.
What is Kanban?
test the architecture and communication as a whole. Tests whether different components of a program work correctly together.
what is Integration Testing?
link data in one table to the data in another table
what is Foreign Key?
A table has a primary key called StudentID. Two students cannot have the same StudentID, and no student can have a blank StudentID. What two rules of a primary key does this demonstrate?
What are uniqueness and non-null values?
Enables multiple developers to collaborate on the same project and supports operations like push, pull, and fetch to synchronize changes with the local repository
What is a remote repository?