lecture 10 - database development + course review Flashcards
(25 cards)
Databases are part of an EFFECTIVE information system when:
- Addresses and solves the correct business problem
- Be built efficient and effectively
- Integrate smoothly in existing environments
- Easy to use / user friendly ( eg; smartphone )
Information Systems Definition:
Information Systems capture, store, retrieve, display, manipulate, and transmit information used in one or more business processes.
Systems Analysis
Process of establishing the scope and needs of the information system.
Phases of Databse Development Lifecycle ( DDLC )
- Database Initial Study
- Database Design
- Implementation + Loading
- Testing andEvaluation
5.Operation
6.Maintenance and Evolution
What happens during phase 1 - database initial study
Analysing the system’s objectives, constraints, and defining the system’s scope.
What happens during phase 2: database design
- logical design: Create ERD, normalise data, ensure logical data integrity.
- Physical Design: Translate logical models into database management system compatible structures, determine indexes and storage.
what happens during phase 3: implmentation + loading:
- Build the actual database.
- Set user permissions, security rules.
- Consider data privacy, backup, integrity, and concurrency.
what happens during phase 4: testing and evaluation:
Test performance, access control, and data accuracy.
what happens during stage 5: operations
- Move to production.
- Monitor and optimize system usage and security.
what is phase 6: maintenance and evolution
- Maintain system through regular backups and updates.
- Adapt system to new needs or technologies.
Q: What is ER modeling used for?
Identifying entities, attributes, and relationships in a database.
Q: What is the purpose of normalization?
To reduce redundancy and improve data integrity.
What are the two aspects of database security?
Authentication (user identity) and Authorization (user permissions).
Name three concerns during the Implementation phase:
Performance, security, and data integrity.
What’s the difference between Business Intelligence and Business Analytics?
BI describes and visualizes data; BA includes predictive and prescriptive analysis.
artificial narrow learning ( week ai )
A technique which enables machines to
replicate human’s intelligent behaviours
Machine Learning
Subset of AI technique to enable
machines to learn from data with
statistical methods
What is a Data Warehouse:
A centralised system that integrates data from various sources for BI purposes.
e.g., Microsoft, Oracle, IBM/Cognos, Teradata
Deep Learning
Subset of ML
with multi-layer
neural network
BI tools
- data visualisation
- Online analytical processing tools
- portals
- data analysis and reporting tools
- data mining tools
How does a DA ( data administrator ) differ from a DBA ( database administrator )?
DA focuses on planning and policies; DBA handles implementation and operations.
Name two daily responsibilities of a DBA.
- User access control and backup planning.
What is the relationship between Database development vs. information systems development?
Database development takes place within the context of an information systems development process.
Database privacy is to ensure that only authenticated users can perform authorized activities at authorized time. True or False?
False. That is database security.
Database privacy require us to:
▪ Conduct cautious collection of
personally identifiable information (PII), e.g: financial transactions.
▪ Adhere to public expectation of privacy
▪ Address legal/political issues
