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 makes relationship between Customer and Order relations:Select one:a.Zero-to-Manyb.Many-to-Onec.One-to-Manyd.One-to-Onee.Many-to-Many

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)

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

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?

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.

"Product has Supplier" is a One to Many Cardinality typeOne to One Cardinality typeMany to Many Cardinality typeAll of the above