You want to implement following relationships when designing tables. How would you do it?

a.) One-to-one

b.) One-to-many

c.) Many-to-many

a.) One-to-One relationship - can be implemented as a single table and seldom as two tables with foreign and primary key relationships.

b.) One-to-Many relationships - by splitting data into 2 tables with foreign key and primary key relationships.

c.) Many-to-Many - by using a junction table with keys from both tables forming composite primary key of junction table.

 

 

Posted Date: 9/7/2013 3:45:44 AM | Location : United States

Ask an Expert

Related Discussions:- How we can implement relationships when designing tables, Assignment Help, Ask Question on How we can implement relationships when designing tables, Get Answer, Expert's Help, How we can implement relationships when designing tables Discussions

Write discussion on How we can implement relationships when designing tables
Your posts are moderated

Write your message here..

Related Questions

What are the situations while dbms should not be used, What are the situati... What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N

Benefits and drawbacks of sequential file organisation, Benefits of Sequent... Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra

MYSQL, write an SQL statement to create the database in MYSQL server write an SQL statement to create the database in MYSQL server

Cartisian product, Explain the cartesian product in Database Management Sys... Explain the cartesian product in Database Management System

Explain domain calculus, Explain Domain calculus Domain calculus is one... Explain Domain calculus Domain calculus is one of the types of the relational calculus. The formal specification of the domain calculus was planned after the development of the

Design and building a distributed information system, prototype of a distri... prototype of a distributed information system for a national car part retail outlet chain.

Basic set operation, These are the binary operations; i.e., each is applied... These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R

What are the two main goals of parallelism, What are the two main goals of ... What are the two main goals of parallelism? Load -balance multiple small accesses, so that the  throughput of such accesses enhances. Parallelize large accesses so that the res

Computer, what is object-identity what is object-identity

What way a particular application views data from database, What is the way... What is the way a particular application views the data from the database that the application uses? Sub schema is the way a particular application views the data from the data