Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us
Database Knowledge Base / MS SQL Server /

How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Print
Email to friend
Add comment
Views: 850
Votes: 4
Comments: 45

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.
One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships.
Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table .

It will be a good idea to read up a database designing fundamentals text book.
Showing: 1-20 of 45    »»
Comments

31 Dec, 1969   |   Guest
database schema
31 Dec, 1969   |   Guest
microsoft sql server 2008
31 Dec, 1969   |   Guest
network dbms
31 Dec, 1969   |   Guest
zipcode database
31 Dec, 1969   |   Guest
dbms model
31 Dec, 1969   |   Guest
microsoft sql server
31 Dec, 1969   |   Guest
access database design
31 Dec, 1969   |   Guest
sql server 2008 versions
31 Dec, 1969   |   Guest
sql not equal
31 Dec, 1969   |   Guest
sql 2008 r2
31 Dec, 1969   |   Guest
sql server versions
31 Dec, 1969   |   Guest
what is database
31 Dec, 1969   |   Guest
t-sql substring
31 Dec, 1969   |   Guest
database administrator
31 Dec, 1969   |   Guest
database software programs
31 Dec, 1969   |   Guest
microsoft sql server download
31 Dec, 1969   |   Guest
database diagram
31 Dec, 1969   |   Guest
learn sql server
31 Dec, 1969   |   Guest
microsoft access database
31 Dec, 1969   |   Guest
list of dbms
Showing: 1-20 of 45    »»


Add comment

Others in this Category
document How to change the owner of all tables in a database?
document how to build connection string for MS SQL Server?
document How we can back up all databases in SQL Server
document If the TempDB Database is deleted from MS-SQL Server what will happen..?
document How to insert a not null column in an existing table with records..?
document If a table is deleted, what will happen for the Stored procedures and Views, which that table reffered..?
document Is there an easy way to loop through every stored procedure in a database and create a file containing all of the SP code?
document What is denormalization and when would you go for it?
document What's the difference between a primary key and a unique key?
document What are user defined datatypes and when you should go for them?
document What is bit datatype and what's the information that can be stored inside a bit column?
document How we can determine which version of SQL Server 2005 is running?
document How to determine which version of SQL Server 2000 is running
document What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
document Can you have a nested transaction?
document What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
document You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
document Is length of sql query limited in MS_SQL Server ?
document Where we can find Free MS SQL Server System Table chart or map ?
document I'm using SQL Server 2005. Do I need to get Enterprise Manager to administer the app through a hosted server? What do I need if not EM?
document How do I restict clients by IP Address?
document How do I perform encryption with SQL Server?
document What is SQLPing and how does it work?
document How can I hide my SQL Server 2000 installations from SQLPing?
document How can I keep the 'sa' account from reading my confidential data?
document Why is SQL Server security important?
document What different network protocol libraries should I use?
document What different network protocol libraries should I use?
document What are the various security modes for SQL Server and how do they work?
document What are some things I can do to secure my SQL Server?
document What could happen if the 'sa' account is compromised?
document Does MySQL 5.0 provide any new features/capabilities for MySQL Cluster?
document Can you use MySQL GUI Tools to build Stored Procedures and Views?
document How does PostgreSQL compare to other DBMSs?
document How we can perform MINUS (Oracle) Or EXCEPT (Maxdb) in MS Access?
document What is normalization?
document What is a Stored Procedure?
document Can you give an example of Stored Procedure?
document What is a trigger?
document What is a view?
document What is an Index?
document What are the types of indexes available with SQL Server?
document What is the basic difference between clustered and a non-clustered index?
document What are cursors?
document When do we use the UPDATE_STATISTICS command?
document Which TCP/IP port does SQL Server run on?
document From where can you change the default port?
document Can you tell me the difference between DELETE & TRUNCATE commands?
document Can we use Truncate command on a table which is referenced by FOREIGN KEY?
document What is the use of DBCC commands?
document Can you give me some DBCC command options?
document What command do we use to rename a db?
document Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
document What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
document What do you mean by COLLATION?
document What is a Join in SQL Server?
document Can you explain the types of Joins that we can have with Sql Server?
document When do you use SQL Profiler?
document What is a Linked Server?
document Can you link only other SQL Servers or any database servers such as Oracle?
document Which stored procedure will you be running to add a linked server?
document What are the OS services that the SQL Server installation adds?
document Can you explain the role of each service?
document How do you troubleshoot SQL Server if its running very slow?
document Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
document What are the authentication modes in SQL Server? -
document Where do you think the users names and passwords will be stored in sql server?
document What is log shipping? Can we do logshipping with SQL Server 7.0
document Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
document Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
document What is BCP? When do we use it?
document What should we do to copy the tables, schema and views from one SQL Server to another?
document What are the different types of joins and what does each do?
document What is a sub-query? When would you use one?
document Hacking SQL Server!!!
document When do you use SQL Profiler?
document What is a Linked Server?
document Can you link only other SQL Servers or any database servers such as Oracle?
document Which stored procedure will you be running to add a linked server?
document What are the OS services that the SQL Server installation adds?
document Can you explain the role of each service?
document How do you troubleshoot SQL Server if its running very slow?
document What are the authentication modes in SQL Server?
document Where do you think the users names and passwords will be stored in sql server?
document What is log shipping?
document What is BCP?
document What is Data Mapping
document What is an Ad Hoc Query?
document How to identify your SQL Server version and edition?
document what is the method to change location of tempdb?
document How to know which index a table is using?
document What is Data page?
document Define Disaster recovery planning.
document define term Minimally logged operations (bulk load operations)
document What is Filegroup?
document What is Log sequence number (LSN)?
document what is an Extent?
document how we can change ownership in SQL Server?
document Oracle Database 11g Administrator
document Which transport protocol cannot be used for database mirroring?
document which function displas the state of information of the transaction in the session?
document which pages in the SQL Server Management Studio allow you to configure different properties of backup?
document Which function displays the state of information of the transaction in the session?
document Which argument should be specified in the bcp command to perform an export?
document Which server role allows you to execute requests on an endpoint in the database?
document Which clause specifies the assembly name and class name while creating a user-defined type by using the CREATE TYPE statement.
document on which two editions of Windows 2003 can you install the SQL Server 2005 Enterprise edition?
document Which stored procedure is used to change the password for the distributor?
document A partititon scheme can be based on how many partition functions?
document Which statement can be used to import data from a data file into a temporary table?
document What should be the value in the STATUS clause in the CREATE QUEUE statement if you want that the queue should receive messages?
document You are assigned the role of a Certification authority (CA) in your company. As a CA, you are required to create certificates as and when requested by users in your company. On Adam's request, you issue the following Transact-SQL Statement to create a certificate (line numbers are for referene only.):
document Where we can find Maximum Capacity Specifications for SQL Server 2008?
document what is ONLINE INDEX?
document Which is the best free tool to read large sql files
document Australian Post Code Database with Coordinates
document Introduction to SQL - SQL LESSON 1
document SQL Server Backup Compression and Security


RSS
Powered by KBPublisher (Knowledge base software)