Search & Filtering
Databases | SQL | Oracle | MS Access
Perform the following tasks to create the database required for the application:
Create a database for the application.
Create the required schemas in the database.
Create the required tables under each of the schemas.
Populate the tables with sample data.
Create a database for the application.
Create the required schemas in the database.
Create the required tables under each of the schemas.
Populate the tables with sample data.
Databases | SQL | Oracle | MS Access
Assume that you are an employee of a consultancy company that specializes in the analysis, design, and implementation of multimedia database systems. A client has recently approached your company with a view to implementing a multimedia database system, but they are not familiar with the development process. Provide a report explanation for your client.
CREATE YOUR OWN SYSTEM:
A.)Provide:
1.Introduction
2.Problem Statement
3.Scope of system
4.Mission statement and mission objective
5.Project limitation
B.)Provide your SQL query and rational table in order to present your system in detail to your client.
1.SQL – Create Table, Select Statement
2.Rational Table and business rules
3.ERD – Minimum 5 (Entity), Attribute, Relationship, Multiplicity
C.)Create minimum 4 interactive interface related to your title.
create your own interface to be your intermidiate between your database table and your user. By using any multimedia sofwate
CREATE YOUR OWN SYSTEM:
A.)Provide:
1.Introduction
2.Problem Statement
3.Scope of system
4.Mission statement and mission objective
5.Project limitation
B.)Provide your SQL query and rational table in order to present your system in detail to your client.
1.SQL – Create Table, Select Statement
2.Rational Table and business rules
3.ERD – Minimum 5 (Entity), Attribute, Relationship, Multiplicity
C.)Create minimum 4 interactive interface related to your title.
create your own interface to be your intermidiate between your database table and your user. By using any multimedia sofwate
Databases | SQL | Oracle | MS Access
Validate the following
a) Email ID [raja@gmail.com]
b) Password [ram12@3]
c) Date [ dd / mm / yyyy ]
d) URL [http://www.vit.ac.in]
e) Mobile Number [09334534567]
f) Landline Number [04334234567]
a) Email ID [raja@gmail.com]
b) Password [ram12@3]
c) Date [ dd / mm / yyyy ]
d) URL [http://www.vit.ac.in]
e) Mobile Number [09334534567]
f) Landline Number [04334234567]
Databases | SQL | Oracle | MS Access
Design a Simple form for User Creation
a) With username and two passwords.
b) Where both the username and password should contain at least 6 characters
c) Both the passwords should be identical.
d) Upon submitting to the database, the existence of username is checked across the database, if the username already exists display an error message and choose some other user name, else user is created.
a) With username and two passwords.
b) Where both the username and password should contain at least 6 characters
c) Both the passwords should be identical.
d) Upon submitting to the database, the existence of username is checked across the database, if the username already exists display an error message and choose some other user name, else user is created.
Databases | SQL | Oracle | MS Access
IMPLEMENT USING PHP/MYSQL
a) Create a database and some tables
b) Insert Some Values into Table
c) Update particular field
d) Select all or specific values from the table and display using Web Browser
e) Alter the table name
f) Delete the table from the database
a) Create a database and some tables
b) Insert Some Values into Table
c) Update particular field
d) Select all or specific values from the table and display using Web Browser
e) Alter the table name
f) Delete the table from the database
Databases | SQL | Oracle | MS Access
Perform the following tasks to create the database required for the application:
1.Create a database for the application. [2 marks]
2.Create the required schemas in the database. [2 marks]
3.Create the required tables under each of the schemas. [9 marks]
4.Populate the tables with sample data. [2 marks]
1.Create a database for the application. [2 marks]
2.Create the required schemas in the database. [2 marks]
3.Create the required tables under each of the schemas. [9 marks]
4.Populate the tables with sample data. [2 marks]
Databases | SQL | Oracle | MS Access
Consider the relations
EMPLOYEE(emp#, name)
5+5
10
ASSIGNED_TO(project#, emp#)
PROJECT(project#, project_name, chief)
Express the following queries in Relational Algebra
(i) Get details of employee working on both comp354 and comp345 project numbers.
(ii)Find the employee number of employee who do not work on project comp678
EMPLOYEE(emp#, name)
5+5
10
ASSIGNED_TO(project#, emp#)
PROJECT(project#, project_name, chief)
Express the following queries in Relational Algebra
(i) Get details of employee working on both comp354 and comp345 project numbers.
(ii)Find the employee number of employee who do not work on project comp678
Databases | SQL | Oracle | MS Access
Consider the following table:
Student_Subjects
StudentID SubjectCode ExamCenter
124 CS614 PVC001
455 CS001 PVC002
367 CS614 PVC001
486 CS403 PVC001
524 CS101 PVC003
657 CS614 PVC002
Question:
Use bitmap index to execute the following queries:
Select * from Student_Subjects where SubjectCode=”CS614” and ExamCenter=”PVC001”
Select * from Student_Subjects where SubjectCode=”CS001” and ExamCenter=”PVC001”
Specify each and every step including index tables, bit vectors etc.
Student_Subjects
StudentID SubjectCode ExamCenter
124 CS614 PVC001
455 CS001 PVC002
367 CS614 PVC001
486 CS403 PVC001
524 CS101 PVC003
657 CS614 PVC002
Question:
Use bitmap index to execute the following queries:
Select * from Student_Subjects where SubjectCode=”CS614” and ExamCenter=”PVC001”
Select * from Student_Subjects where SubjectCode=”CS001” and ExamCenter=”PVC001”
Specify each and every step including index tables, bit vectors etc.
Databases | SQL | Oracle | MS Access
Is it possible that date stored in database table change automatically ???
Databases | SQL | Oracle | MS Access
*Create a package EMP_PACK contain one two function and one procedure.
a) Procedure EMP_REP: accept deptno and generate same report as [ Write a PL/SQL block which accept job from the user . If there are only employees
then display the details otherwise raise an exception with proper message. If there are
more than one employees then raise an exception with the no of employees and their
names together separated by “,”. For other runtime error terminate the block showing
message. ]
b) Function BONUS: Return bonus by empno accept as parameter.
c) Function CHK_DEPTNO: accepts only deptno as parameter and return T/F to the
EMP_REP. ( Private )
a) Procedure EMP_REP: accept deptno and generate same report as [ Write a PL/SQL block which accept job from the user . If there are only employees
then display the details otherwise raise an exception with proper message. If there are
more than one employees then raise an exception with the no of employees and their
names together separated by “,”. For other runtime error terminate the block showing
message. ]
b) Function BONUS: Return bonus by empno accept as parameter.
c) Function CHK_DEPTNO: accepts only deptno as parameter and return T/F to the
EMP_REP. ( Private )
