Question

A Pages entity in a relational database for tracking web browsing has the following attributes: PageID (the primary key, an integer number, required), PageURL (text, maximum 255 characters, required), IPAddress (text, maximum 15 characters, required), ViewDateTime (date and time the page was viewed, required).

(a) Write an SQL Data Definition Language command to create the table for this entity.

(b) Write an SQL Data Definition Language command to add a column for a new attribute to this table: ViewDuration (duration in seconds that the page was viewed, an integer number, required).

(c) Write an SQL Data Definition Language command to remove this table from the database

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

This demonstration is using Oracle SQL Live.

Question 1:

SQL Query :

create table Pages(
PageID number primary key not null,
PageURL varchar(255) not null,
IPAddress varchar(15) not null,
ViewDateTime date
);

**************************

Question 2:

SQL Query :

alter table Pages add ViewDuration number not null;

*****************************

Question 3:

SQL Query :

drop table Pages;

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.