Hi i am a little unsure of how you do this problem:
A company wishes to allocate staff to a new project that as been proposed by the company. As a result, a new relation was created for this propose as follows:
Staff_Project (Staff_No, Proj_Id, Proj_Name Proj_Location, Staff_Hours, Staff_Name, Staff_Address)
Assuming that,
Staff_No stands for staff number of the employee;
Proj_Id is identifies of one of the projects that the staff works on;
Staff_Hours is the number of hours per week that the staff works on the project;
Proj_Name and Project_locatio n are the name and location of the project;
Staff_Name is the staff surname;
Staff_Address is postcode of the address of the staff.
_______________ _______________ _______________ _______
This is what is needed:
(a)Using appropriate diagrams to aid in your answer, briefly describe the concepts of “Normalisation” and “Functional Dependencies”. You should then describe the relationship between them with examples.
(b)Based on the given primary key (Staff_No, Proj_Id). Show, comprehensively , how you would normalise the relation to third normal form, indicating the functional dependencies you use in each stage of normalisation with justifications. State any assumptions you make about the data, if any.
(c)Identify the primary and foreign keys in your 3NF relations.
_______________ _______________ _______________ _______
This is what ive done so far:
(a)Concepts of Normalisation and Functional Dependencies with the use of diagrams.
Staff _No ------------ Staff_Name
Project_Id -------- Proj_Name and Project_locatio n
Staff_Name ------ Staff_Address and Staff_Hours
dotted lines are functional dependant
Your help and advise is much appreciated
Thanks
2 1711
I would have thought that this would result in 3 tables;
Table1: Staff (Staff_No [PrimaryKey], Staff_Name, Staff_Address) - The Staff_No is the only unique field.
Table2: Projects (Proj_ID [PrimaryKey], Proj_Name, Proj_Location) - The Proj_ID is the only unique field.
Table3: ProjectTime (Proj_ID [ForeignKey], Staff_No [ForeignKey], Staff_Hours) - This table does not need a primary key but you could assign a new unique index if you wish. It would probably be useful in a real situation. The Foreign keys are the primary keys in their own tables.
hope this helps.
hiya i have exactly the same scenario of ur courswrok n am really stuck. can ya giv us any way of starting it. thanks
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Michael Lauzon |
last post by:
Database Normalisation Advisor
Designated Contact: thox, xpl2
Status: Open
Open Date: 2004-10-26 11:53
For Project: Lands of Myths & Legends
(http://sourceforge.net/projects/lamyle/)
Long Description:
Our project requires someone to advise us on the database structure
for a game that we are planning to create. The key requirements are
|
by: Michael Lauzon |
last post by:
Database Normalisation Advisor
Designated Contact: thox, xpl2
Status: Open
Open Date: 2004-10-26 11:53
For Project: Lands of Myths & Legends
(http://sourceforge.net/projects/lamyle/)
Long Description:
Our project requires someone to advise us on the database structure
for a game that we are planning to create. The key requirements are
|
by: Michael Lauzon |
last post by:
Database Normalisation Advisor
Designated Contact: thox, xpl2
Status: Open
Open Date: 2004-10-26 11:53
For Project: Lands of Myths & Legends
(http://sourceforge.net/projects/lamyle/)
Long Description:
Our project requires someone to advise us on the database structure
for a game that we are planning to create. The key requirements are
|
by: David Allison |
last post by:
Should Lookup fields be replaced by table normalisation? Then the Tables
brought together in a Query for a Form to be based on?
--
Dave Allison ~ Scotland
|
by: James W. |
last post by:
Hi everyone,
I would like to ask you lot if you know of a great place on the
internet for a fool proof idiots guide to Normalisation 1st, 2nd, 3rd.
I looked at webopedia but that is just as confusing.
I am looking for a complete idiots guide that really is so simple all
it needs is pictures to turn it into a kiddies book
| |
by: Michael Thomas |
last post by:
Hi everyone
Not sure if this is the right newsgroup to be posting to for this question,
but I am using Access 2002 to develop a database solution for the company
that I work for. It's basically as stock control system where I need to
keep track of the quantities of products.
Our company is a retail chain, and we have eight shops or locations and a
head office. The tables that I've set up are as follows
|
by: Macbane |
last post by:
Hello All,
This has been bugging me for too long. I have a database that records
medical interventions. I am familiar with the theory behind
normalisation but am unsure what to do with the following data.
Firstly, I have a main table which records the specifics of the
intervention (date, reporter, details, location etc). It has links and
the database is normalised ok as far as I can make out. However, I
have 6 check box fields in...
|
by: shauna |
last post by:
hi, i am an As level student studying Applied ICT, im having problems with normalisation.
our problem is to computerise a made up business.mine for example is a beauty salon. below are my attributes and they need to be normalised to 3rd normal form! i have also shown what i have come up with but i am unsure as to whether it is correct!
please help as im finding this very difficult.
Normalisation
The goal of normalisation is to create a...
|
by: mikek12004 |
last post by:
I have a table for categories (id->the primary key, and name) and I want to add another column parent (one category might be inside another) with the id's range of values so in fact parent will be a foreign key of the id right?Can I declare a foreign key of a primary key in the same table as that primary key or it is better make a seperate table for the relationships between categories? (lately been reading about db normalisation and wandering...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |