1 ACTOR PRODUCER 1 ACTOR ALSO_A_ DIRECTOR 1 DIRECTOR PRODUCER M 2 PERFORMS_IN LEAD ROLE M b) Some actors have done a lead role in multiple movies. c) A movie can have a minimum of two lead actors. N d) Every director has been an actor in some movie. N MOVIE 1 a) There are some actors who have acted in more than ten movies. PRODUCES Assume that MOVIES is a populated database. ACTOR is used as a generic term and includes actresses. Given the constraints shown in the ER schema, respond to the following statements with True, False, or Maybe. Assign a response of Maybe to statements that, although not explicitly shown to be True, cannot be proven False based on the schema as shown. Justify each answer. N DIRECTS N

1 ACTOR PRODUCER 1 ACTOR ALSO_A_ DIRECTOR 1 DIRECTOR PRODUCER M 2 PERFORMS_IN LEAD ROLE M b) Some actors have done a lead role in multiple movies. c) A movie can have a minimum of two lead actors. N d) Every director has been an actor in some movie. N MOVIE 1 a) There are some actors who have acted in more than ten movies. PRODUCES Assume that MOVIES is a populated database. ACTOR is used as a generic term and includes actresses. Given the constraints shown in the ER schema, respond to the following statements with True, False, or Maybe. Assign a response of Maybe to statements that, although not explicitly shown to be True, cannot be proven False based on the schema as shown. Justify each answer. N DIRECTS N

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Assume a database of Employees of a company have been given as shown below:Employee: < ID, Name, ProjCode, Salary>Projects: <projID, ProjName, Budget> For each project, count the number of employees who are paid less than the average salary of that project. Determine if there is any project with a budget less than the total salary paid to its employees. If yes, find the name of the project and its budget.
"SUPERMARKET STOCK CONTROL SYSTEM" It is an application made for the employees in the Super Market to query the stock of the items more easily. Thanks to a single application, they will have information about the status of the items. According to the above information draw an E-R diagram (Specifiy all entities-relationships-attributes). Show (explain in detail) that the database is at least in 3rd NF.
DATABASE
Database homework_1SCENARIO A manufacturing company produce equipments and sell them. The company needs a system to manage stock operations. It is explained below. Equipments are manufactured by using parts. Name, manufacturing date, current status of manufacturing must be known. Some of the equipments must be tested.We want to define all parts with their name, description and type. Only the defined parts can be bought. Once parts are bought, they are located into shelves in warehouses. Each physical part uniquely identified with number. We want to know when each part is bought. Each bought part may have different warranty period. We have to use the bought part in manufacturing by taking this into account.Warehouses are located in different part of the company. Size, type of the warehouses may be different. Each parts can be bought from same or different suppliers. We want to know in which city they are located. Also for how many years we are working with each supplier. We also give…
PLZ help with the following: A nonprofit Canadian organization that provides aid to people after natural disasters needs your help to manage their data and to design a database for them using the following business rules: Individuals volunteer their time to carry out the tasks of the organization. Each volunteer may be assigned to several tasks during the time that they are doing volunteer work, and some tasks require many volunteers. It is possible for a volunteer to be in the system without having been assigned a task yet. It is possible to have tasks that no one has been assigned. When a volunteer is assigned to a task, the system should track the start time and end time of that assignment. The tasks of type “packing” result in the creation of packages. Each individual package of supplies that is produced by the organization is tracked. Each package is assigned an ID number. The date the package was created, and total weight of the package is recorded. A given package is associated…
How many of the relations in Johnny's logical database design have a composite primary key?
16 We would like to design a database to maintain information about COURSES in a Faculty. Each COURSE has a code, name number of credit hours and the department that offers it. A COURSE may have zero, one, or many prerequisite COURSES. A COURSE may be a prerequisite for zero, one, or many COURSES 2"What is the degree of the relationship type'prerequisite of a. A unary (recursive) relationship O b. A binary relationship cA ternary relationship O d. This relationship is NOT exist O
Answer the given question with a proper explanation and step-by-step solution. For this question use the file data1.csv The file contains information on various customers. Each customer has a unique customer id. The data also has information on age income and Gender of the customers. Space can be used as a delimiter for this file. Find the following: A) The total number of the rows in the file. B) The number of unique customer ids in the datafile. For this question create a set object which will only allow you to add unique customer ids. C) The program asks user to provide an id and prints information about that customer. Make sure to take care for the errors due to invalid id (i.e., id does not present in data). Print “id not found” when id is not found. Save the file as Solution1.java. You can use either File Reader or Scanner classes to read the data in the csv file. Your program should print the following after filling the blanks with the appropriate values Outcome: The total…
Structured Query Language (SQL) is a language widely used in industry to create, update and query data in relational databases. You are required to write the SQL code. Q.6.1 The below sample data in the third normal form was provided by a database designer. Answer the below questions using this data. Table: LawFirm Primary key: LawFirmID (auto number) All fields are mandatory LawFirmID Name Yearlncorporated 1 Ze Boss Attorneys 2011 2 Lawyers for the Win 2018 3 Court Rulez 2019 Table: Lawyer Primary key: LawyerlD Foreign key: LawFirmID LawyerID LawFirmlD Surname Name Age Bianchi Anna 45 7 2 Modise Dikeledi 57 8 2 Ferreira Piet 34 3 Nkosi Jabulani 28 Q.6.1.1 Write a SQL statement to create the table Lawyer. Hint: The sample data should give you an indication of the data types you should use. Q.6.1.2 Write a SQL statement that will calculate the average age of all the lawyers that are at least 40 years old. Q.6.1.3 Write a SQL statement to insert the below row into table LawFirm.
Entity relationship diagram.
Suppose you have the following information: Name ID GPA sami 102 90 sara 550 66 A. Define a CLIPS template "student" to represent the elements name, id, gpa. B. Add the two records to the database. Your answer
JoziCleaners is local cleaning service that is looking to upgrade their current operations by making use of a database to keep track of the teams, houses, clients and billings of each client per/week. Each house is cleaned by one or more teams. A team goes out to a particular house on a certain day of the week. Each cleaning team has a team leader. Every cleaner eams R150 per day, except the team leader who earns a unique amount. The report that the JoziCleaners' manager produced in Microsoft Excel is illustrated as a spreadsheet in Figure 1 below. Day Client Client Name Team Members Team Leader Leader Total Code ID Wage Monday Aeliana Gebahard T3 6. Jaymes Merrickson R 350 R 850 C10 Alfher Dareia T1 Geoffrey Glover R 250 R 750 C8 Felina Diodotus T2 Elmer Victorson R 300 R 700 Brutus Sigihild Sigibert Quirinus Brutus Sigihild C9 T4 Norris Mamadou R 400 R1 000 Tuesday CS T3 Jaymes Merrickson R 350 R 850 C9 T2 5 Elmer Victorson R 300 R 700 Alfher Dareia Duncan Gardyner Geoffrey Glover…