June 4, 2010 at 9:57 am
Hello folks i am assigned a task to design a plan of action for a DB design for a new project.
I jotted this down as far as my knowledge, i would like you guys to please critique this and correct it.
Plan of Action
I DESIGN
Make a list of entities
Relationships
ERD/ Data Model
II DEVELOPMENT
List of querries we want out of DB
Reduce Data Redundancy
Do some Data restructuring
List Data I/O Sources
List out Contraints
Normalization
Decide upon keys
Analysis of all fields (data types)
II PHYSICAL IMPLEMENTATION
Create Schema
Naming COnventions
Implement Referential Integrity
Triggers/Constraints
Querries/Stored Procedures
Data I/P mechanisms(Selcet * INTO)
IV TESTING
Load Sample data
Test out all Queries
-- Please help/Critique/Comment/Suggest
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
June 4, 2010 at 10:08 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic932919-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply