1.  create database ClubTenis;
2.
3.  use ClubTenis;
4.
5.  create table Pistas(
6.  IdPista Varchar(20) Primary key not null,
7.  Descripcion Double,
8.  Grada Bool,
9.  Homologada Bool
10. )engine =InnoDB;
11.
12. create table Socios(
13. NIF_S Varchar(20) Primary key not null,
14. NombreS Varchar(20),
15. ApellidosS Varchar(50),
16. DireccionS Varchar(50),
17. TelefonoS int,
18. CuentaCS Varchar(40),
19. Accionista Bool
20. )engine =InnoDB;
21.
22. create table Profes(
23. NIF_P Varchar(20) Primary key not null,
24. NumFed Varchar(30),
25. NombreP Varchar(20),
26. ApellidosP Varchar(50),
27. DireccionP Varchar(50),
28. TelefonoP int
29. )engine =InnoDB;
30.
31. create table Curso(
32. IdCurso Varchar(20) Primary key not null,
33. NombreC Varchar(50),
34. MaxAlumnos int,
35. NIF_P Varchar(20),
36. Foreign key(NIF_P) references Profes(NIF_P) on Update Cascade on Delete
37. Cascade
38. )engine =InnoDB;
39.
40. create table Reservas(
41. IdPista Varchar(20) not null,
42. FechaRe Date not null,
43. Hora_ent Time not null,
44. Hora_sal Time,
45. Pagado Bool,
46. Luz Bool,
47. Foreign key(IdPista) references Pistas(IdPista) on Update Cascade on Delete
48. Cascade,
49. Primary Key (IdPista,FechaRe,Hora_ent)
50. )engine =InnoDB;
51.
52. create table Horario(
53. IdCurso Varchar(20) not null,
54. Dia Date not null,
55. Hora_Inicio Time,
56. Hora_Fin Time,
57. Foreign key(IdCurso) references Curso(IdCurso) on Update Cascade on Delete
58. Cascade,
59. Primary Key (IdCurso,Dia)
60. )engine =InnoDB;
61.
62. create table Recibos(
63. IdCurso Varchar(20) not null,
64. NIF_S Varchar(20) not null,
65. FechaRe Date not null,
66. Pagado Bool,
67. Cuota Double,
68. Foreign key(IdCurso) references Curso(IdCurso) on Update Cascade on Delete
69. Cascade,
70. Foreign key(NIF_S) references Socios(NIF_S) on Update Cascade on Delete
71. Cascade,
72. Primary Key (IdCurso, NIF_S,FechaRe)
73. )engine =InnoDB;
74.
75. create table Juega(
76. NIF_S Varchar(20) not null,
77. IdPista Varchar(20) not null,
78. FechaRe Date not null,
79. Hora_ent Time not null,
80. Foreign key(NIF_S) references Socios(NIF_S) on Update Cascade on Delete
81. Cascade,
82. Foreign key(IdPista) references Pistas(IdPista) on Update Cascade on Delete
83. Cascade,
84. Foreign key(IdPista,FechaRe,Hora_ent) references
85. Reservas(IdPista,FechaRe,Hora_ent) on Update Cascade on Delete Cascade,
86. Primary Key(NIF_S,IdPista,FechaRe,Hora_ent)
87. )engine =InnoDB;