0
What do you understand by table relationship in database design?
Wiki User
∙ 10y ago
A table relationship is where a field in one table is matched with the same field in another table. For example you may have a table that lists your suppliers so 'Supplier Name' is one of the fields, you may then have another table that lists orders made so "Supplier Name" will be a field in that table also. Therefore you can link the two tables together so that all specific supplier address details are linked to subsequent orders with that supplier. For a relationship to work both linking fields must be of the same data type, therefore you can't link a field that is stated as text with one that is stated as a date. Relationships are commonly known as one-to-one and one-to-many, in a one-to-one relationship the field's contents can only appear once on each side so using the example above one supplier in the suppliers table can only have one order record in the orders table. "One to many" therefore means that one supplier can appear on many orders. Hope this helps.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What is database composition in database?
Composition is a term that comes from object oriented design. It is a relationship in which a number of parts comprise a whole, and these parts can only be part of one whole. There is no direct translation of this concept to database design, but there are some situations in the database world that represent the concept of composition. Field to record A record is composed of fields and these fields are part of only one record. When the record is removed, the fields are also removed. So, each field has a composition relation with its record. This means that when you store a collection (a comma separated list of names for example) in a database field, this is in fact a composition relationship. Record to record from other table If you want to create a composition relation between records from a table A and records from another table B, where A is the whole and B the parts you must ensure that 1. There is a one-to-many relationship between table A and B. This is done by adding a foreign key to table B. 2. That all part records in B are deleted when the whole record in table A is deleted. This can be done by setting ON DELETE CACADE on the foreign key relationship. 3. That the records in table B don't become part of another composition relationship. But this restriction cannot be enforced by the database to my knowledge.
What is meant database administration?
Database management system is a software system (set of programs) that is used for the management of databases. Now to understand Database management system it is necessary to know about databases. Database is a data structure used to organize related data. In databases data is stored in such a way that it can be easily accessed and changed easily. Normally a database is a collection of tables. A table itself can also be called as database and Table is a collection of columns and rows. Database administration is a method of tending to or managing the affairs of electronic data and the person who perform these activities is called Database Administrator. A database administrator (DBA) is responsible for the design, implementation, maintenance and repair of an organization's database.
Who designs a database?
A database or systems designer will do it. They could also have other roles like being an analyst or a database administrator. Whoever is designing a database may work with people in some of those other jobs, particularly when it is a very large system. If it is a small database, then it is easy to design and somebody with a bit of knowledge of databases can design and create one.
What if you delete a database table?
click undo to restore the table
Is the process of creating table designs by assigning specific fields or attributes to each table in a database?
Normalization is the process of creating table designs by assigning specific fields or attributes to each table in a database.
Which database refers to the arrangement of data into table and fields?
design
Relationship between a database and a table?
A table is contained within the database and consists of columns and rows. A table is meant to store data and, in relational databases, are related to other tables within the same database.
How functional dependency is related to database table design?
The functional dependency is related to the database table design through the foreign and primary keys. The foreign and primary keys are functionally dependent on each other.
What should be the erd for website design?
ERD is an Entity Relationship Diagram which is a graphical representation of database entities (tables, table columns, table definitions, attributes) and inter-relationships between these entities (how the tables are connected).
What does Design view mean in relation to a database?
its used to creat and modify the structure of the table
What is the difference between design view from datasheet view?
A data sheet view shows the data in the database. It allows you to enter and edit the data, but you cannot change the format of the database. Design view allows you to create or change the table, form or any other database object.
What is database composition in database?
Composition is a term that comes from object oriented design. It is a relationship in which a number of parts comprise a whole, and these parts can only be part of one whole. There is no direct translation of this concept to database design, but there are some situations in the database world that represent the concept of composition. Field to record A record is composed of fields and these fields are part of only one record. When the record is removed, the fields are also removed. So, each field has a composition relation with its record. This means that when you store a collection (a comma separated list of names for example) in a database field, this is in fact a composition relationship. Record to record from other table If you want to create a composition relation between records from a table A and records from another table B, where A is the whole and B the parts you must ensure that 1. There is a one-to-many relationship between table A and B. This is done by adding a foreign key to table B. 2. That all part records in B are deleted when the whole record in table A is deleted. This can be done by setting ON DELETE CACADE on the foreign key relationship. 3. That the records in table B don't become part of another composition relationship. But this restriction cannot be enforced by the database to my knowledge.
What is the purpose of having a table in a database?
because it make easy the work and to understand data
Which view allows more control over table structures in context of database?
design view
What is a relation as used in database design?
When you create a relation (Relationship) within an DBMS you are establishing a relationship of a field in one table to a field another table. Example. We Have a table Customers CustomerID FirstName LastName StatusID The sample fields above are for table Customers Now the StatusID is an INT field and we need to define a relationship between this field and the StatusID column in the Status table StatusID StatusDescription isActive Above are examples of the Status table. To complete our example here we will create a relationship that looks as follows: Customers->StatusID ---> Status->StatusID
When a relationship exists between two tables in a database for Microsoft acess what name is given to the matching field in the related table?
The field in a related table that matches a field in another table is called a foreign key. This foreign key establishes the relationship between the two tables in a database.
What are the Different types of relationship in a database?
There are mainly three types of relationships in database . These are One to One , One to Many , Many to Many. One to one relationship can be seen as relationship between husband and wife , one to many relationship can be seen as a relationship between a college and students.
