[SOLVED] 代写 XML database Q4. Consider the following database:

Q4. Consider the following database:
Parts P, PNAME, PRICE
Components P, SUBP, QTY
where P and SUBP are from the same domain and SUBPrepresents the sub parts used in a part the QTY is their respective quantity.
Write the following query in any two of the languages: RA, TRC, DRC, Datalog, orSQL:
Query:For any part, say P1, give all the parts names that make up a part, their part, etc.
Specify a constraint in any way you like that the price of a part shall be more than its cost.

Q5. Consider the following relation:
Parts P, PNAME, COLOR, WEIGHT, S, SNAME, SADDRESS, SZIP, SUBP, QTY
where P and SUBP are from the same domain and SUBP represents the sub parts used in a part the QTY is their respective quantity. S, SNAME, SADDRESS, and SZIP are supplier number, supplier name, address and zip respectively.
Design 3NF andor BCNF relations for Parts relation. Be as realistic as possible. Do not make simplifying assumptions.

Q7. 30 pointsFor the following XML document:

I. Write the following queries in XPath. What is the result of each?
Find the names of all ships
Find all the Class elements for classes with a displacement larger than 35000.
Find the years in which ships having the same name as their class were launched.
II. Give a DTD definition for the above document
III. Give XML Schema definitions for the above document
IV. Given an equivalent JSON document