0
The question is too vague for a sound answer so I will try to shotgun it.
The most basic relationship is a parent-child relationship. The parent table might be "Department," the child table, "Employee." The child can not exist without a parent. Bob and Jill may be children in the Shoe department. Mary is the child in the Canoe department. The Glue department has no children; Harry was the only employee but they had to let him go over a sticky situation.
As you can see, a parent might have many children, one child, or no children.
Quantity relationships are the next type of relationship the question may be asking about. Quantity relationships do not have to be between parent and child tables.
As you can see, Departments can have many children. That is known as a one-to-many relationship. One department, many employees.
A many-to-one relationship might be a customer with multiple addresses, say mailing, billing, and shipping.
Employee and Employee Number tables might represent one-to-one relationships. Rather than use Mary Boudreaux every place you need to identify her, you assign her an employee number. Mary is in the Canoe department. Her number is C75. C for Canoe, 75 for the 75th employee of the company.
Finally, there is the many-to-many relationship. All the employees work for commission. There is a sales table with many entries. Each entry is related to one of the many employees in the employee table.
There are symbols for each X-to-Y relationship.
The question might also refer to "Key" relationships. Primary Keys (PK) and Foreign Keys (FK) are used mostly between tables. A full explanation of the PK/FK relationship usually results in glazed eyes and confusion without visuals.
What else can I help you with?
Can a relational database support one to one?
Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.Yes. A one to one relationship is one of the types of relationships a relational database can have.
A schematic of the entire database that describes the relationships in a database is called?
entity-relationship diagram.
What is a logical database?
A logical database is the structure of data. It is the different pieces of information and the relationships between them.
Which database tool is required for establishing relationships?
tables
Difference between database and relational database explain with example?
Database = Generic name for a system to store data Relational Database = A specific type of database that utilizes relationships between data to not only store the data but further its efficiency in its manipulation.
How do you do many to many relationships in database?
check out microsoft.com for step by step guide on how to do this
What is Database state?
The database state refers to the collection of data stored in the database at a specific point in time. It represents the current values of all data elements, tables, and relationships within the database. Changes to the database, such as insertions, updates, or deletions, can alter its state.
What is high-level description of a conceptual data?
A conceptual data model is a high-level overview of the structure and relationships within a database. It focuses on the entities, attributes, and relationships between entities without going into the specifics of how the data will be implemented in a physical database. It serves as a blueprint for designing a database system.
Database properties are also known as?
Database properties are also known as database attributes or characteristics. These properties describe the features and characteristics of the database, such as data types, constraints, relationships, and indexing among others. They are essential for defining the structure and behavior of a database system.
Who decides on the proper placement of fields and defines the relationships among data?
Database architects and data analysts typically decide on the proper placement of fields and define the relationships among data in a database. They consider the database requirements, system architecture, and business needs to ensure data is organized efficiently and accurately. These decisions are crucial for the overall performance and usability of the database system.
What are the relationships that the relational database is named for?
In database theory, a relation is defined as a set of tuples that have the same attributes. A tuple is also known as a row or record.
What are the five steps to planning a database?
The basic steps in planning a database are as follows:Collect informationIdentify key objects or entitiesModel key objectsIdentify the types of information for each object or entityIdentify the relationships between objects or entities
