Question: please answer them by order 1,2,3, ans do on create SQL table Horse Track Relational Schema 3) RaceHorse(regNum(int), type(varchar), gender(varchar), hName(varchar), purchaseDate(datetime), purchasePrice(double), trainer(int), stabledAt(int)
please answer them by order 1,2,3, ans do on create SQL table
Horse Track Relational Schema 3) RaceHorse(regNum(int), type(varchar), gender(varchar), hName(varchar), purchaseDate(datetime), purchasePrice(double), trainer(int), stabledAt(int) 4) Offspring(regNumlint) parent(int) 1) Person(pldint), pName,(varchar) pPhone(varchar), pAddress(varchar) 5) Owner(pld(int), regNumlint), percentage(double) 8) Entry(sld (int), rNumber(int),gate(int), finalPos(int), jockey(int), horse(int)) 2) Barn(bld (int), bName(varchar)) 6) RaceSchedule(sld, year, month, day) 7) Race(rNumber sld, purse)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
