Relational Theory

• Topics

  Started by

  Posts

  Last post

• Category, Sub Category and Article Relation

  Hi everyone I want to know what would be best practice for the following scenario: Article table wi…

  Jako de Wet

  3 replies

  13 years, 2 months ago

  By: Jako de Wet

• my favorite normalization case study

  the problem is an attendance tracker for an educational institution. The foreign keys would have st…

  patrickmcginnis59

  11 replies

  13 years, 4 months ago

  By: PaulB-TheOneAndOnly

• help

  i am working on e learning and certification i have this prob on maintaining the details of student…

  kavyap.kp

  8 replies

  13 years, 4 months ago

  By: Grant Fritchey

• Need Help with EER Diagram and Tables

  Hi I am taking MIS class and i need help with the EER diagram and i tried making it myself but teac…

  princess_tahseen

  6 replies

  13 years, 4 months ago

  By: Devendrakumar

• Normalization

  http://lambda-the-ultimate.org/node/3762 [p] Some of long-standing issues being revisited, but it i…

  sjsubscribe

  144 replies

  13 years, 7 months ago

  By: Don Halloran

• It May Have Jumped The Shark

  The Big Bang Theory DVDA funny show with one of the catchiest theme songs of all time (even if part…

  lemotry

  1 replies

  13 years, 7 months ago

  By: Gail Shaw

• NULL Valued Foreign Key Alternative?

  I am doing a lot of cleanup on a database that desperately needs it! There are very few primary / f…

  lucidspoon

  3 replies

  14 years, 1 month ago

  By: TomThomson

• Poor database design

  Not sure where to post this and I'm not sure if I am going to gain anything by posting this. At the…

  Sean Pearce

  22 replies

  14 years, 1 month ago

  By: Sean Pearce

• varchar versus nvarchar

  I just discovered a problem in the database design for an application that was developed years ago.…

  SqlOnMyMind

  16 replies

  14 years, 3 months ago

  By: Pouliot Philippe

• mixing numeric and text data in a single column

  Hello All, My partner thinks its ok to send me a data file where they mix numeric and text data in …

  Chrissy321

  6 replies

  14 years, 3 months ago

  By: GSquared

• Table design

  Hi, I was wondering if a Db design guru could provide guidance for a db newb?? I have to design a d…

  IPO

  4 replies

  14 years, 4 months ago

  By: TomThomson

• Opinions About the Design of my Database

  Hello, I have been storing data regarding my cardio exercise in an Excel spreadsheet for the past t…

  Polymorphist

  7 replies

  14 years, 5 months ago

  By: Johan Bijnens

• Normalization vs Denormalization

  Hello I have some doubts when should i use the normal form or when i shouldn't. I'm creating a very…

  rootfixxxer

  13 replies

  14 years, 6 months ago

  By: TomThomson

• Partial order vs. total order

  Hi folks, I've been trying to understand transactions better, so I've started reading Transactional…

  ta.bu.shi.da.yu

  2 replies

  14 years, 7 months ago

  By: ta.bu.shi.da.yu

• Surogate Keys are not always the answer but are freqently used

  I read an article today on this site today about Surrogate Keys. I attended my first relational dat…

  Welsh Corgi

  38 replies

  14 years, 7 months ago

  By: TomThomson