Published on February 10, 2014
Topic 9 Database Design Er. Pradip Kharbuja
Systems Analysis & Development Systems Analysis The art of understanding and documenting the requirements of a given set of users within the context of an organization. Systems Development The development of the whole system from beginning to end. This might include a database, applications, a network etc.
Approaches to System Development There are many different approaches to systems development. 1. Traditional systems development lifecycle (SDLC) or ‘waterfall’ approach 2. Iterative approaches Understanding requirements is vital to being able to produce a finished system that meets the business needs of an organization.
Waterfall Approach Traditional systems development lifecycle (SDLC) Also known as Generic Systems Development Lifecycle This involves a complete set of steps that a team follows. The fundamental idea is to divide the development process into a series of phases or stages, each of which finishes before the next one starts. This process is often viewed as a cascade of steps, which is why it has been called the waterfall approach.
Waterfall Approach 1. Strategy and planning 2. Feasibility study 3. Systems analysis (or analysis) 4. Design 5. Implementation 6. Maintenance
Problems with Waterfall Approach Users have not communicated requirements properly Users have not understood their own needs Analyst misunderstood Omission
Prototypes and Prototyping Prototype – a first or original example of something from which others have or will be developed Prototyping – the process whereby a model is built of part of the envisaged system and user feedback on it is gathered. Part of the requirements gathering process Note: a prototype is a thing. Prototyping is something we do.
Database Design Database Design means moving from a set of requirements to implementing these with database technology. Moving from a set of requirements Database Technology
Phases of Database Design Conceptual design Logical design Physical design
Conceptual Database Design Investigation of data needed to support system Design is undertaken without regard either to the physical implementation or data model. So the designers at this stage do not even assume they will be using the relational model. The sorts of areas of investigation are: what data does the enterprise hold? In what format is it? How is it used?
Logical Design Logical Database Design constructs the model without regard for the particular DBMS that will be used. However, the data model (e.g. the relational model) is known. A key activity is normalization. The output of logical design will be an Entity Relationship Model.
Physical Design The moving from entities to tables is one of the key activities here involving what is known as designing the base relations. But this phase also involves other activities, such as indexing, renormalization, view creation and query tuning.
Case Tools Computer Aided Software Engineering Design tools Documentation tools Code generators
1. Er. Pradip KharbujaTopic 9Database Design . 2. Systems Analysis & Development Systems Analysis The art of understanding and documenting the requirements ...
A beginner's guide to SQL database design ... edited Jan 12 '09 at 15:02. ... 2 revs, 2 users 100% ripper234. closed as off-topic by bummi, TylerH, Pang, ...
Design; Devices & Hardware; ... Database Ielts 09 Jan 13, 2015 Education febrian-setiadi. ... Database Database Database ...
Relational Database Design - Normalization: Search: ... 09:57 PM. Hi there Very nice topic, ...
Topic 09 : Database Design IELTS Vocabulary: Learn 5 Words Today (09 September 2014) IELTS Vocabulary - Free IELTS exam practice exercises and tests ...
Could someone please lead me to a sample database for a financial accounting system? ... Sample Database Design for Financial ... This is a big topic.
Design; Devices & Hardware; Economy & Finance; Education; Engineering; ... Topic 02 : Database & DBMS; Topic 02 : Database & DBMS Jan 18, 2015 Education ...
The world's most popular open source database MySQL.com; ... Data Dictionary Architecture and Design; MySQL 8.0 Labs: ... Topic Guides; MySQL Cluster; Legal;
Database->Design->Luna shop. 24-08-2016: US section of the database was updated up to version 5.1. ... 09-06-2014: - database updated up to version 4.7.