Digital Content Development For The Department_final

DIGITAL CONTENT DEVELOPMENT FOR THE DEPARTMENT

Under the guidance ofMr. M. HANDIQUE, Asst. Professor, Deptt. Of Information Technology

Presented By-

NILU DAS ABHAY KUMAR NILOTPAL CHAKRABORTY

CONTENTS Introduction System

Analysis Technologies System design and coding Database and tables Snapshots Testing Remarks and conclusion References

INTRODUCTION •Digital contents are the multimedia elements such as audio, video, graphics, animations etc. •Digital Content Creation is a modern term denoting the creation and modification of digital contents as part of the production process before presentation in its final medium.

•Digital content development is the creation, design, management and distribution of digital products and services and the enabling technologies

SYSTEM ANALYSIS DRAWBACKS

OF THE PRESENT SYSTEM

— ◦ Less efficient ◦ Error probability is more ◦ Representation is not good ◦ Cost is more ◦ High effort is required to maintain data ◦ Requires more storage capacity ◦ Human load is more

SYSTEM ANALYSIS continued.. PROPOSED

SYSTEM—

◦ Contents are represented digitally ◦ Provides security ◦ Much more reliable ◦ Representation is nice ◦ Data can be well managed ◦ Maintenance is easy ◦ Low cost ◦ Information can be easily and effectively handled over internet. ◦ Effective storage of large amount of data ◦ Less uses of hardware

TECHNOLOGIES Software

cycle

◦ Prototyping Model Architecture

◦ 3-tier Architecture Application

program

◦ HTML/ XHTML ◦ JavaScript ◦ JSP/ JSP with JDBC Database

◦ Oracle 10g

SYSTEM DESIGN Also

called top-level design

Identifies

the modules that should be in

the system Finally,

all the important data structures,

file formats, output formats and the

major modules in the system and their specifications are decided.

E-R DIAGRAM sports

Month of Exam

Magazi ne

Examinatio n

Activity

Regd. No. S_nam e Semest er

e p ap ars

Perform s

Total marks No of interna ls No. of Extern als

Semest er

conduc ts

contac ts Student

S_ID

Departme nt

has ID

N ame

E-R DIAGRAM

Email

Conta ct No ha s

Departmen t

P ost

Studen t

Regd. No.

Qualificati on s

St_nam e Associate d with

S _ID

Admissio n

take s

Staff

has

ha

Name of student admitted

St_I D

proces s Y ear

Department al Administrati on

E-R DIAGRAM

T&P Year T&P Status

Departme nt

ha s Student Placed

T&P Officer T & P Cell Highest recruiter Student Trained

E-R DIAGRAM No. of Books No. of Journal s L _ID ha s

L_nam e Librarian

has

Library

Associat ed with F_nam e

Specializati on Departmen t

ha s

Faculty Qualificati on

F _ID Designati on

E-R DIAGRAM Library

ha s

Book_nam e

Author N ame J_No

Journal s Publicati on

Book_N o

Books Author Publicati on

Detail s

E-R DIAGRAM File

F_No

categor y

ha s

Files

F_nam e

Sub_cod e

ha

L_nam e

s

s

Studen t

ha

semest er Sub_nam e

ha s

Departme nt

has

Syllabus

Credi t

Departmenta l Administratio n

u ses

L _No

Laborato ry

No. of machin es

Detail es

E-R DIAGRAM Roll_no

Studen t

check s

Result

Regn. No.

Result

Semest er

ha s

Departme nt

declares

USE-CASE DIAGRAM

USE-CASE DIAGRAM

CODING XHTML Java JSP

codes

Scripts

DATABASE AND TABLES Application

software—

◦ ORACLE 10g Architecture—

◦ 3-tier architecture Internal schema Conceptual schema External or view schema

Continued …

DATABASE AND TABLES continued..

SQL> desc DEPARTMENT Name Null? Type ----------------------------------------- -------- ---------------------------DEPT_NAME NOT NULL CHAR(50) DEPT_ID NOT NULL VARCHAR2(30) 

SQL> desc FACULTY Name Null? Type ----------------------------------------- -------- ---------------------------DEPT_ID VARCHAR2(30) FACULTY_NAME CHAR(50) F_ID NOT NULL VARCHAR2(30) POST VARCHAR2(30) QUALIFICATION VARCHAR2(50) RESEARCH_AREA VARCHAR2(200) 

DATABASE AND TABLES continued.. SQL> desc STAFF Name Null? Type ----------------------------------------- ---------------------------------DEPT_ID VARCHAR2(30) STAFF_NAME CHAR(50) STAFF_ID NOT NULL VARCHAR2(30) POST VARCHAR2(30) QUALIFICATION VARCHAR2(50) DOJ 

DATABASE AND TABLES continued.. SQL> desc STUDENT Name Null? Type ----------------------------------------- -------- -------------------DEPT_ID VARCHAR2(30) STUDENT_NAME CHAR(50) STUDENT_ID VARCHAR2(30) REGISTRATION_NO NOT NULL NUMBER(30) SEMESTER VARCHAR2(50) E_MAIL VARCHAR2(100) PHONE_NO NUMBER(15) 

DATABASE AND TABLES continued..  SQL>

desc DOCUMENT

Name Null? Type ----------------------------------------- -------- -----------------DEPT_ID VARCHAR2(30) FILE_NAME CHAR(50) FILE_NO NOT NULL VARCHAR2(30) FILE_CATEGORY VARCHAR2(30) DETAILS_ENCLOSED

DATABASE AND TABLES continued.. SQL> desc LABORATORY Name Null? Type ----------------------------------------- -------- -----------------DEPT_ID VARCHAR2(30) LAB_NAME CHAR(50) LAB_NO NOT NULL VARCHAR2(30) NO_OF_PC NUMBER(35) DETAILS_ENCLOSED VARCHAR2(1000) 

DATABASE AND TABLES continued.. SQL> desc LIBRARY Name Null? Type ----------------------------------------- -------- -----------------DEPT_ID VARCHAR2(30) LIBRARY_NAME CHAR(50) LIBRARY_ID NOT NULL VARCHAR2(30) NO_OF_BOOKS NUMBER(35) NO_OF_JOURNALS NUMBER(36) DETAILS_ENCLOSED 

DATABASE AND TABLES continued.. SQL> desc BOOK Name Null? Type ----------------------------------------- -------- -----------------DEPT_ID VARCHAR2(30) BOOK_NAME CHAR(50) BOOK_NO NOT NULL VARCHAR2(30) NAME_OF_AUTHOR CHAR(35) PUBLICATION VARCHAR2(36) 

DATABASE AND TABLES continued.. SQL> desc JOURNALS Name Null? Type ----------------------------------------- -------- -----------------DEPT_ID VARCHAR2(30) JOURNAL_NAME CHAR(50) JOURNAL_NO NOT NULL VARCHAR2(30) NAME_OF_AUTHOR CHAR(35) PUBLICATION VARCHAR2(36) 

DATABASE AND TABLES continued.. SQL> desc ADMISSION Name Null? Type ----------------------------------------- -------- ------------------------DEPT_ID VARCHAR2(30) NAME_OF_STUDENT_ADMITTED CHAR(50) YEAR VARCHAR2(30) STUDENT_ID NOT NULL VARCHAR2(35) REGISTRATION_NO NUMBER(30) 

DATABASE AND TABLES continued.. SQL> desc EXAMINATION Name Null? Type ----------------------------------------- ---------------------------------DEPT_ID VARCHAR2(30) SEMESTER NOT NULL VARCHAR2(50) NO_OF_THEORYPAPERS NUMBER(30) NO_OF_PRACTICALS NUMBER(35) TOTAL_MARKS NUMBER(35) 

DATABASE AND TABLES continued.. SQL> desc RESULT Name Null? Type ----------------------------------------- -------- -----------------DEPT_ID VARCHAR2(30) REGISTRATION_NO NUMBER(30) RESULT VARCHAR2(20) SEMESTER VARCHAR2(20) ROLL_NO NOT NULL NUMBER(20) 

DATABASE AND TABLES continued.. SQL> desc TNP Name Null? Type ----------------------------------------- -------- -----------------DEPT_ID VARCHAR2(20) TNP_YEAR NOT NULL NUMBER(20) TNP_STATUS VARCHAR2(20) STUDENTS_TRAINING NUMBER(20) STUDENTS_PLACED NUMBER(20) HIGHEST_RECRUITERS VARCHAR2(20) 

SNAPSHOTS

Figure: Snapshot for

SNAPSHOTS

Figure: Snapshot for Teaching &Nonteaching Staff

SNAPSHOTS

Figure: Snapshot for

SNAPSHOTS

Figure: Snapshot for Digital

SNAPSHOTS

Fig:5 Snapshot for Retrieval for Faculty

SNAPSHOTS

Figure: Snapshot for Faculty Information after result of Query

TESTING Software testing is the execution of the software with actual test data. TYPES— ◦ Unit ◦ Integration ◦ System ◦ Acceptance

TESTING continued.. METHODS—

◦ White box testing ◦ Black box testing USED—

◦ White box testing

REMARKS & CONCLUSION This

developed

digital

content

representation system increases the storage capacity. All

the information can be handled

easily and with effective cost. As

multimedia

representation attractive.

is of

included, data

is

the very

REFERENCES 

www.uohyd.ernet.in



dli.iiit.ac.in



www.greenstone.org



en.wikipedia.org/wiki/Content_management



www.bitpipe.com/tlist/Content-Management.html



Gustafson, D.2002. Software Engineering, TMH.



Godbole,A ;Kahate,A. 2004, Web Technology, Second Edition, TMH

THANK YOU!!