The textual description nodan, describes a video rental company that wants to create one database of its activities. Drawing an ER chart sim meets the company's requirements. The company has stores throughout New York. What is stored about each pile is the telephone number and address which consists of street, city, house number and postcode. Each store is also assigned a number that is unique throughout the company. There is always a manager for each store. An employee thus has a specific role. If employees, they also store names and salary. Each employee has an employment number that is unique Each store has a video store. Information about the film / video that is of interest, video number, title, status and the names of the most important actors, and the director. The rental price for a film varies depending on which store you rent the film from. Of course, the role of a preson participant in one film may vary in another film Shelf numbers and number of copies of each film are also important. A movie belongs to a main category such as Action, Adult, Children, Drama, Horror or Sci-Fi or: The shelf number can be the same or different in the different store The status indicates whether a particular copy of a film is available for rent. Before you can rent a movie, you must register as a member of a store. The information stored about a member is the name, address and date when the membership began. Each member receives a membership number that is unique among all stores. A member can rent up to a maximum of ten movies at a time. This is pointed out at the counter if there are more than ten. What is stored about the rental is the rental number, the date when the film was rented out and the date of return
The textual description nodan, describes a video rental company that wants to create one
Each store has a video store. Information about the film / video that is of interest, video number, title, status and the names of the most important actors, and the director. The rental price for a film varies depending on which store you rent the film from.
Of course, the role of a preson participant in one film may vary in another film
Shelf numbers and number of copies of each film are also important. A movie belongs to a main category such as Action, Adult, Children, Drama, Horror or Sci-Fi or:
The shelf number can be the same or different in the different store
The status indicates whether a particular copy of a film is available for rent. Before you can rent a movie, you must register as a member of a store. The information stored about a member is the name, address and date when the membership began. Each member receives a membership number that is unique among all stores. A member can rent up to a maximum of ten movies at a time. This is pointed out at the counter if there are more than ten. What is stored about the rental is the rental number, the date when the film was rented out and the date of return
Answer:
This type of question comes under the databases management system. And ER -diagram shows how to connect the table and perform the task as given. we have drawn ER-diagram in below.
Step by step
Solved in 3 steps with 1 images
