Solved

Table design idea for Calendar

Posted on 2011-09-22
2
254 Views
Last Modified: 2012-05-12

I need to design a table for a calendar. I'll be using Telerik's calendar control. User opens the calendar in week or month view. They
click on , for example, Thursday 1 PM March 2012 and Tuesday 2 PM October 1st, etc.  I need to save calendar choices in the database for each user. Multiple choices (dates) for each user.

How can I design this table? Do I need more than one table? One for each month, one for each day, one for each hour? and one for each month?
(I need to read the data back as well and populate the calendar control with this data...for example, mark the calendar red or something.)
0
Comment
Question by:Camillia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 21

Accepted Solution

by:
JestersGrind earned 500 total points
ID: 36581412
It sounds like you are trying to associate a date/time with a user.  Assuming that you already have a Users table, I would add a Schedule table with a ScheduleID as it's primary key.  ScheduleID could be an identity column.  Then a UserID column with a foreign key reference to your Users table.  Then a ScheduleDate datetime column to hold the date/time of the scheduled date.  Maybe a few other columns depending on what other characteristics you need to capture like comments, color if you allow the user to select this, etc...

Greg



0
 
LVL 7

Author Comment

by:Camillia
ID: 36581460
ah, yes, i dont need to separate day, time, month, etc tables. Thanks. I will try that.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question