Creación generador de la base de datos(Script de creación)

Creación generador de la base de datos(Script de creación)

Se realizo el generador de la base de datos(Script de creación).

En el cual se detectaron unos errores de tipos de datos como lo son:
* Tratar money como int
* Fue el de guardar un date como un varchar.

USE master
GO
-----------------------------------------------------------------------------------------------------------------------
IF EXISTS(select * from sys.databases where name='CuentasAhorroDB')
BEGIN
 ALTER DATABASE [CuentasAhorroDB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
 DROP DATABASE [CuentasAhorroDB]
END
GO

CREATE DATABASE [CuentasAhorroDB]
GO

USE [CuentasAhorroDB]
GO

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_TipoGestion](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [Nombre] [varchar](50) NOT NULL,
 [Comision] [money] NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_TipoMedio](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [Nombre] [varchar](50) NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_TipoMovimiento](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [Nombre] [varchar](50) NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_TipoMovimientoInteres](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [Nombre] [varchar](50) NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_TipoMovimientoPendiente](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [Nombre] [varchar](50) NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_TipoCuenta](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [Nombre] [varchar](50) NOT NULL,
 [Moneda] [varchar](30) NOT NULL,
 [SaldoMinimoMensual] [money] NOT NULL,
 [TasaInteresAnual] [float] NOT NULL,
 [MultaSaldoNegativo] [money] NOT NULL,
 [MultaSaldoMinimo] [money] NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_Banco](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [Nombre] [varchar](50) NOT NULL,
 [Comision] [money] NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_Cliente](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [Nombre] [varchar](50) NOT NULL,
 [Usuario] [varchar](50) NOT NULL,
 [Contraseña] [varchar](50) NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_Cuenta](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [FK_TipoCuenta] [int] FOREIGN KEY REFERENCES [CA_TipoCuenta](ID) NOT NULL,
 [FK_Cliente] [int] FOREIGN KEY REFERENCES [CA_Cliente](ID) NOT NULL,
 [SaldoReal] [money] NOT NULL,
 [SaldoPendiente] [money] NOT NULL,
 [SaldoIntereses] [money] NOT NULL,
 [FechaEstadoCuenta] [date] NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_EstadoCuenta](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [FK_Cuenta] [int] FOREIGN KEY REFERENCES [CA_Cuenta](ID) NOT NULL,
 [Fecha] [date] NOT NULL,
 [SaldoTotal] [money] NOT NULL,
 [InteresAcum] [money] NOT NULL,
 [SaldoTenP] [money] NOT NULL,
 [QRetiros] [int] NOT NULL,
 [TotalRetiros] [money] NOT NULL,
 [QMulta] [int] NOT NULL,
 [TotalMultas] [money] NOT NULL,
 [QDepositos] [int] NOT NULL,
 [TotalDepositos] [money] NOT NULL,
 [QGestiones] [int] NOT NULL,
 [TotalGestiones] [money] NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_SaldoDiario](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [FK_Cuenta] [int] FOREIGN KEY REFERENCES [CA_Cuenta](ID) NOT NULL,
 [Fecha] [datetime] NOT NULL,
 [Saldo] [money] NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_Movimiento](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [FK_Cuenta] [int] FOREIGN KEY REFERENCES [CA_Cuenta](ID) NOT NULL,
 [FK_TipoMovimiento] [int] FOREIGN KEY REFERENCES [CA_TipoMovimiento](ID) NOT NULL,
 [FK_TipoMedio] [int] FOREIGN KEY REFERENCES [CA_TipoMedio](ID) NOT NULL,
 [FechaHora] [datetime] NOT NULL,
 [Monto] [money] NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_MovCajeroAut](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [FK_Banco] [int] FOREIGN KEY REFERENCES [CA_Banco](ID) NOT NULL,
 [FK_Movimiento] [int] FOREIGN KEY REFERENCES [CA_Movimiento](ID) NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_MovimientoPendiente](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [FK_Cuenta] [int] FOREIGN KEY REFERENCES [CA_Cuenta](ID) NOT NULL,
 [FK_TipoMovimientoPendiente] [int] FOREIGN KEY REFERENCES [CA_TipoMovimientoPendiente](ID) NOT NULL,
 [Monto] [money] NOT NULL,
 [FechaHora] [datetime] NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_MovimientosIntereses](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [FK_Cuenta] [int] FOREIGN KEY REFERENCES [CA_Cuenta](ID) NOT NULL,
 [FK_TipoMovimientoInteres][int] FOREIGN KEY REFERENCES [CA_TipoMovimientoInteres](ID) NOT NULL,
 [Fecha] [datetime] NOT NULL,
 [Monto] [money] NOT NULL,
 PRIMARY KEY(ID)
)

-----------------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[CA_Gestion](
 [Id] [int] IDENTITY(1,1) NOT NULL,
 [FK_Movimiento] [int] FOREIGN KEY REFERENCES [CA_Movimiento](ID) NOT NULL,
 [FK_TipoGestion] [int] FOREIGN KEY REFERENCES [CA_TipoGestion](ID) NOT NULL,
 [Descripcion] [varchar](50) NOT NULL,
 PRIMARY KEY(ID)
)

Horas Trabajadas: 2.5 horas
Autor: Edward Ovares Villegas