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...
-
1. Direct connections via the Internet These connections can be used to attach to SQL Servers sitting naked without firewall protection...
-
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...
-
The steps in developing any application can be represented as a linear sequence where each step in the sequence is a function, which passe...

No comments:
Post a Comment