Showing posts with label database life cycle definition. Show all posts
Showing posts with label database life cycle definition. Show all posts

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:


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