FIGURA5.2, Sql Server

FIGURA5.2

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

select @@version as 'sql server version'
CREATE TABLE [dbo].[Tablacincouno](
    [EMP_NUM] [nvarchar](255) Primary Key NOT NULL, 
    [EMP_LNAME] [nvarchar](255) NULL,
    [EMP_FNAME] [nvarchar](255) NULL,
    [EMP_INITIAL] [nvarchar](255) NULL,
    [EMP_LICENSE] [nvarchar](255) NULL,
    [EMP_RATINGS] [nvarchar](255) NULL,
    [EMP_MED_TYPE] [nvarchar](255) NULL,   
    [EMP_HIRE_DATE]datetime,
)
GO

CREATE TABLE [dbo].[DEPENDENT](
    [EMP_NUM] [nvarchar](255) Primary Key NOT NULL,  
    [DPNT_NUM] [nvarchar](255) NULL,
    [DPNT_LNAME] [nvarchar](255) NULL,
    [DPNT_FNAM] [nvarchar](255) NULL,
    [DPTN_RELATION] [nvarchar](255) NULL,
)
GO
   
   CREATE TABLE [dbo].[PILOT](
    [EMP_NUM] [nvarchar](255) Primary Key NOT NULL,  
    [PIL_LICENSE] [nvarchar](255) NULL,
    [PIL_RATINGS] [nvarchar](255) NULL,
    [PIL_MED_TYPE] [nvarchar](255) NULL
)
GO
    
    CREATE TABLE [dbo].[MECHANIC](
    [EMP_NUM] [nvarchar](255) Primary Key NOT NULL,  
    [MEC_TITLE] [nvarchar](255) NULL,
    [MEC_CERT] [nvarchar](255) NULL
)
GO
    
    CREATE TABLE [dbo].[ACOUNTTANT](
    [EMP_NUM] [nvarchar](255) Primary Key NOT NULL,  
    [ACT_TITLE] [nvarchar](255) NULL,
    [ACT_CPA_DATE] [nvarchar](255) NULL
    )
   
GO
   
    INSERT INTO [dbo].[Tablacincouno] VALUES(100, 'Kolmycz','Xavier','T',' ',' ', ' ', TRY_CONVERT (TIME,'7:40:10.1104000')),
                                            (101, 'Lewis','Marcos',' ','ATP', 'SEL/MEL/Instr/CFII',1, TRY_CONVERT (TIME,'12:05:10.4000000')),
                                            (102, 'Vandam','Jean','',' ',' ', ' ', TRY_CONVERT (TIME,'12:20:10.0000000')),
                                            (103, 'Jones','Victoria','R',' ',' ', ' ', TRY_CONVERT (TIME,'14:22:10.0000000')),
                                            (104, 'Lange','Edith',' ','ATP','SEL/MEL/Instr',1, TRY_CONVERT (TIME,'17:35:10.0000000')),
                                            (105, 'Wiliams','Gabriel','U','COM','SEL/MEL/Instr/CFI', 2, TRY_CONVERT (TIME,'19:50:10.0000000')),
                                            (106, 'Duzak','Mario',' ','COM','SEL/MEL/Instr', 2, TRY_CONVERT (TIME,'20:36:10.0000000')),
                                            (107, 'Diante','Venite','L',' ',' ', 2, TRY_CONVERT (TIME,'11:06:10.0000000')),
                                            (108, 'Wiesenbach','Joni',' ',' ',' ', ' ', TRY_CONVERT (TIME,'17:05:50.0000000')),
                                            (109, 'Travis','Brett','T','COM','SEL/MEL/Instr/CFI',1, TRY_CONVERT (TIME,'12:05:10.0000000')),
                                            (110, 'Genkazi','Stan',' ',' ',' ', ' ', TRY_CONVERT (TIME,'10:05:10.0000000')) 
                                            
 INSERT INTO [dbo].[DEPENDENT] VALUES (100, 15, 'Kolmycz','Xavier',' '),
                                      (101, 23,'Lewis','Marcos', ' '),
                                      (102, 04,'Vandam','Jean', ' '),
                                      (103, 15,'Jones','Victoria', ' '),
                                      (104, 02,'Lange','Edith',' '),
                                      (105, 06, 'Wiliams','Gabriel',' '),
                                      (106, 23, 'Duzak','Mario', ' '),
                                      (107, 02, 'Diante','Venite', ' '),
                                      (108, 06, 'Wiesenbach','Joni',' '),
                                      (109, 04, 'Travis','Brett', ' '),
                                      (110, 15, 'Genkazi','Stan', ' ');
                                      
INSERT INTO [dbo].[PILOT] VALUES (100, ' ',' ',' '),
                                 (101, ' ',' ', ' '),
                                 (102, ' ',' ', ' '),
                                 (103, ' ',' ', ' '),
                                 (104, ' ',' ',' '),
                                 (105, ' ',' ',' '),
                                 (106, ' ',' ', ' '),
                                 (107, ' ',' ', ' '),
                                 (108, ' ',' ',' '),
                                 (109, ' ',' ', ' '),
                                 (110, ' ',' ', ' ');
                                                                       
INSERT INTO [dbo].[MECHANIC] VALUES (100, ' ',' '),
                                   (101, ' ', ' '),
                                   (102, ' ', ' '),
                                   (103, ' ', ' '),
                                   (104, ' ',' '),
                                   (105, ' ',' '),
                                   (106, ' ', ' '),
                                   (107, ' ', ' '),
                                   (108, ' ',' '),
                                   (109, ' ', ' '),
                                   (110, ' ', ' ');  
                                   
INSERT INTO [dbo].[ACOUNTTANT] VALUES (100, ' ',' '),
                                   (101, ' ', ' '),
                                   (102, ' ', ' '),
                                   (103, ' ', ' '),
                                   (104, ' ',' '),
                                   (105, ' ',' '),
                                   (106, ' ', ' '),
                                   (107, ' ', ' '),
                                   (108, ' ',' '),
                                   (109, ' ', ' '),
                                   (110, ' ', ' ');                                                              
                                        
            select * from Tablacincouno                                                                     
            select * from DEPENDENT
            select * from PILOT
            select * from MECHANIC 
            select * from ACOUNTTANT


run \| edit \| history \| help	0