How we can implement relationships when designing tables, Database Management System

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







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
Related Questions
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 of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra

write an SQL statement to create the database in MYSQL server

Explain the cartesian product in Database Management System

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

prototype of a distributed information system for a national car part retail outlet chain.

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? Load -balance multiple small accesses, so that the  throughput of such accesses enhances. Parallelize large accesses so that the res

what is object-identity

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