Answer to Question #249036 in English for Sne

Question #249036

•Find the company of your choice and

•Create TABLE for each entity of your company (Logical View) using MsAccess

•Put all relationships , note M:M relationships are not allowed.

•Check your table integrity by performing these logical operators/ sql statements:

•Project, Select *, Select 2 or more columns or any query of your choice.

•Show/paste the results of your query


1
Expert's answer
2021-10-12T08:45:03-0400

1.Independent entities, also referred to as kernels, are the backbone of the database. They are what other tables are based on. Kernels have the following characteristics:


They are the building blocks of a database.

The primary key may be simple or composite.

The primary key is not a foreign key.

They do not depend on another entity for their existence.

If we refer back to our COMPANY database, examples of an independent entity include the Customer table, Employee table or Product table.


Dependent entities

Dependent entities, also referred to as derived entities, depend on other tables for their meaning. These entities have the following characteristics:


2.Dependent entities are used to connect two kernels together.

They are said to be existence dependent on two or more tables.

Many to many relationships become associative tables with at least two foreign keys.



Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS