Databases | SQL | Oracle | MS Access Answers

get all the music video released before the year 2016. you can consider the video which contains "music" as name as music video.sort th output in descending order of the year and ascending order of name.

How to connect Java application with and Mysql database using JDBC?

Business rules for hairdressers:

1. All entities should have surrogate primary keys.

2. Each hairdresser can work at multiple different salons over time, and every salon employs many different hairdressers.

3. The job title of a hairdresser at a specific salon must be stored in the database.

4. The name and surname of each hairdresser must be stored in the database.

5. The name of each salon must be stored in the database.

6. Every hairdresser is certified to have several different skills, and each skill can be mastered by many different hairdressers.

7. The name of each skill must be stored in the database.

8. The date that a specific hairdresser was certified to have a specific skill must be stored in the database. 

Given the relations R (A, B) and S (B, C) where values are all integers. Examine the undermentioned three relational algebra expressions

a. A, C(R⋈B=1S)

b. A(B = 1R)XC(B = 1S)

c. A, C (ARXB = 1S)

Two of the three expressions are equivalent (i.e., they produce the same answer on all databases), while one of them can produce a different answer

1. Which query can produce a contrasting answer? Give the simplest database instance you can think of where a different answer is produced
2. Why do we care that the expressions are equivalent?
3. How can we determine that the expressions are equivalent?

1.If we apply the cross-product operation to these two instances of STUDENTS & BOOKS, what would be the resulting relation?

STUDENTS

Student_ID Student_Name Qualification

401 Andile HCIT

402 Carol DIT

403 Amber BSc

404 Bright HCIT

BOOKS

Book_ID Title Copy-right

101 Database fundamentals 2017

102 C++ how to program 2018

103 Simply Visual Basic 2019

104 OOP for beginners 2020

1.1 SELECT and RETURN all students with qualification HCIT from relations STUDENTS X BOOKS

1.2 Write a relational algebra expression using the symbolic notation for the given question in (1.1) above.

Hillar Furniture Enterprise is a furniture store owned by Dr. Hillar Addo of AIT. The materials manager of this company maintains a list of suppliers for each of the materials items purchased by the company from outside vendors. The following table shows the essential data required for this application. Attribute Name Material_ID Material_ Name Unit_of_Measure Standard_Cost Vendor_ID Vendor_name Unit_price Terms_Code Terms Sample Value 3792 Hinges 3” locking Each GHC 5.00 V300 Apex Hardware GHC 4.75 1 COD a. Identify the functional dependencies for this data. You may assume the following: 6  Each material has one or more suppliers. Each supplier may have supply one or more items or may not supply any items.  The unit price for a material may vary from one vendor to another  The terms of a code for a supplier uniquely identifies the terms of a sale (e.g. code 2 means 10% net 30 days, etc.). b. Convert your data into a set of 3NF relations, identifying all the primary and foreign keys

Draw interfaces for suppliers of bulling construction desktop application (with source code)