Ask questions which are clear, concise and easy to understand.
Ask QuestionPosted by Akash Yadav 4 years, 8 months ago
- 1 answers
Posted by Ranjeet Singh 4 years, 8 months ago
- 1 answers
Prabhat Pathak 4 years, 8 months ago
Posted by Choudhary Tushi 4 years, 8 months ago
- 1 answers
Sia ? 4 years, 3 months ago
It is used when SQL query is to be executed only once. It is used when SQL query is to be executed multiple times. You can not pass parameters at runtime. You can pass parameters at runtime.
Posted by Sachin Gupta 4 years, 8 months ago
- 0 answers
Posted by Mungi Rajesh 4 years, 8 months ago
- 2 answers
Sagar Bhai 4 years, 8 months ago
Sumaila Ali Choudhary??? 4 years, 8 months ago
Posted by ꧁ɴᴇʜᴀʟ ᴍᴜʟᴇᴋᴀʀ꧂ 4 years, 8 months ago
- 2 answers
Posted by Ishita Yadav 4 years, 8 months ago
- 2 answers
Khushi K. 4 years, 8 months ago
Posted by Mukul Sahal 4 years, 8 months ago
- 1 answers
Posted by Ashish Karki 4 years, 8 months ago
- 1 answers
Sia ? 4 years, 3 months ago
Styles keep your formatting consistent within a document. Themes keep your look and feel consistent across multiple documents. Templates allow you to re-use text, and keep your look and feel consistent across multiple documents
Posted by Tanya M 4 years, 8 months ago
- 1 answers
Kavit Kankane 4 years, 8 months ago
Posted by Himanshu Pathak 4 years, 8 months ago
- 3 answers
Posted by Himanshu Pathak 4 years, 8 months ago
- 1 answers
Posted by Yanshu Parjapati 4 years, 8 months ago
- 1 answers
Posted by Yanshu Parjapati 4 years, 3 months ago
- 1 answers
Sia ? 4 years, 3 months ago
One-to-One Relationship
Such a relationship exists when each record of one table is related to only one record of the other table.
<i>For example,</i> If there are two entities ‘Person’ (Id, Name, Age, Address)and ‘Passport’(Passport_id, Passport_no). So, each person can have only one passport and each passport belongs to only one person.
One-to-Many or Many-to-One Relationship
Such a relationship exists when each record of one table can be related to one or more than one record of the other table. This relationship is the most common relationship found. A one-to-many relationship can also be said as a many-to-one relationship depending upon the way we view it.
<i>For example,</i> If there are two entity type ‘Customer’ and ‘Account’ then each ‘Customer’ can have more than one ‘Account’ but each ‘Account’ is held by only one ‘Customer’. In this example, we can say that each Customer is associated with many Account. So, it is a one-to-many relationship. But, if we see it the other way i.e many Account is associated with one Customer then we can say that it is a many-to-one relationship.
Many-to-Many Relationship
Such a relationship exists when each record of the first table can be related to one or more than one record of the second table and a single record of the second table can be related to one or more than one record of the first table. A many-to-many relationship can be seen as a two one-to-many relationship which is linked by a 'linking table' or 'associate table'. The linking table links two tables by having fields which are the primary key of the other two tables. We can understand this with the following example.
Example: If there are two entity type ‘Customer’ and ‘Product’ then each customer can buy more than one product and a product can be bought by many different customers.
Posted by Ñîkhïl Thãkûr 4 years, 8 months ago
- 4 answers
Sagar Bhai 4 years, 8 months ago
꧁ɴᴇʜᴀʟ ᴍᴜʟᴇᴋᴀʀ꧂ 4 years, 8 months ago
Ashish Karki 4 years, 8 months ago
Posted by Soumya Bhaskar 4 years, 8 months ago
- 3 answers
Posted by Kishlay Kanaujia 4 years, 8 months ago
- 1 answers
Khushi K. 4 years, 8 months ago
Posted by Kishlay Kanaujia 4 years, 8 months ago
- 1 answers
Sia ? 4 years, 4 months ago
Posted by Tanya M 4 years, 8 months ago
- 1 answers
Abhinav Vats 4 years, 8 months ago
Posted by Heard Laos Laos 4 years, 4 months ago
- 1 answers
Sia ? 4 years, 4 months ago
Setting up a computer network is a fast and reliable way of sharing information and resources within a business. It can help you make the most of your IT systems and equipment.
Main benefits of networks include:
- File sharing - you can easily share data between different users, or access it remotely if you keep it on other connected devices.
- Resource sharing - using network-connected peripheral devices like printers, scanners and copiers, or sharing software between multiple users, saves money.
- Sharing a single internet connection - it is cost-efficient and can help protect your systems if you properly secure the network.
- Increasing storage capacity - you can access files and multimedia, such as images and music, which you store remotely on other machines or network-attached storage devices.
Posted by Aditya Singh 4 years, 8 months ago
- 1 answers
Sia ? 4 years, 4 months ago
the study or use of electronic equipment, especially computers, for collecting, storing and sending out information
Posted by Yashika Punani 4 years, 8 months ago
- 1 answers
Posted by Zargar Rehmat 4 years, 8 months ago
- 2 answers
Posted by Yashika Punani 4 years, 8 months ago
- 0 answers
Posted by Mohammad Yusuf 4 years, 8 months ago
- 1 answers
Posted by Yashika Punani 4 years, 8 months ago
- 4 answers
Manu Khela 4 years, 8 months ago
Posted by Manu Khela 4 years, 8 months ago
- 2 answers
Manu Khela 4 years, 8 months ago
S Rujenderan 4 years, 8 months ago
Posted by Amisha Verma 4 years, 8 months ago
- 4 answers
Posted by Deepanshu Chahar 4 years, 8 months ago
- 2 answers
Sunita Kumari 4 years, 8 months ago
Posted by Pandey Sharma 4 years, 8 months ago
- 2 answers
Secret ??? 4 years, 8 months ago
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
Anmol Kumar 4 years, 7 months ago
1Thank You