Saturday, November 11, 2017

Databases Design and Development Lifecycle

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:


No comments:

Post a Comment

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...