normalization/functional dependencies

Good day all,I have a need for clarification in regards to normalization/functional dependencies as it pertains to the relational model of data. In particular, the question deals with noloss decomposition in relation to functional dependencies. Scenario:Given a table R with attributes (A, B, C) and ...

Finding DB2 Functional Dependencies

I found a post that gave a query for routines/procedures, but when I plugged my values for my function it returned an empty result set. It appears that functional dependencies are stored in a different table. I can go through our views and functions line by line, but surely there is a way to see whi ...

functional dependencies

i am a engineering student in india.i have a doubt regarding the database design.in the logical database design we use the concept of functional dependencies and the closure using Amstrong's axioms . What is the basic necessity to find the closure of the functional dependencies.one more Question::if ...

Functional dependencies,,,,,need assistance for this homework problem urgently.....

Consider the relation R, which has attributes that hold schedules of courses andsections at a university: R= {CourseNo, SecNo, OfferingDept, Credit-Hours,CourseLevel, InstructorSSN, Semester, Year, Days_Hours, RoomNo, NoOfStudents}.Suppose that the following functional dependencies hold on R:{Course ...

Functional dependencies

If I have R<A,B,C,D,E,F,G,H>, with A->BDE, G->CB, CF->H and if I'm asked to find1. a canonical "covering" (I don't know the exact term, I hope this is clear enough)2. all keys3. which functional dependencies violate the 3NF4. normalize the schema to 3NF,how do I find the can ...

Functional dependencies and Primary Key

I have a problem regarding functional dependencies and selecting a primary key. Any help would be greatly appreciated. My question is:1. If we have a table in unnormalized form, what sequence of steps should we follow to determine the functional dependencies and primary key. a. Should we first deter ...

Q about normalization and functional dependencies

I have a university project to design a database system consisting of a bunch of entity sets and relationships. I have a basic idea for a system which would benefit me in my electronics hobby, basically an application to help me keep track of what components I have where, how many, and how many of t ...

Help with Functional Dependencies

Could anyone tell me what the functional dependencies would be for the following tables? Part (PartNum, Description, OnHand, Class, Warehouse, Price, (OrderNum, OrderDate, CustomerNum, CustomerName, RepNum, LastName, FirstName, NumOrdered, QuotedPrice))Invoice (InvoiceNum, CustomerNum, LastName, Fir ...

Oracle Query rewrite, ATTRIBUTE clause and Functional dependencies.

I have some conceptual doubts about CREATE DIMENSION. According to Oracle documentation about "How Oracle Rewrites Queries", the HIERARCHY clause "declares... 1:n functional dependencies. The 1:1 functional dependencies are declared using the DETERMINES clause" I assume that the expression "function ...

Oracle Functional Dependencies

If you have three functional dependencies:(1) A, B -> C(2) A, B -> D(3) A, B, C -> DWhen designing relations that need to preserve these functional dependencies, is it safe not to take into consideration (3)? I feel that (3) can result from (2) in the following way:A, B -> D <=> A, ...

Normalization with no functional dependencies

I'm currently doing a databases subject at university and I'm studying for my exam. I've been looking through past exams (which all feature a decent amount of normalization), and I'm stuck on one of the questions.The question simply asks me to find the highest normal form of a schema - no actual nor ...

Functional dependencies

there are 2 relations R(A,B) and S(B,C) where |R| = 3000,|R| = 1000 and B is the primary key of S.Then |R| natural join|S| <= 1000.Is this true or false?I think R Natjoin S is less than or equal to 1000,but the answer is false....why is this so? please answer..... ...

Functional Dependency

Can anyone derive the functional dependencies for the following set:Reservation {CustomerNIC, FirstName, LastName, Street, City, TelNo, EventID, EventName, EventType, OrganiserID, OrganiserName, OrgTelNo, ReservationNo, TicketID, Class, Issued, Reserved, Sold, UnitPrice, NoOfTickets, ReserveDate, Co ...

Wierd Looking Functional Dependency in a Normalization Problem!!

Today, I've encountered a wierd looking functional dependency in a question on normalization in a university exam, and I'm now urgently seeking answer to that. Anybody wanna try it?The question was exactly as follows:"Given a relation, R(A,B,C) and a set of functional dependencies {Ø -- ...

Functional Dependency Question-Answer (Revision)

Is it ok for me to post some revision work and ask for it to be corrected here?I am revising for a repeat exam atm and I have nobody to correct my work..Here goes:Question:Table for questionUsing the following example business rules and the example table of Appendix A (at the back of this exam paper ...

help with functional dependency / candidate keys

guys I have the following assignment to solve : 1. Let schema R = (A;B;C;D;E), with the following set of functional dependencies F:A →BCEB → CCD → EB → DE → A(a) List all candidate keys for R (4 points).I don't want the solution just an explanation where should I start ...

Functional dependency

I have some attributes of car , Regd_no, Make, Model, Year_of_production,First_registration_data,Fuel_ty pe,Capacity,Purchase_price and Original price.i need to find the functional dependencies. I've tried some and would like to know your comments whether i'm correct.Regd_no -> Year_of_production ...

Is this a correct decomposition (functional dependency question)?

I have this relation:R(A,B,C,D,E,G)F = { AB -> CAC -> DAD -> EB -> DBC -> AE -> G }I need to project the original relation's functional dependencies onto the decomposed relations below. My question is, can I say that R3 carries E->G even though E->G is a deducted functional d ...

Functional Depencies

I need help in determining functional dependencies of the given entity sets below. I have also included my answers, please check and advice.Thank you.OWNER (Owner_SSN, Owner_Name, Owner_Address, {Owner_TelNo})Owner_SSN -> Owner_NameOwner_Name -> Owner_Address, Owner_TelNoCAR (Car_RegNo, Car_Ma ...

Trivial Functional Dependency

Having a little trouble wrapping my head around trivial functional dependencies and BCNF. Assume you have a relational schema F(A,B,C) with FD'sA->BB,C -> ANow to see if this is in BCNF, the second FD is a super key but is the first one trivial? Another FD can be made by closure that says B,C ...

PL/SQL Query

HiI am using Oracle 9i and need to create and populate some tables which allow me to ensure that no update or insert anomalies can take place. The schema is:The set of functional dependencies F = {AB C, C  A} exist on a relational schema R(A, B, C). Such a relation is in Third Normal ...

read data from oracle

i m working on a tool and i require to read data and functional dependencies right from the oracle ... can anyone help me ? ...

Decomposition Question

When I have a universal relation schema like R = {A,B,C,D,E,F,G,H,I,J} and the following functional dependencies defined on R: AB->C; A->DE;B->F; F->GH; D->IJ. How can I find a decomposition D1= {R1, R2, …, Rn}, such that each Ri is in 3NF, and D1 has dependency-preserving property, ...

Transitive Dependence et al

Any recommendations for any Windows and/or Linux tools to helpnormalize a database? It's essentially a combination of severalexisting databases (that have some related information) into a singleone.Also, recommendations for books on the theory of database design,especially a temporal relational data ...

Tiger Furniture company!!

Tiger Furniture CompanyThe Tiger Furniture Company sells a number of different furniture products around KualaLumpur area. These products are grouped into several product lines. The identifier for aproduct is Product_ID, while the identifier for a product line is Product_Line_ID.Referring to the cus ...

non redundant covers

Does anybody have some theoretical idea about functional dependencies.I have to find non redundant covers and convert a relation to BCNF. But i am unable to understand the concept.My question is:Consider the following relations and the set of Function Dependencies(FDs): SHIPMENT (ship_id, S_capacity ...

normalization exercise (was: some other title)

Well this is the situation, I am currently studying Computer Science at University and have only studied a little bit of Databases in the past, enough to keep me going when I was doing it, but now I have taken database modules and everyone seems to know what they are doing.I am really struggling in ...

Decomposition theorem (properties, BCNF, DP)

I've done my homework about databases. It is even corrected, however at some points I disagree with the answers, can someone help me to get this cleared up?Let R(XYZ) relation with attributes XYZ, if there is a X->Y (functional dependency), then the decomposition R(XY) and R(XZ) is lossless. (thi ...

Dependency Preserving

I have a small question about dependency preserving. Example I have the following functional dependencies: A->BCD, BC->D, AD->DE. And I have the following relational scheme: R(ABCDE).If I decompose it in the following relation: R(ABC), R(BCD), R(ADE). Now how can I see whether this decompos ...

Normal Form help, please

If I got a relation R(A, B, C, D) with functional dependencies:FD1: A -> B,C,DFD2: C -> AWhat normal form is the relation R in? ...

little normal form problem

I had a normal form problem, my relation is R(a, b, c, d) with functional dependencies of F = { [abc > d], [bcd > a], [a > b] }just wondering what the possible subsets of F are? ...

Help! Normalisation

Im a student and we have been given a task of normalising the following information. Im not asking for the answers im just looking for a point in the right direction as im really struggling.Normalise the following relation to 3rd Normalform:Retail( rID, rlocation, (staffID, staffName, staffPhNumber) ...

Ubuntu Complex Task Organizer

I'm looking for a program that will help me organize complex tasks in the real world. I've tried Evolution, however it doesn't seem to that rich in this regard. I'd like a way of specifying 'overall' tasks and then breaking them into subtasks specifying functional dependencies. (e.g. A prerequisite ...

Database reverse engineering problems

To all fellow geeks and to whom have prior knowledge in database design, I'd like your consultation on several issues I've faced in my project. So first I'll give a brief explanation about the it:We are supposed to develop the following software:Semi Automated ER diagram generator Input:Meta data (d ...

Please help! 3NF

Good evening,I am trying create new table from 2nf to 3nf but functinal dependencies confusing me. Do you see any errors? Thank youPATIENT (VisitNo, VisitDate, PatNo, PatAge, PatCity, PatZip, ProvNo, ProvSpecialty, Diagnosis)The functional dependencies for the table are:PatNo  PatAge, PatCity, Pa ...

Oracle Need Help with SQL Book

I am a student going to BCIT's Computer Systems Technology course and I am supposed to read this book "Visual Quickstart Guide SQL Second Edition and I am having trouble understanding some of the things this author is saying. Mainly because he is speaking in such an unnecessarily complicated English ...

Ubuntu Uninstall Oracle 10gXE???

Has anyone ever uninstalled 10gXE from ubuntu server? I ask because I (apparently) didnt do my homework prior to installing the suite.I wanted to relocate the data files to a RAID for expansion purposes. I wanted to generate a separate set of RDBMS files for other applications (on the RAID).I discov ...

Help With Normalization

I've this table to normalize where there are no primary keys and mutual functional dependencies.The table is R = { a1,a2,a3,a4 }Functional dependencies:fd1 = a1->a2fd2 = a2->a1fd3 = a1,a3->a4fd4 = a1,a2->a3I think it's in 2NF because there are no keys. But what about 3NF?A relation is in ...

Oracle Doubts in Normal Forms 2,3,BCNF,kindly explain

I am trying to learn normalization so kindly bear with meArent 2 Normal Form and 3 Normal Form the same2NF:For a table to be in 2NFThe table should be in 1NFThere should be no duplication in the table,the columns with repeated data must be placed in another table.The table should consist of a foreig ...

Oracle Creating 3NF Schemas

Does oracle have any tools for automating the creation of 3nf schemas based on the input of functional dependencies? ...

Need help understanding decomposition and anomalies

I'm having trouble understanding the concept of decomposition.So far, I think decomposition means: decompose one relation into 2 or more relations to eliminate anomalies and redundant information. Is that right?I understand the definition of insert, delete and update anomalies. I just dont understan ...

How to decompose table with reference to Heath's Theorem? [Homework]

I'm having trouble with a certain aspect of a worksheet that I have for my DBA module. Any advice would be greatly appreciated, thanks.I have a general understanding of Heath Theorem but I'm having trouble getting my head around this question:Quote: Use the functional dependencies to carry out a non ...

Help me in normalization

Sign(MemberID, MemberName, ActivityID, ActivityName, SessionID, CoachID, CoachName, Day, From, To)The table Sign record the enrolment information of sports club members in sports activities. The information recorded are the the member name, member id, the activity name, the activity id, a session id ...

Can we override layer dependencies if it suits us?

Can we override layer dependencies if it suits us? cyclic dependencies Though out my RUP life I though NO, we don't, we simply can't ... its THE rule.       Our fellows came up with these two paradigms; discussed below:   (Considering connection is created on all DB Layers a ...

Ubuntu HOWTO: functional eye-candy with Avant-Window-Navigator

This thread is a repost of my old guide, which can be found here: http://ubuntuforums.org/showthread.php?t=385981Attention: Due to my lack of time/interest and my recent change of distro to Archlinux, these repositories are no longer maintained. I would instead recommend that you follow the instruct ...

Ubuntu KDE and Gnome 64-bit dependencies

I had to reinstall on the weekend due to hopeless dependencies with Enlightenment. (Why oh why do I keep chasing that unicorn?!?)I installed Mint 8 KDE as my default Linux, though I want to also have Gnome as an alternate DE. I like the speed and simplicity of Gnome, plus it offers more applications ...

Ubuntu f4l.sourceforge.net - f4l dependencies

Hi! I'm trying to get f4l (flash 4 linux, though they're bound to change their name) to run okay on ubuntu. Actually, I can install it and run it, and I'm not really expecting much of it yet since it has just started beta, but while I install the debs, it tries to look for things outside of our repo ...

Ubuntu HOWTO: functional eye-candy with Avant-Window-Navigator

NOTICE: This thread has been superseeded by this one: http://ubuntuforums.org/showthread.php?t=762363Please go there instead, as this thread will no longer be updated.Info:What is it?:AWN is a compositing dock-like taskbar. It is similar to the dock in OSX, but supports features such as custom theme ...

Project dependencies in VS2010

If you have a fairly elaborate set of MFC extention dll's and applications in a solutionSay A.Dll, B.Dll and C.Dll and D.dll derive from MFc directlyAB.Dll derives/combines and extends classes from A.dll en B.dllBC.Dll derives/combines and extends classes from B.dll en C.dllAnd a set of various appl ...

Ubuntu QtSDK libraries - dependencies

I'm using Ubuntu 9.04, and trying to install a v4l2ucp package from a .deb. It says that "Error: Dependency is not satisfiable: libqtcore4 (>= 4:4.6.1)". libqtcore4 is installed on my system (I can see it in synaptic, version 4.5.1). Also QtSDK is installed on my system (the latest vers ...