All post

Sunday

Relational algebra

September 27, 2020 No Comments

 Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as output. It uses operators to perform queries. An operator can be either unary or binary. They accept relations as their input and yield relations as their output.

PPT

Wednesday

Unit 2: Keys

September 23, 2020 No Comments
Types of keys in DBMS 

Super Key – A super key is a set of one of more columns (attributes) to uniquely identify rows in a table. Candidate Key – A super key with no redundant attribute is known as candidate key
Primary Key – A primary is a column or set of columns in a table that uniquely identifies tuples (rows) in that table. 

Study Material:

Unit 2: Integrity Constraints

September 23, 2020 No Comments

 

Integrity Constraints

  • Integrity constraints are a set of rules. It is used to maintain the quality of information.
  • Integrity constraints ensure that the data insertion, updating, and other processes have to be performed in such a way that data integrity is not affected.
  • Thus, integrity constraint is used to guard against accidental damage to the database.
https://drive.google.com/file/d/12TyGNuG0lgGqG6B95qZgi5LBwagkN9KQ/view?usp=sharing
https://drive.google.com/file/d/12TyGNuG0lgGqG6B95qZgi5LBwagkN9KQ/view?usp=sharing

Unit 2: Relational Model (Introduction)

September 23, 2020 No Comments

 Relational Model was proposed by E.F. Codd to model data in the form of relations or tables. After designing the conceptual model of Database using ER diagram, we need to convert the conceptual model in the relational model which can be implemented using any RDMBS languages like Oracle SQL, MySQL etc. So we will see what Relational Model is.

PPT

Monday

SE

September 21, 2020 No Comments

 Book

Syllabus

Unit 1:

Lecture 1:  PPT Definition, characteristics, Myths,Crisis 

Lecture 2:  PPT1  PPT2

Lecture 3: PPT SDLC, Build and fix, water fall, iterative

Lecture 4: PPT Prototype model

Lecture 5: PPT1    PPT2  Spiral model , V model

Lecture 6: RAD model

Lecture 7: Agile Model Agile Model and Scrum

  Agile Models XP,KANBAN etc.

Unit 2:

Lecture 9: Classification of Software requirements , Functional vs Non-functional Requirements

Lecture 10: Characteristics of Good SRS

Lecture 11: Requirement Engineering 7 Tasks 

Lecture 12: Who is System Analyst? Software Metrics

Lecture 13: requirement analysis and Modeling

scenario based modeling

Lecture 14: scenario based modeling 1) use case

Lecture 15: Use case symbols etc 2) activity diagram

Lecture 16: How to draw Activity diagram 

Class based modeling

Lecture 17:  what is class based modeling 1) Class Diagram 2) Class-Responsibility-Collaborator (CRC) Modeling

Behavioral Modeling

Lecture 18: What is Behavioral Model? state diagram  sequence diagram 

Flow oriented model 

Lecture 19: Flow oriented model 

Unit 3
Lecture 24 architectural styles Part 1 |  Part 2



Unit 4: Software Testing 



 Unit 5


Unit 6:




Subscribe to: Posts (Atom)