HELP WITH DATABASES SYSTEMS ASAP !! Thanks in advance

nswer the following questions Explain difference between lossy decomposition and lossless decomposition If you write a SQL statement to inner join the following two tables based on Plocation value a inner join condition, is the result table lossy or lossless? (Explain why?) EMP LOCS .. EMP PROJ Hours Phame Plocation PK Given a relation schema R-(SSN, Ename, Pnumber, Pname, Plocation, Hours) R is decomposed to R1, R2, R, as shown below. R- EMP- (SSN, Ename), R PROJ (Pnumber, Pname, Plocation) R, = WORKS-ON-SSN, Pnumber, Hours) Set of functional dependencies F is given as follows: FSSNEname; Pnumber(Pname, Plocation); (SSN, Pnumber) Hours Show whether the decomposed relations is lossy or loseless Show the following table schema is in 1, 2d, a nd 3d NF, but not in BCNF. LOTS1A l Property-id# 1 County-name Lot#1 Area FD1 FD2 FD5 FD stands for functional dependency ecompose the table schema shown above (LOTSIA) to be in BCNF