June 4, 2010 at 9:58 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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy