Consider the following relations to answer Question.Manufacturer (ManufacturerId, MName, DateOfBirth, Gender MAddress, AwardWon)Part (PartNo, PName, Description, ManufacturerId)Order (PartNo, OrderNo, OrderQuantity, OrderedDate, CustomerId)Customer (CustomerId, Email, CName, CAddress, Job, TotalNoOfCustomers)Select the suitable (min, max) notation for structural constraint on participation of Part in has relationship. There is a has relationship between Order and Part relations.Select one:a.(0, n)b.(n, n)c.(1, n)d.(0, 0)e.(1, 1)

Consider the following relations to answer Question.Manufacturer (ManufacturerId, MName, DateOfBirth, Gender MAddress, AwardWon)Part (PartNo, PName, Description, ManufacturerId)Order (PartNo, OrderNo, OrderQuantity, OrderedDate, CustomerId)Customer (CustomerId, Email, CName, CAddress, Job, TotalNoOfCustomers)What is/are the most suitable participation constraint (s) to describe has relationship between Order and Part relations?(multiple answers)Select one or more:a.There is partial participation of Order in has relationship.b.There is total participation of Order in has relationship.c.There is total participation of Order with Part.d.There is partial participation of Part in has relationship.e.There is total participation of Part in has relationship.

Consider the following relations to answer Question.Manufacturer (ManufacturerId, MName, DateOfBirth, Gender MAddress, AwardWon)Part (PartNo, PName, Description, ManufacturerId)Order (PartNo, OrderNo, OrderQuantity, OrderedDate, CustomerId)Customer (CustomerId, Email, CName, CAddress, Job, TotalNoOfCustomers)The cardinality of the has relationship between Order and Part relations:Select one:a.Many-to-Oneb.One-to-Onec.Zero-to-Manyd.Many-to-Manye.One-to-Many

onsider the following relations to answer Question.Manufacturer (ManufacturerId, MName, DateOfBirth, Gender MAddress, AwardWon)Part (PartNo, PName, Description, ManufacturerId)Order (PartNo, OrderNo, OrderQuantity, OrderedDate, CustomerId)Customer (CustomerId, Email, CName, CAddress, Job, TotalNoOfCustomers)Most suitable data type (s) for OrderNo, OrderQuantity, OrderedDate in Order relation respectively is/are:Select one:a.Number, Number, Dateb.Text, Text, Datec.Number, Number, Numberd.Number, Text, Datee.Text, Text, Text

Consider a relation involving suppliers, parts, and projects:Initial Table (SupplierPartsProjects)Supplier Part  Project S1 P1 J1S1 P2 J1S1 P1 J2S2 P2 J2Assume the following constraints:i. Every part supplied for a project is supplied by all suppliers supplying any part for that project.ii. Every part supplied by a supplier is supplied by that supplier for all projects to which that supplier supplies any part.In the given example, what join dependencies exist on the table "SupplierPartsProjects"?{Supplier, Part} ⟶ SupplierPartsProjects{Supplier, Project} ⟶ SupplierPartsProjects{Part, Project} ⟶ SupplierPartsProjectsAll of the above

we have following relations:Supplier(S#,sname,status,city)Parts(P#,pname,color,weight,city)SP(S#,P#,quantity)Answer the following queries.(1) Find s# of supplier who supplies ‘red’ part.(2) Count number of supplier who supplies ‘red’ part.(3) Sort the supplier table by sname?