Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

database normalization help?

 
   Database Forums (Home) -> General Discussion RSS
Next:  Making a foreign key where column values aren't r..  
Author Message
haha73




Joined: Feb 18, 2009
Posts: 1



(Msg. 1) Posted: Wed Feb 18, 2009 1:29 pm
Post subject: database normalization help?

Moving from FoxPro flat files to relational database. I am working out the design in Access but will eventually move the live system will be in SQL Server. I can email image of design or the Access database.

The problem is two paths that both start in one table [P] and end in another [S]. It doesn't look right. Does anyone know how to solve this design problem?

[P] -- [PM] -- [M] -- [G] -- [S]
[P] -- [PT] -- [T] -- [S]

[I] -- [S]

Because [P] had many:many relationship with [M], intermediary table [PM] created with primary keys of [P] and [M] combined to form composite primary key in [PM].

Q1: [PM] should have 1:many with [M] but the relationship created was 1:1 and I can't edit it.

[M] has 1:many with [G]. [G] has 1:many with [S]

Because [P] has a many:many relationship with [T], intermediary table [PT] created with primary keys of [P] and [T] combined to form composite primary key in [PT].

Q2: Should [T] be linked to [S]? What I want is the ability for the user to select T info from T and place into a S record, but I want to limit the choice of T info, based on the choice of P record. (With or without a link on Relationships tab between T and S, the T field in the S record allows a query into T. So is the link necessary? But I still don't know how to code to limit the T info to those relevant for the related P.)

Q3. [I] has a 1:many relationship with [S]. [I] will be used to combined multiple records from [S] into a single output. Is it OK to have multiple 1:many relationships with 1 from other tables and many in a single table

 >> Stay informed about: database normalization help? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
i'm looking for a database - do you know if exists a database for pocketpc running windows mobile 2k3? i mean a real stand-alone dbms........... t.i.a.

ACT database - Is anyone here familiar with a user's group for ACT database, better known as ACT for Windows? Thanks, Willy

Which Database - Hello I am writing an application that will require database access. This application will be deployed onto users machines, often using portable equipment such as laptops. Before I can begin writing the application I need to research the available..

Writing a database using C++ - Hi, I am a student trying to write a simple database management system using c++. I was wondering if anyone knew of any good websites or books that could help me accomplish this goal. Thankx.

Database security - Is there a way to create and encrypted database file? What do people do when data security is important at the file level? In other words, you don't want anyone to be able to take the database file (or files) and extract data from them. Ideally, I..
   Database Forums (Home) -> General Discussion All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]