Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Database Table Design
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  4 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Jama  
View profile  
 More options Nov 7, 3:27 pm
Newsgroups: microsoft.public.sqlserver.programming
From: Jama <J...@discussions.microsoft.com>
Date: Fri, 6 Nov 2009 20:27:01 -0800
Local: Sat, Nov 7 2009 3:27 pm
Subject: Database Table Design
I have a [user] who belongs to a [group] and writes an [article] using a
certain [computer].
The user can move to a different group and a computer can be assigned to a
different person. Also, we rent the computers from a company that charges us
per hour usage. So we receive a [bill] monthly for a [user] of certain
[group] using certain [computer].
My attempt for the first part is as follows but I am not sure. I ask help
for where to start.

   User-->UserGroup<--Group
    |
   userComputer
    |
  Computer

Thanks


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Augustin Prasanna  
View profile  
 More options Nov 8, 7:33 am
Newsgroups: microsoft.public.sqlserver.programming
From: Augustin Prasanna <AugustinPrasa...@discussions.microsoft.com>
Date: Sat, 7 Nov 2009 12:33:01 -0800
Local: Sun, Nov 8 2009 7:33 am
Subject: RE: Database Table Design
Can the user use multiple computers when he is tagged to one specific group?
Any relation between group and computer?


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jama  
View profile  
 More options Nov 8, 8:21 am
Newsgroups: microsoft.public.sqlserver.programming
From: Jama <J...@discussions.microsoft.com>
Date: Sat, 7 Nov 2009 13:21:01 -0800
Local: Sun, Nov 8 2009 8:21 am
Subject: RE: Database Table Design
Yes, A user can be assigned to one or more computers but a computer can be
assigned to one user at a time. No relationship between a group and a
computer as I know but you can suggest me one if possible.

Here is more.

We open an account with  a computer supplier to each of our groups{fiction
writers, technology writer etc}. The supplier assigns a number to each group.
We receive a computer from the supplier with computer number as assign it to
one user within a group. A user can move from group to another but belongs to
one group at a time. A computer can be assigned to a different user. The
computer sends the supplier hourly usage by the user.

The computer supplier sends a bill containing several pages.
1)Hourly usage of each day per row by a user in a group using a computer.
  GroupId UserName ComputerId Date hoursUsed rate tax total
2)Computer usage summary. Hours used per month for each computer. Summarises
each computer use per month
     GroupId UserName ComputerId hoursUsed rate tax total
3)Group summary : summarises monthly usage per group
    GroupId hours rate total

Thanks


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
--CELKO--  
View profile  
 More options Nov 8, 8:24 am
Newsgroups: microsoft.public.sqlserver.programming
From: --CELKO-- <jcelko...@earthlink.net>
Date: Sat, 7 Nov 2009 13:24:54 -0800 (PST)
Local: Sun, Nov 8 2009 8:24 am
Subject: Re: Database Table Design
I will guess that you are getting stuck on the temporal aspect of the
model.

Since Computers and users are entities, you will need a table for each
of them.  Computer Sessions will reference a user, a computer and a
start-end time pair for usage.  UserGroups are a relationship among
users, so that table will have a group id, reference to the users and
start-end time pair for their group assignment.

 Can I assume that one user is on one machine at any particular time?
Can I assume that nobody is transferred to a new group in the middle
of a session? You can handle those things with REFERENCES and UNIQUE
constraints.  So you can compute the duration of each session, then
use the start time of the session to find what group the user was
assigned in that session.


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google