change their state once they are instantiated. How will you implement t
Q: Query Processing Consider these proposed equivalences: ΠA(R − S) = ΠA(R) − ΠA(S) σB<4(max(B)(R))…
A:
Q: Is the following statement regarding triviality of functional dependencies true or false? α → β is…
A: The functional dependency, α → β is a trivial functional dependency if β is the subset of α. Thus,…
Q: Computer Science Draw the CONTEXT Digram for the given case study below: “UAETourism & Travel Agency…
A:
Q: Let X and Y be sets of attributes. Show that if X ⊂ Y , then X+ ⊂ Y + , where the closures are taken…
A: for the required prove - we uses contrapositive method: It means we are proving that if X+ is not…
Q: Which of the following best describes the proposition: likes(bob,mary)?
A: Prolog expressions are comprised of the following truth-functional symbols, which have the same…
Q: Based on the sources and requirements listed above, create a dimensional model that will be used for…
A: Auto dealership Pineview Ford is organized as follows: • Pineview Ford keeps track of Vehicle…
Q: Suppose we have market basket data consisting of 100 transactions and 20 items. Compute the total…
A: Solution (a) Number of transactions =100 Number of item =20 Total number of association rule=…
Q: Consider the following Schema of Shaheen Airline Pakistan; they want you to generate reports by…
A: ER diagram helps to elucidate the flow and structure of the info style and conjointly the logical…
Q: Consider the following database schema for student game, where each team is led by a student of the…
A: Primary key means only one unique value and null not allowed. No duplicate values stored. Foreign…
Q: Let c1, c2, and c3 be the confidence values of the rules {p} → {q}, {p} → {q, r}, and {p, r}→{q},…
A: The table given is as follows Customer ID Transaction ID Items Bought1…
Q: Draw the CONTEXT Digram for the given case study below: "UAETourism & Travel Agency LLC" from this…
A: Answer: I have given answered in the handwritten format in brief explanation
Q: In a database describing 100 examples of printer failures, 75 are hardware failures and 25 are…
A: Total printer failures = 100 No. of Hardware failures are 75 No. of driver failures = 25 No. of…
Q: When building a classification model, which of the following is a good measure of the model’s…
A: Explanation: when you are building a classification model, Testing Set ASE is considered to be a…
Q: The following scenario is used for Case Projects 2-1 through 2-6: Darts is a sporting goods company…
A: SUMMARY: - Hence, we discussed all the points.
Q: Consider the following data Classification Model where YACT is your actual observation and YPRED is…
A:
Q: In logistic regression in R, the glm command must include a parameter setting the family equal to…
A: Defined the given statements
Q: E8.4 Consider the following scenario involving Pineview Ford, an auto dealership. Auto dealership…
A: Analysis can be done using the below dimensional data model for Pineview Ford.
Q: A student has a name, which consists of a given name and a family name, and a student IID. Each…
A: Consider the following scenario A student has a name, which consists of a given name and a…
Q: Assuming a database has 4 transactions in a supermarket as shown below. ID Date Product ID001 Oct 8,…
A:
Q: Use the following ERD (showing only entities, not their attributes) to answer the following: a. How…
A: Hey there, I am writing the required solution of the above stated question.Please do find the…
Q: We have the following data: X - the independent variable Y - the dependent variable and we want to…
A: numpy.polyfit(x, y, deg, rcond=None, full=False, w=None, cov=False) Least squares polynomial fit.…
Q: Consider the following schedule of transactions W1(A) W2(A) W1(A) W2(A) W1(A) Which of the following…
A: The given transactions W_1(A)W_2(A)W_1(A)W_2(A)W_1(A)W1(A)W2(A)W1(A)W2(A)W1(A) The following…
Q: We have the following data: X - the independent variable Y-the dependent variable and we want to…
A: option b is correct model=numpy.polyfit(X,Y,7) mdl=numpy.poly1d(model)
Q: Consider the following relational schema: violations(VID BID SNu SNa Zip InD Bor BoI NVI NVD).…
A: 1. ViolationID is the key that uniquely identifies each record in the non-normalized form hence it…
Q: Let's imagine there is only place for one additional student in the course, but two people wish to…
A: Both students can't take the last seat that's open in a database system because in the database each…
Q: Exercise 1 Part 2 Consider the following information about the university database, D Professars…
A: The ER Diagram that follows is based on the information provided in the university question.
Q: Given that we will have a database for students and lecturers to record the courses in which they…
A: ERD : shows the relationships of entity sets stored in a database.
Q: Give an example of how a comparison of sales and inventory data might show a scenario in which cash…
A: Introduction: Every shop needs to have reports and analytics since they let you know precisely…
Q: Consider the following relational schema: violations(VID BID SNu SNa Zip InD Bor BoI NVI NVD).…
A: Following is the Answer: PFA Let FD=Functional Dependency Let all FD be from FD1 to FD6 SK= Super…
Q: Consider the following scenario: two relationsr and s have histograms on attributes r.A and s.A,…
A: On the attributes r.A and s.A, two relations r and s have histograms, but their ranges are…
Q: There are two alternative methods of representing an employee’s optional (single) phone number. The…
A: An element type ought to have a key characteristic which exceptionally recognizes every element in…
Q: The scenario is for a small life insurance agency and their need to keep track of clients, agents,…
A: The complete table is given below:-
Q: In a restaurant, customers usually may buy any number of meals at any time, Several customers can…
A: The ask is as follows: Note: Due to firm policy only one question is being answered.
Q: Suppose that we have a sample data for four people and the data has four attributes. The data is…
A: Nominal Attributes are the non numerical attributes. The proximity measure of nominal attributes is…
Q: Consider the case of a shop that sells CDs in cash. The CDs are of three types: Movie CDs, Software…
A: Given CDs are of three types: Movie CDs, Software CDs and Music CDs Movie CD: Movie Title, Year of…
Q: Assuming functional dependency A-->B holds, which of the following functional dependencies may not…
A: Here, we are going to check which one is not necessarily true for attribute X. Using Armstrong's…
Q: For items A and B the support counts are as follows. Support count of A: 50, support count of B: 40,…
A: Given Support count of A= 50 Support count of B = 40 Support count of A and B = 20 Total no.of…
Q: Passenger (pid, pbithday, pcity) Station (sid, sname, sxcoord, sycoord)
A: 1. Joining tables in the order of Passenger, CheckIn, and Station would be the faster option since…
Q: Consider the following Scenario the Modeling of which you have completed in Assignment1: The…
A: Step 1:-System Work and actors specific action
Q: QUESTION 5 Consider the following database schema for a library. Book (BookID:int,…
A: We have given a dbms tables for Book, Borrowing-Record, Customer. One data member of Book table…
Q: Consider the following set of items {A, B, D, F, H}. Create a set of transactions such that the…
A: Here we write possible transactions set to get the same values:…
Q: The scenariO is for a small life insurance agency and their need to keep track of clients, agents,…
A: GIVEN:
Q: relationship between entities and attributes.
A: EMPLOYEE(EMP_NUM, EMP_LNAME, EMP_INITIAL, EMP-DOB) Here, primary key = EMP_NUM DEPENDENT(EMP_NUM,…
Q: Consider a fast food restaurant in which employees take orders for food from customers. The data…
A: ER diagram has been designed to satisfy the given requirements and its business rules related to a…
Q: How many valid keys are in the following model? A Fully trusted entity Partially trusted entity B C…
A: Given:
Q: Given two relations R and S, defined on the set A = {1, 2, 3,., 40} where R = { (X,y) | x is…
A:
Q: Which of the following is true about the number of parameters in parametric and non- parametric…
A: The right answer is option(3) Explanation:- The parametric model uses the fixed numbers of…
Consider the case of a shop that sells CDs in cash. The CDs are of three types: Movie CDs, Software CDs and Music CDs. For each of the following CD types, the required attributes are:Movie CD: Movie Title, Year of Release, Lead Actor Name, CD price and CD quantitySoftware CD: Software Name, Edition, Year of Release, CD price and CD quantityMusic CD: Album Title, Year of Release, Number of Songs, Format, CD price and CD quantity
All objects of the classes cannot change their state once they are instantiated. How will you implement this?
Step by step
Solved in 2 steps
- Consider the case of a shop that sells CDs in cash. The CDs are of three types: Movie CDs, Software CDs and Music CDs. For each of the following CD types, the required attributes are:Movie CD: Movie Title, Year of Release, Lead Actor Name, CD price and CD quantitySoftware CD: Software Name, Edition, Year of Release, CD price and CD quantityMusic CD: Album Title, Year of Release, Number of Songs, Format, CD price and CD quantity. The variable of CDType can hold a fixed set of values that are Movie, Software and Music, what data type you recommend is suitable to store this information to ensure typesafety firmly. Declare and initialize the CDType variable.The database keeps track of three types of persons: employees, alumni, and students. A person can belong to one, two, or all three of these types. Each person has a name, SSN, sex, address, and birth date.Every employee has a salary, and there are three types of employees: faculty, staff, and student assistants. Each employee belongs to exactly one of these types. For eachalumnus, a record of the degree or degrees that he or she earned at the university is kept, including the name of the degree, the year granted, and the major department. Each student has a major department.Each faculty has a rank, whereas each staff member has a staff position. Studentassistants are classified further as either research assistants or teaching assistants, andthe percent of time that they work is recorded in the database. Research assistants have their research project stored, whereas teaching assistants have the current course they work on.Students are further classified as either graduate or…Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.
- The database keeps track of three types of persons: employees, alumni, and students. A person can belong to one, two, or all three of these types. Each person has a name, SSN, sex, address, and birth date.Every employee has a salary, and there are three types of employees: faculty, staff, and student assistants. Each employee belongs to exactly one of these types. For eachalumnus, a record of the degree or degrees that he or she earned at the university is kept, including the name of the degree, the year granted, and the major department. Each student has a major department.Each faculty has a rank, whereas each staff member has a staff position. Studentassistants are classified further as either research assistants or teaching assistants, andthe percent of time that they work is recorded in the database. Research assistants have their research project stored, whereas teaching assistants have the current course they work on.Students are further classified as either graduate or…The database keeps track of three types of persons: employees, alumni, and students. A person can belong to one, two, or all three of these types. Each person has a name, SSN, sex, address, and birth date.Every employee has a salary, and there are three types of employees: faculty, staff, and student assistants. Each employee belongs to exactly one of these types. For eachalumnus, a record of the degree or degrees that he or she earned at the university is kept, including the name of the degree, the year granted, and the major department. Each student has a major department.Each faculty has a rank, whereas each staff member has a staff position. Studentassistants are classified further as either research assistants or teaching assistants, andthe percent of time that they work is recorded in the database. Research assistants have their research project stored, whereas teaching assistants have the current course they work on.Students are further classified as either graduate or…A course instructor will assign grades from (A, B+, B, C+, C, D+, D, EJ. What is the minimum number of grades that must be assigned in order to guarantee at least one of the grades has been assigned 10 times.
- Consider the following requirements of a car rental company: A member may rent more than one car and a car can be rented by more than one member in a given period. Cars are classified into categories (For example; economy, premium, SUV). A car is assigned to only one driver, but a driver can drive many cars. A car can only belong to one category, but a category can have one or more cars. Details of car rent must be recorded to reflect the rent duration and cost. 1. What are the possible entities in this business case? 2. Suggest 2 relationship names that might exist between the entities 3. List at least 2 attributes of each entity?Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: -- Each movie is identified by title and year of release. Each movie has a length in minutes and a rating (e.g., G, PG, or R). Each has a production company, and each is classified under one or more genres(such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. An actor may have multiple quotes from one movie. -- Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie, i.e., the character he or she plays. -- Directors are also identified by name and date of birth and direct one or more movies. -- Production companies are identified by name and each has an address. A production…ManufacturerA manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used.Assumptions• A supplier can exist without providing components.• A component does not have to be associated with a supplier.• A component does not have to be associated with a product. Not all components are used in products.• A product cannot exist without components. Construct an ERD table to show how you would track this information.
- A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project. Attributes of CHEMIST include Employee ID (identifier), Name, and Phone No. Attributes of PROJECT include Project ID (identifier) and Start Date. Attributes of EQUIPMENT include Serial No and Cost. The organization wishes to record Assign Date—that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A chemist must be assigned to at least one project and one equipment item. A given equipment item need not be assigned, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.B. Art Museum Database Draw an EER diagram to keep track of information for an art museum. Assume that the following requirements were collected: (10 marks) The museum has a collection of art objects. Each art object has a unique ID, a year (when it was created, if known), a title, and a description. Art objects must be categorized based on their type. There are three main types: painting, sculpture, plus another type called other to accommodate objects that do not fall into one of the two main types. A painting has a paint type (oil, watercolor, etc.), material on which it is drawn on (paper, canvas, wood, etc.), and style (modern, abstract, etc.). A sculpture has a material from which it was created (wood, stone, etc.), height, weight, and style. An art object in the other category has a type (print, photo, etc.) And style. The museum keeps track of artist information, if known: name, date born (if known), date died (if not living), country of origin, epoch, main style, and…Draw an ER model; An author writed a book . Every book has a title, ISBN, year, and price. each book may be authored by one or more author and each author may write one , or more than one book. For authors the database keeps the name, address and URL of their homepage. Each book has a publisher. The database keeps the name, address , and phone number adn the URL of their wedbsite. Each publishers publishes one or more books and each book is published by exactly one publisher. The warehouse stocks several books. Each warehouse has a code, address and phone number. The database records the number of copies stocked at various warehouse.