The steps in developing
any application can be represented as a linear sequence where each step in the
sequence is a function, which passes its output to its successor function.
Adherence of a ‘waterfall development model’ ensures quality software, which is
‘complete’, ‘efficient’, ‘usable’, ‘consistent’, ‘correct’ and ‘flexible’.
These traits are also some of the core underpinnings of a well-built database.
The waterfall model can be applied to database design theory as effectively as
it is applied to other software engineering theory. The steps can
be summarised as follows:
Subscribe to:
Post Comments (Atom)
SQL Script to list out name of tables and its records in the database
SET NOCOUNT ON DBCC UPDATEUSAGE(0) -- DB size. EXEC sp_spaceused -- Table row counts and sizes. CREATE TABLE #temptable ( [name] NVA...
-
A FILL FACTOR is one of the important arguments that can be used while creating an index. FILL FACTOR specifies a value interns of t...
-
There are multiple ways to do this. 1) INSERT INTO SELECT This method is used when table is already created in the database earlier...
-
A SPARSE column is a special type of column that has optimised storage for NULL values. It also reduces the space requirements for null val...
No comments:
Post a Comment