Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Discovering SQL: A Hands-On Guide for Beginners
This is the forum to discuss the Wrox book Discovering SQL: A Hands-On Guide for Beginners by Alex Kriegel; ISBN: 978-1-1180-0267-4
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Discovering SQL: A Hands-On Guide for Beginners section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 15th, 2011, 03:35 AM
Registered User
 
Join Date: Jun 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Question Database for Project Auditing

hi

i am new to Databases and Programming...I want to Design a project Auditing Tool..to be used by project Managers and Auditors

I have the following Tables:


Employee(Id,Fname,LName,etc)
Project(projectId,projName,description,CompanyID)
Company(id,Name,City,Project)
Questions

First User is the auditor who will asses the project using a set of Questions stored in Database and give a score based on the answers given

Manager will want to view Overall score for a particular Company that has multiple project and also view score for the individual projects


how do i link these tables



Can somebody help please




Similar Threads
Thread Thread Starter Forum Replies Last Post
Trigger-based auditing to your SQL Server database maulik77 SQL Server 2000 0 April 2nd, 2009 02:11 AM
The beerhouse project, problem with the database jansek BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 4 September 2nd, 2008 02:50 PM
Win2k3 Auditing: Which Event ID help... Arsi Windows Server 0 March 31st, 2008 02:52 PM
VS2005 database project pzmrcd Visual Studio 2005 0 January 16th, 2007 12:54 PM
ASP Database Project jasmine5544 Classic ASP Databases 1 November 13th, 2003 10:23 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.