Consider the following structure of an inventory Oracle database. HUMERC (B) WOWR) VIMOHAR ( S DECL MARIC S) WOMR AME CUBT NAE OITY COMMION WOHARSS CITY GRADE MUMERIC (3) BALESMAN D MERC(S) orders ORD NO PURCH AMT MUMERIC (S) DECIMAL ( DATE ORD DATE CUSTOMER D NUMERIC (5) SALESMAN D NUMERIC (6) Display those customers who are neither from the city New York nor their grade values are more than 100.
Q: QUESTION 2 Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin…
A: Two Fruits can't have same name even the Fruit ID is different. Because, Name field is having UNIQUE…
Q: Consider the following relations in the relational schema for a database that keeps track of…
A: Given: Consider the following relations in the relational schema for a database that keeps track of…
Q: QUESTION 3 Consider the following database schema for a library. Book (BookiD:int,…
A: Answer :-- True
Q: Consider the following example database and query and then show the value of…
A: distance(volvo,Volvo_Distance) Volvo_Distance = speed (volvo, Speed) * time (volvo, Time) = speed…
Q: Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID:…
A: Primary key of one table when used in another table is referred as foreign key. Foreign key need not…
Q: You are given the following database schema: Sailors(sid, sname, rating, age) Boats(bid, bname,…
A: Given Data : Number of pages in main memory = 9 Sailors : Tuples = 100000 pages = 1000 Sailors…
Q: QUESTION 3 Consider the following database schema for a library. Book (BookID:int,…
A: Foreign key :- A foreign key is a set of attributes in a table that refers to the primary key of…
Q: 2.Given the following database in Figure 1 Employee(ssn:int,name:string.jobTitle:string)…
A: Entity Relationship Diagram (ERD) or Entity Relationship Diagram (ERD) is a diagram that shows the…
Q: A database has four transactions. Let min_support=60% and min conf=80% TID date Items_bought T100…
A: The support and confidence are the association analysis for the performance measure. Support is all…
Q: Consider the database schema below. Fruit (ID: integer. Name: String ) Vitamin (FruitID: Integer.…
A: In the Fruit table, Name is not a primary key. Key constraint states thate all the values of primary…
Q: Consider the following Database Schema. PK CUs COOE PK OL ER contains PKFK1 ry PK CUS LNAME CUs…
A: BY USING INNER JOIN WE CAN GET THE DESIRED RESULT AND TO DISPLAY THE TABLE AS IT IS SHOWN WE NEED TO…
Q: Consider a student database where the primary key is StudentID and there are indexes on Major, Age,…
A: Information provided: A table for students is provided on the university website, with the primary…
Q: A QUESTION 6 Consider the following database schema for a library. Book (BookID:int,…
A: The instances in a database schema, as well as their relationships, are described by the schema. It…
Q: QUESTION 5 Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin…
A: Given: To choose correct option.
Q: The following question are based on the database whose relational schemas are emp(EMPNO, ENAME, JOB,…
A: embeddings values into table Addition INTO emp (EMPNO, ENAME, SAL, DEPTNO) Qualities (8988,…
Q: QUESTION 2 Consider the following database schema for a library. Book (BookID:int…
A: Entity integrity constraints The entity integrity constraint states that primary key value can't be…
Q: The figure below shows an ER schema for a university database. Map this ER schema into a relational…
A: Since the question refers to a mapping algorithm which is not described in the question we are going…
Q: Question 1 - Apriori Algorithm - Given the following transaction database: Transaction ide Itemse…
A: a) Given minimum support = 50%. Total number of items = 5 So, minimum support count = (number of…
Q: In a database, there are values a data element can take, and there are values it cannot take. In…
A: The answers are given in below sections for each with explanation .
Q: Consider the following database composed of two tables. PLAY PLAY_CODE PLAY_NAME…
A: Answer :- Play entity: Primary Key: PLAY_CODE Explanation : - because using PLAY_CODE you can find…
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: Suppose you want to store the records of the employees of your company. They all have employee ID's…
A: Actually, java is a object oriented programming language. It is a platform independent.
Q: Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID:…
A: The question is to choose the correct option from the given options in the question.
Q: Consider the database schema below. Fruit (ID: integer, Name: String ) Vitamin (FruitID: Integer.…
A: - We need to select the correct among the provided for the provided relation. - The question is to…
Q: b) Consider a simple relational database of Hospital Management System. (Underlined attributes…
A: 1. SELECT PatientID FROM Patients As P , Hospital As H WHERE P. PatientID =H.PatientID…
Q: Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin (FruitID:…
A: The answer is ,no,it violates the domain constraint. Below is explanation:
Q: Consider the relational database below, where the primary keys are underlined. employee…
A: As per guidelines, I'm supposed to answer first 3 part of the given questions. Repost the other…
Q: Consider the following database schema for a library. Book (BookID:int, BookTitle:string(unique),…
A: No, It Is Not Possible to have a Borrowing-Record with an unknown CustomerCPR.
Q: I need the answer as soon as possible
A: The above question the 4 relation schema and explain and the find a weak entity in the below step
Q: Suppose you have the following relational database scheme for a real estate agency: Real Estate…
A: Solution:
Q: QUESTION 5 Consider the database schema below. Fruit (ID: integer. Name: String (unique)) Vitamin…
A: Two tables are given with primary key ID in fruit table. Vitamin table has composite key fruitID…
Q: Consider the following relational database schema that contains information about employees and…
A: {pid,pname} {pid,pname,budget} {pname,managerid} {pname,budget,managerid}
Q: With the following Object Oriented Relational Database schema, select the attributes that a tuple in…
A: Actually, A relational database is a type of database that stores and provides access to data…
Q: Consider the database schema below for hotels in countries. A country have many hotels, and the same…
A: Data Base Management System: DBMS is a software that is used to store, manage and use database…
Q: Consider the following database schema for a library. Book (BookID:int, BookTitle:string(unique),…
A: CPR is the type of int
Q: Calculate the I/O cost of sorting the Sailors relation
A: Let's see what are we given. We have available 9 pages in the main memory. Solution 1) Given that…
Q: Balanced tree is one of the data access techniques in database. How does it work? How data can be…
A: Actually, given question regarding balanced tree.
Q: QUESTION 7 Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin…
A: Incorrect options Referential Integrity Constraint :A foreign key should have a primary key that…
Q: Consider the database schema below. Fruit (ID: integer. Name: String (unique)) Vitamin (FruitID:…
A: Here for the relation Vitamin, primary key is (FruitID, VitaminName) It means for any row, if values…
Q: (c) The following relational schema form part of a database held for library borrowing system.…
A:
Q: Student(student Number, StudentName, studentAddress) Book(bookNumber, bookTitle, #authorNumber,…
A: The relational algebra for the given query is as follows,
Q: Select from below ALL statements that are true. Select one or more: a. Adding locking and…
A: Answer and explanation is provided in the following steps.
Q: QUESTION 6 Consider the database schema below. Fruit (ID: integer, Name: String (unique)) Vitamin…
A: Given: To choose the correct option.
Q: QUESTION 2 Consider the database schema below. Fruit (ID: integer. Name: String (unique)) Vitamin…
A: EXPLANATION: The entity set that is utilized to uniquely identify an entity inside its entity set…
Q: 4. Consider the following GRADEBOOK relational schema describing the data for a grade book of a…
A: Relation schema defines the design and structure of the relation like it consists of the relation…
Q: Assume that a student table in a university database had index on StudentID (the primary key) and…
A: Given information: A student table is given in the university website with an index on StudentlD as…
Q: A student database may include indexes on fields such as major, age, marital status, and home zip…
A: Information disclosed: On the university website, a table of students is provided, with an index on…
Q: Consider the following database composed of two tables. PLAY PLAY_CODE PLAY_NAME DIR_NUM 1001…
A: Given:- Consider the following database composed of two tables. PLAY PLAY_CODE PLAY_NAME…
Step by step
Solved in 2 steps
- The following is a relational schema for a database to document sharksightings for a research project. Primary keys are underlined. ForeignKeys are identified by FK, and their name indicates the attribute that theyreference.________________________________________________________________Sharks(shark_id:Integer, name:String, species_name:String,tagged_by_mission_id:Integer (FK))Sightings(shark_id:Integer (FK), sighting_num:Integer,sight_time:Timestamp, lat:Real, lng:Real, ocean:String, mission_id:Integer(FK))Missions(mission_id:Integer, start_date:Date, end_date:Date,vessel_id:Integer (FK))ResearchVessels(vessel_id:Integer, name:String)________________________________________________________________Sharks identified by a unique id, have a name which is not necessarilyunique, and a scientific species name.All Sharks are tagged and are sighted by Research Vessels, which areresearch ships that go on research Missions throughout the year. EachMission has a start and end date. Shark…Consider the following database in Prolog:birthday(tom).birthday(fred).birthday(helen),birthday(jack).happy(mary).happy(jane).happy(helen).happy(albert).attendparty(jane).attendparty(helen).hold_party(X): - birthday(X), happy(X) What would be the answer to the following query??- hold party(Who) a. Who = jane.b. Who = mary.c. Who = helen.d. All of the above.e. Who cannot be unified / instantiated.Following on your BIG break to make a database for an… organization that organizes table tennis tournaments (also known as “Tourney”s) at their premises on behalf of clubs, you’ve written down the business rules as follows: One Match belongs to One Tourney, and not none. One Tourney has Many Matches, at least one and a maximum of 128. One Match takes place on One Table, and not none. One Table is used in Many Matches, and possibly none. One Match belongs to one Category, and not none. One Category appears in Many Matches, and possibly none and a max of 32. One Match involves Many Players, minimum 2 and maximum 4. One Player plays Many Matches, and possibly none. You have also been given a small sample of their records (which is not in the least in relational format), which may prove useful. It is below. Match Number Tourney Tourney Start Date Day Time Slot In Day Player Names(Team 1) Player Names(Team 2) Player IDs (Team 1) Player IDs(Team 2)…
- Consider a database that consists of the following relations.SUPpLIER(Sno. Sname)PART(Pno, Pname)PROJECT(Jno, Jname)SUPPLY(Sno, Pno, Jno)The database records information about suppliers, parts, and projectsandincludes a ternary relationship between suppliers, parts, and projects.Thisrelationship is a many-many-many relationships. Specify and execute thefollowingqueries using the relational algebraRetrieve the part numbers that are supplied to exactly two projects.b. Retrieve the names of suppliers who supply more than two parts toproject J11c. Retrieve the part numbers that are supplied by every supplier.d. Retrieve the project names that are supplied by supplier S1' only.e. Retrieve the names of suppliers who supply at least two different partseach to at least two different projects.Consider the following database of a music record company:MUSICIAN(ID, Name, Surname, BirthYear, DeathYear, Nationality, Instrument) BAND(BandID, Name, BreakupYear)MEMBER(MusicianID, BandID, JoinYear)SONG(SongID, Title, Duration, BandID, Duration)ALBUM(AlbumID, BandID, Title, Year, Genre) INCLUDED(SongID, AlbumID)NOTE:● If a musician is still alive, then MUSICIAN.DeathYear = 0● If the band is still playing together, then BAND.BreakupYear = 0● A musician can be part of more than a band.● Song duration is expressed in seconds.1a) Find the data of all bands with at least a Cello player, who published an album of the genre “ProgRock” after 1982, where at least a song of duration 15 minutes is included.1b) Find the data of all musicians that were founding members of a band, that is, no other musician joined the same band in a previous year.Normalize the following schema, with given constraints, to 4NF. books(accessionno, isbn, title, author, publisher) users(userid, name, deptid, deptname) accessionno → isbn isbn → title isbn → publisher isbn →→ author userid → name userid → deptid deptid → deptname
- PART B Consider the college database you implemented in the image provided and answer the following questions. i. Write SQL statements to populate the relevant tables with the following data Studno givenName familyName faculty hons year courseno equipmentused subjectsubject 220123 Angel Matheaus FCI Computer Science 2 CSC101 laptop java 227456 Michael Jackson ACC Accounting 3 ACC510 calculator Statistics 223546 Joy Willian MGT Management 1 MGT305 project leadership Name roomno course Andrea Kulima 709 ACC510 Princess Bukohwo FCI 6 CSI101 Peter Jones 201 MGT305 Thandeka Pheto OB 12 CSI101 All staff (appraisees) are appraised by Thandeka Pheto. ii. Write an SQL statement to change Thandeka Pheto’s room number to “PH506”iii. Joy Willian decided to transfer to another college, write SQL statement to remove her details from the college’s database. iv. Write an SQL query to show all students in year 2 of their studies v. Write an SQL query to list all…Given the following relational schema of a database library (primary keys are underlined and foreign keys are preceded by #): Student(studentNumber, StudentName, studentAddress) Book(bookNumber, bookTitle, #authorNumber, #editorNumber, yearEdition) Author(authorNumber, authorName, authorAddress) Editor(editorNumber, editorName, editorAddress) Borrow(#studentNumber, #bookNumber, borrowDate, returnDate) Write the following queries in Relational Algebra: Find the details of students who borrowed the book titled ‘Database Management Systems’Given the following relational schema of a database library (primary keys are underlined and foreign keys are preceded by #): Student(studentNumber, StudentName, studentAddress) Book(bookNumber, bookTitle, #authorNumber, #editorNumber, yearEdition) Author(authorNumber, authorName, authorAddress) Editor(editorNumber, editorName, editorAddress) Borrow(#studentNumber, #bookNumber, borrowDate, returnDate) Write the following queries in Relational Algebra: List the details (bookNumber, bookTitle) of books whose author’s name is ‘Ramakrishnan’
- A database has 4 transactions, shown below.TID Date items_boughtT100 10/15/04 {K, A, D, B}T200 10/15/04 {D, A, C, E, B}T300 10/19/04 {C, A, B, E}T400 10/22/04 {B, A, D}Assuming a minimum level of support min_sup = 60% and a minimum level ofconfidencemin_conf = 80%:(a) Find all frequent itemsets (not just the ones with the maximum width/length) using the Apriori algorithm. Show your work—just showing the final answer is not acceptable. For each iteration show the candidate and acceptable frequent itemsets. You should show your work similar to the way the example was done in thePowerPoint slides.(b)List all of the strong association rules, along with their support and confidence values, whichmatch the following metarule, where X is a variable representing customers and itemi denotes variables representing items (e.g., “A”, “B”, etc.).x transaction, buys(X, item1) buys(X, item2) buys(X, item3)Hint: don’t worry about the fact that the statement above uses relations. The point of the…Consider the relational database below, where the primary keys are underlined.employee (person-name, street, city)works (person-name, company-name, salary)company (company-name, city)manages (person-name, manager-name)Give a query for each of the following:a Give all managers in database a 10 percent raise.b Give managers in the database a 10 percent raise, unless the salary would be greaterthan $100,000. In such cases, give only 3 percent raise.c Delete all tuples in the works relation for employees of Small Bank CorporationYou are given the following database schema:Sailors(sid, sname, rating, age)Boats(bid, bname, color)Reserves(sid, bid, day)Consider the join on Sailors ▷◁ Reserves and assume that you have the following statistics andlimitations: * You have available 9 pages in main memory.* Sailors: 100000 tuples, 1000 pages; Boats: 2000 tuples, 10 pages; Reserves: 110000 tuples,550 pages 1. Calculate the I/O cost of this join using the Block Nested Loop algorithm?