Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stairway to Database Design - STEP 4: Building a Schema Expand / Collapse
Author
Message
Posted Wednesday, August 18, 2010 12:08 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 12, 2014 8:24 PM
Points: 1,945, Visits: 3,173
Comments posted to this topic are about the item Stairway to Database Design - STEP 4: Building a Schema

Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
Post #970930
Posted Thursday, August 19, 2010 8:39 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:23 PM
Points: 1,792, Visits: 5,041
Thanks for pointing out the option of using check constraints in a view. It certainly does perform better than a correlated query in a table check constraint, or even wose, doing this type of relational check within a trigger.
Post #971932
Posted Friday, November 11, 2011 9:00 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 17, 2014 8:47 AM
Points: 54, Visits: 428
IMO, this STEP is really step 1 or step 0. There is a seamless approach to transition from conceptual and logical requirements ER models to physical design and implementation scripts. This approach implies that the requirements analyst be a competent ER modeler, but this really is not that big a challenge.

When I do data requirements and database design, I do them in two different views of the same model in a modeling tool. This both improves requirements traceability and ensures design simplicity.
Post #1204232
Posted Wednesday, October 16, 2013 5:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 7:55 AM
Points: 8, Visits: 54
You write: "You can get an ER diagram from the SQL DDL with several tools."

I'd find an article on the above statement very helpful.
Post #1505152
Posted Wednesday, October 16, 2013 8:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 8:23 PM
Points: 2, Visits: 4
schedule ssrs reports http://www.christiansteven.com/business-automation-systems-schedule-ssrs-reports
Post #1505466
Posted Friday, October 18, 2013 5:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 18, 2013 5:26 AM
Points: 3, Visits: 0
Welcome to http://www.b2cmall.us//

where is the most popular Panthers online shop.


((( http://www.b2cmall.us/ )))

lower price fast shippment with higher quality!!

WE ACCEPT CREDIT CARD /WESTERN UNION PAYMENT
YOU MUST NOT MISS IT!!!
Post #1506094
Posted Friday, October 18, 2013 5:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 18, 2013 5:26 AM
Points: 3, Visits: 0
Welcome to http://www.b2cmall.us//

where is the most popular Panthers online shop.


((( http://www.b2cmall.us/ )))

lower price fast shippment with higher quality!!

WE ACCEPT CREDIT CARD /WESTERN UNION PAYMENT
YOU MUST NOT MISS IT!!!
Post #1506095
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse