CodeWithAbby

  ----------------------------------------------------------------- Single Responsibility Principle ----------------------------------------------------------------- About : The Single Responsibility Principle is a simple and intuitive principle. This is one of the 5 principles of S.O.L.I.D.. A responsibility in the current context is said to be a reason for change. The single responsibility principle states that if there more than one reasons for a class to change then we say that this class is not proper and it should be divided into further classes. There cannot be more than a reason for a class to be changed. Example : Suppose there is a class called " Customer " and contains a method called as " CalculateBills() " we should call this class has not been written properly. The customer class should only perform the customer related responsibilities. Please see  the below snap shot: There are some observations out of the above snap shot: Customer class should be re...

  What Goes Wrong With The Software? Software applications begin as a vital image in minds of designers Its clean and elegant this time Intention initially is to see the software working As the time passes , the software starts to rot Over the time rotting continues….. Finally this becomes hard to maintain , at times the sheer effort required to make even the simplest change to it  Here is the situation resulting into redesign of the project. Rotting Software Design Over the period of time the software starts rotting. One can sense the symptom of rotting in case he/she finds any of the following in the existing software : Rotting software design-symptoms... Rigidity: Tendency of software to be difficult to change. Every change causes a cascade of subsequent changes in dependent modules A 2-day change to one module grows into many week marathon changes ( in module after module ) When software becomes like this, managers fear to allow engineers to fix non critical problems....

 ASSIGNMENT 08 ---------------------------- Interview Questions Based On IDENTITY in SQL Server  What is the purpose of the IDENTITY property in SQL Server? How do you define an IDENTITY column in SQL Server? Can you insert values manually into an IDENTITY column? If yes, how? How would you reset the identity seed of a table after deleting all rows from it? What is the difference between an IDENTITY column and a SEQUENCE in SQL Server? What is SCOPE_IDENTITY() and how does it differ from @@IDENTITY and IDENT_CURRENT()? How can you retrieve the last identity value generated in the current session or scope? Explain how DBCC CHECKIDENT works. Can an IDENTITY column have a negative seed or increment? What happens if you try to insert a record after the identity value reaches its maximum limit? How would you handle gaps in an IDENTITY column caused by transaction rollbacks or deletions? If you delete a row from a table with an IDENTITY column, will SQL Server reuse that identity va...

 SQL Assignment -  07  --------------------------------- Creat the following tables. These tables are to be created at the top of 5 earlier tables. Table Name :  amenitiesMaster About this table: The table amenitiesMaster holds the data related to all the amenities in the apartment society. The amenities are those facilities which are shared/utilized/enjoyed by all the residents of the society.  Field Name Field Type Constraints (if any) Description amenityID smallint                     PRIMARY KEY This is a unique and not null field. This holds all the unique amenity ID.               amenityName varchar(40) NOT NULL This contains the amenity names. For example : Club House, Party Hall etc. oneTim...

                                                           Assignment - 06 ------------------------- Write SQL Queries for the following (based on the above data). You can use SQL Server Management Studio to run your queries: How many flats are there whose areaSqft is less than the 1200. How may floors exists in flatMaster table Can you figure out how many 2 BHK flats are there in the apartment? How may 3 BHK flats are there in block B? Display the smallest size of 3 BHK flat  Find , how many residents are there who have non gmail email account? How many maids are there who actually know cooking How many male maids are there who can also do cooking ? How many maids are there who have got "Good Behaviour" and comments by residents? Who is/are the highest ratings maids Can you figure out the each maid's years of...