How do I do this Task 1 Create an Oracle APEX account using

How do I do this?:

Task 1: Create an Oracle APEX account using the instructions provided.

Task 2: Upload the SQL Script file “Hotel DB – Week10.sql” into your Oracle APEX account using “SQL Scripts” tool in your account.

Task 3: Create the following schema in your APEX account using SQL workshop.

w10 programs w10 student program id program name w10 course course code course_name course_level program_id course_details student_name birth date email student address program id (F w10 grade student no (FK) course code (FK) grade

Solution

Task 1:

Please Follow Steps to create Account in Oracle Apex Workshop
1. Log in to Oracle Application Express Administration Services and Click Manage Workspaces
2. Select Manage Developers and Users in Manage Workshaces .Click Create after the Manage Developers and Users page appears.
3. Under User Attributes, enter the appropriate information
4.Under Password, type a case-sensitive password for this account.Please check Password Policies before.
5.Under Account Control two options are available.
   1. Account Availability - Select Unlocked to enable a user to log in to this account. Select Unlocked to enable the account to be used.
   2.Require Change of Password on First Use - Select Yes to require the user to change the password immediately after logging in with the current, temporary password.
6.Click Create User or Create and Create Another

Task 2:

The SQL Scripts functionality allows you to create, upload, and run SQL scripts that insert data into the database.
1. OPen Database Schema Service and click on SQL WorkShop and then SQL Scripts
2. create or upload SQL script .
3. if upload select the respective file and click on Run icon to execute the file.

Task 3:

Follow the script for the given schema

/****** Object: Table [dbo].[w10_Grade]    Script Date: 10/20/2016 17:57:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[w10_Grade](
   [Student_No] [int] NOT NULL,
   [Course_Code] [int] NULL,
   [grade] [nchar](10) NULL,
CONSTRAINT [PK_Grade] PRIMARY KEY CLUSTERED
(
   [Student_No] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [UQ_grade_gradecode] UNIQUE NONCLUSTERED
(
   [Course_Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
-----------------------------------------------------------------------------------------------------------------

/****** Object: Table [dbo].[w10_Student]    Script Date: 10/20/2016 17:57:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[w10_Student](
   [student_no] [int] NULL,
   [student_name] [varchar](50) NULL,
   [birth_date] [varchar](10) NULL,
   [email] [varchar](50) NULL,
   [student_Address] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[w10_Student] WITH CHECK ADD FOREIGN KEY([student_no])
REFERENCES [dbo].[w10_Grade] ([Student_No])
GO
---------------------------------------------------------------------------------------------------------

/****** Object: Table [dbo].[w10_course]    Script Date: 10/20/2016 17:58:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[w10_course](
   [course_code] [int] NULL,
   [course_name] [varchar](50) NULL,
   [course_level] [varchar](50) NULL,
   [course_details] [varchar](50) NULL,
   [program_id] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
   [program_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[w10_course] WITH CHECK ADD FOREIGN KEY([course_code])
REFERENCES [dbo].[w10_Grade] ([Course_Code])
GO

----------------------------------------------------------------------------------------------------------
/****** Object: Table [dbo].[w10_programs]    Script Date: 10/20/2016 17:58:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[w10_programs](
   [program_id] [int] NULL,
   [program_name] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[w10_programs] WITH CHECK ADD FOREIGN KEY([program_id])
REFERENCES [dbo].[w10_course] ([program_id])
GO