Synopsis
Music Online
1. PROJECT TITLE
Music Online
2. INTRODUCTION
Music is probably more familiar than we might at first imagine. Indeed, nowadays it is all around us, whether it be in restaurants, supermarkets, lifts, for advertising or as theme and music on television. Hearing live music is one of the most pleasurable experiences available to human beings. The music sounds great, it feels great, and you get to watch the musicians as they create it. No matter what kind of music you love, try listening to it live. There are lots of things to enjoy at a concert, lots of things to pay attention to. You can be affected by what most appeals to you, or by whatever grabs your interest. Here are a few choices for what to listen to. Choose whatever you like, switch as often as you want, and feel free to add to the list Some things to enjoy in classical music - Moods and feelings - Loudness and softness - Different speeds - Instrument sounds - Melodies
Page No - 1
Synopsis
Music Online
- Rhythms - Changes and transformations - Beautiful performing - Memories that get triggered - Recognition of something heard earlier - Visual images that come to mind
Music Online is a web site to search the desired songs on different criteria and enjoy the melodious selected songs along with the downloading of [Link] is also a facility to upload the top ten songs by the administrator. Security is implemented, only the authorized users can login and access the facilities available in the software. There is a facility through which new users can be created with appropriate passwords and existing users can be deleted and modified by the database Administrator. Audit Trail is also maintained to know the usage of software by the various persons of the organization along with date and time.
Page No - 2
Synopsis
Music Online
3.
OBJECTIVES
The main objectives of the Online Music web site is to scrubbe, shine and polishes the website and fill it with as much color and content to keep the viewer watching and enjoy the meliduous songs The main Objectives of the project are as follows:
Music for every one, every where and any time Connection to a Database on Application for a web based development. Categoriation of songs like Sad, Romantic, Gazals, Fast Track etc. Storing all the relevant data about the Songs like Movie, Actor, Singer and category of the song.
Facility to search the song on the basis of Actor, Movie, Singer or category. Make it more environment friendly for the Music Lover. Conveniently upgraded and moderately usable. Songs uploading and downloading Video and Audio songs Facility to upload top ten songs. Song searhing and downloading of songs only for registered users. Song Audit Report
Page No - 3
Synopsis
Music Online
This package should be user friendly Required an optimal minimal input from user while providing highly relevant and focused outputs.
4. ANALYSIS
System Analysis is the main feature of the software development. It can be said that it is the heart of any of the system. The analysis needs an expert supervision & the person should be minimum System Analysts with the experience of 2 to 3 years. One can use Analysis Tools to analyze the system.
4.1 Problem Definition
A Web Site is to be designed where the user can listen the music of his own choice. This site will be used by basically three types of uers - Anonymous user - Registered User - Administrator Anonymous user is user who is not registered and he can know about the website through the various links available on the home page. He can also listen the top ten audio songs from the available list. He can also become a registered user by clicking new sign up link.
Registerd users are those users who have given their personal details by sign up. A different kind of following facilities will be given to these type of users: - Searching of songs of his/ her ineterst on various criteria.
Page No - 4
Synopsis
Music Online
- Song downloading .- View available Audio Songs
- Top Ten Songs - News and Announcements of new Music Albums - Change his Password
Admin user will manage the web site. He will enter the details of Movies, Actors, Singers, song category and song details along with uploading of audio and video songs. Administrator will perform the following tasks:
- Maintain Song details like song name, movie, actor etc. - Uploading of songs. - Uploading of top ten songs. - Uploading of Video songs - Details of new Music Album - Audit Trail Reports - For Users - For Songs
TOOLS/ PLATFORM USED
SNo. Tools/Platform 1. Platform
Description Microsoft Windows XP and .NET FRAMEWORK
Page No - 5
Synopsis
Music Online
2. 3.
Front End Back End
[Link] through C# SQLSERVER
Database is created in SQLSERVER and [Link] through C# is used as Front End to provide a GUI based user Interface. Hardware Requirement: Minimum Hardware Configuration Required SNo. Requirement 1. Operating System 2. 3. 4. 5. Software Processor Memory Hard Disk Description Microsoft Windows Server 2003/ Microsoft Windows XP and .NET FRAMEWORK Visual Studio 2005 & SQLSERVER 600 MHz Pentium III Class Processor
or above
Processor P IV recommended 1 GB ( Windows Server 256 MB, Windows XP 190MB) 20 GB ( 900 MB available space required on System Drive, 3.3 GB of available space required on installation drive for Visual Studio 2005 and additional 1.9 GB space required for MSDN Library and 1 GB for Internet Banking Software along with Database & Documentation. Super VGA (1024x768 or higher resolution display with 256 colors
6.
Display
4.2 Software Requirement Specification
Following is a template for the Requirement Specification document. Requirements are entered in to it and that would help in validating the system during testing.
No.
Requirement
Essential or Desirable
Description of the Requirement
Remarks
Page No - 6
Synopsis
Music Online
Role-USER (Registered)
RS1
The Registered Users should have a login
Essential
A login box should appear when the default page of the web site is loaded.
RS2
The User should have facility to create his own login and password to access the protected area of the web site
Essential
The user can create his login by providing his/her personal details like name, address, country, Phone, Email etc..
The login can be created by the New user Registration Facility provided in the software Unique Login must be assigned to each user.
RS3
The Registered User Essential should have the facility to change his/her password
By providing the new password, the old password will be replaced in the login table
RS4
User should have the facility to get back the passwords when he forgets the password
Desirable
User has to give his answer to the security question in case he forgets the password.
Password must be of minimum 7 characters long with at least one digit and special character. Security answer and question is given at the time of new registration of the User. None
RS5
On successful login User should be able to see the various links available to him on this site
Essential
Gets the link like Video songs, Top Ten Songs, Music searching on singer, song type, film etc along with Music Down Load. User can listen top ten audio songs.
RS6
Top Ten songs
Essential
Top Ten Songs will be loaded by the Administrator None
RS7
Video Songs
Essential
View Video Songs
Page No - 7
Synopsis
Music Online
RS8
Music Search
Essential
Search the Music on the basis of various criteria.
RS9
Music Download
Essential
Download the Music of his own choice.
- Actor Wise - Singer Wise - Song Wise - Film Wise - Category Download the songs available on the site.
RS10
Song Details
Desirable
View Details of the available songs along with the information like film, singer and song type. Categorize the songs as per following category: View News and Announcements of new Music Albums. - Sad songs - Gazals - Romantic - Fast Track
RS11
Song Categories
Desirable
RS12
News and Announcements
Desirable
Role-Administrator
RS13
Uploading of Top Ten Songs
Essential
Upload the top ten songs in the table along with the song URL.
The top ten songs will be uploaded in the separate folder Provision to update or delete Actors Provision to update or delete Singers
RS14
Entry of Actor Details
Essential
Admin can enter the Actor details like their code and name. Admin can enter the information regarding Singers Admin can enter Film Details
RS15
Entry of Singer Details
Essential
RS16
Entry of Film Details Entry of Songs Details
Essential Essential
RS17
Provision to update or delete Films Entry of the songs along Provision with singer. Actor and should be to song type. update or delete songs
RS18
Entry of Song Category Essential
Entry of song category
Provision to
Page No - 8
Synopsis
Music Online
Details
details like sad, romantic, gazal etc. Essential Input News and Announcements of the New Music Album Users Logged in between dates.
update or delete Category Provision to update or delete obsolete News Report will be generated on parameter provided by the user Report will be generated on parameter provided by the user
RS19
Entry of News and Announcements of New Music Albums Audit Trail Report
RS20
Desirable
RS21
Report
Desirable
RS22
Authorized Users List
Desirable
List of Authorized users along with their personal details. Report of top ten songs.
RS23
Top Ten Songs Report
Desirable
Role-Anonymous User
RS24
About the Music Site
Essential
Static page, which displays the about the Music Site User can listen top ten audio songs. The user can create his login by providing his/her personal details like name, address, country, Phone, Email etc.. Displays the address for Communication Users Queries Unique Login must be assigned to each user.
RS25
Top Ten songs The User should have facility to create his own login and password to access the protected area of the web site Contact Us Feedback
Essential Essential
RS26
RS27 RS28
Essential Essential
5. DATA FLOW DIAGRAM
Page No - 9
Synopsis
Music Online
Page No - 10
Synopsis
Music Online
Page No - 11
Synopsis
Music Online
Page No - 12
Synopsis
Music Online
Page No - 13
Synopsis
Music Online
Page No - 14
Synopsis
Music Online
Page No - 15
Synopsis
Music Online
6. DATA STRUCTURE
Table Name: UserLogin
Page No - 16
Synopsis Description: used to store user information.
Music Online
Table Name: Singer_Master Description: used to store Singer information.
Page No - 17
Synopsis
Music Online
Table Name: Song_Master Description: used to store all Music information.
Table Name: Film_Master
Table Name: Actor_Master Description: used to store Actor information.
Page No - 18
Synopsis
Music Online
ER-DIAGRAM
7. PROPOSED MODULES
Page No - 19
Synopsis
Music Online
1.
2.
Basic Data Stores User Registration Music Upload Music Search Download Music Top Ten Songs Report Generation
3. 4. 5. 6. 7.
Basic Data Stores module is basically storing the master information in the appropriate data stores. The following mster files will be maintained
-
Actor Master, Movie Master, Category Master and Singer Master
There should be provision to add, modify and delete the information from the respective data stores; Administrator has the facility to maintain these data stores. New User Registration module deals with the registration of new users to the web site. The user has to provide the personal details in order to get authorized user and password. In Music upload the songs are uploaded to the website along with complete information about the songs. Music Search is basically searching for songs on the basis of various criteria, In Download Music the Registerd users can download the songs on their local computers. Top ten songs will be uploaded by the Administrator. Reports module generated Audit Trails Reports for the users and the songs.
8. CONCLUSION
Page No - 20
Synopsis
Music Online
The proposed system is developed in SQL Server and [Link] with C#. This Softwatre will help in resolving the following issues or problems in the existing manual system.
Easy to Locate or find a particular information regarding songs like his singer or movie of the song.
Security to download the songs. Easy to search the songs of your own choice. Listen top ten audio songs. Genearte the list of songs played between dates Generate List of users who have used the web site.
Music Online is a web site to search the desired songs on different criteria and enjoy the melodious selected songs along with the downloading of [Link] is also a facility to upload the top ten songs by the administrator.
This Software provides a user-friendly interface for the user and it reduces the data redundancy. Centralized information is available which can be accessed by number of users.
Page No - 21
Synopsis
Music Online
BIBLIOGRAPHY The books, which I will refer in building this software, are as follows: The books, which I will refer in building this software, are as follows: [Link] Beginning [Link] 2.0 & Databases by John Kauffman & Bradley Millington
(Wrox Publication)
murachs [Link] 2.0 by Deug Lowe & Joel Murach Crystal Report 9 by Cate McCoy and Gord Maric
SQLSERVER Microsoft SQL SERVER by Richard Waymine & Rick Sawtell SQL SERVER Black Book by Janathan Gennick, Gerrit-Jan Linker
Software Engineering Software Engineering Beginners Approach An Integrated Approach to Software Engineering
Page No - 22
Synopsis
Music Online
8. LIMITATIONS: 1. Because of using the Graphical User Interface the output or the quality of the reports are very good but are slower and costly to print.
2. Although we have given required field validations but immense care has to be taken while entering the data because any mistakes in entering the data in any of the fields might result in innumerable numbers of mistakes in the reports generated.
3. The provision of consolidated yearly salary printing is not there in the proposed system but it can be developed and implemented in later stages. The personal and other information like leaves and salary increment of the employees can be displayed on the Web pages on the Internet, so that the information can be accessible in all branches of the company. For the present this feature is not available in the proposed package, but it can be implemented in the near future.
4.5 Data Structures
Program structure is the field structure of each module. Data Structure is used to specify the Records of the forms. Primary key and the other relations among the tables are also based on the data structure. We are using a database of ORACLE with user sample and Password project.
Page No - 23
Synopsis
Music Online
We have applied the constraints at the backend to do less validation in the front end. The descriptions of the tables of Database are as follows Table Name : Name Deptno DName Table Name : Name DESIGCODE DESIGDESC Table Name : Name EMPNO ENAME Address Phone HIREDATE SAL DEPTNO DESIGCODE QUALIFICATION EXPERIENCE EMPSUMMARY Department Data Type Varchar Varchar Desig Data Type Varchar Varchar Employee Data Type Number Varchar Varchar Number Date Number Varchar Varchar Varchar Number Varchar Size 4 20 20 15 10 4 4 20 5,2 100 Constraints Primary Key Not Null Description Employee Id Employee Name Address Phone No. HIREDATE. Salary Employee Department Employee Designation Employee Qualification Employee Experience Employee Summary Size 4 25 Constraints Primary Key Not Null Description Designation Code Designation Name Size 4 25 Constraints Primary Key Not Null Description Department no Department Name
Foreign Key Foreign Key
Table Name : Name LOGIN_ID PASSWORD
Login Data Type Varchar Varchar Size 10 30 Constraints Primary Key Unique Description User Id Password
Table Name : Name EMP_ID
Salary Data Type Number Size 4 Constraints Foreign Key Description Employee Number
Page No - 24
Synopsis
Music Online
MONTH YEAR SAL_DATE PF GROUP_INSURANCE REVENUE_STAMP I_TAX BASIC DA HRA CCA S_ALLOWANCE LAMOUNT1 LAMOUNT2 GE_AMOUNT GD_AMOUNT NET_AMOUNT
Number Number Date Number Number Number Number Number Number Number Number Number Number Number Number Number Number
2 4 6 6 6 6 8 8 8 8 8 8 8 10 10 10
Month YEAR SAL_DATE PF GROUP_INSURANCE REVENUE_STAMP I_TAX BASIC DA HRA CCA S_ALLOWANCE LAMOUNT1 LAMOUNT2 GE_AMOUNT GD_AMOUNT NET_AMOUNT
Table Name : AUDITTRAIL Name USER_ID DT TIME STATUS Data Type Varchar2 Date Varchar2 Varchar2 Size 20 2 20 30 Constraints Foreign Key Description User Id Date of Login Time of Login Status
Table Name : Leave_Master Name Leave_Type Leave_Desc Data Type CHAR VARCHAR2 Size 2 20 Constraints Primary Key Not Null Description Leave Type Leave Description
Table Name : Leave_Balance Name Employee_id OPBALCL OPBALML OPBALEL TOTCL TOTML TOTEL Data Type NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER NUMBER Size 4 3 3 3 3 3 3 Constraints Foreign Key Description Employee ID Opn Balance CL Opn Balance ML Opn Balance EL Total CL Total ML Total EL
Page No - 25
Synopsis
Music Online
Table Name : Leave Name Employee_id Leave_Type Leave_From Leave_To Duration Data Type NUMBER CHAR DATE DATE NUMBER Size 4 2 3 Constraints Foreign Key Foreign Key Description Employee ID Leave Type Leave from Leave To Duration
5. SECURITY
Only authorized users can open the software and they have controlled access on the various options of the software as per the security level assigned to them.
Software
Security Level 1
Security Level 2
Security Level 3
Security Level 1
Security Level 2
Security Level 3
Admin Option is only available to the Users having NIL Security Level. In admin option the facility is given to add new users, change the passwords of the existing users, delete the expired users and view authorized user list along with their passwords. In Low security level the users have limited access to view certain reports.
Page No - 26
Synopsis
Music Online
This way in the proposed software there is two levels of security, one only authorized users can use the software and the second the authorized users have different levels of permission on the options of the software.
6. PROJECT SCHEDULING Gantt charts (developed by Henry L. Gantt) are project control techniques that can be used for several purposes, including scheduling, budgeting and resource planning. A Gantt chart is a bar chart, with each bar representing an activity. The bars are drawn against a time line. The length of each bar is proportional to the length of time planned for the activity. We have to estimate the number of weeks required for each of the seven tasks as follows 1. Analysis 2. Design 3. Coding 4. Testing 5. Implementation
6.
2 Weeks 2 Weeks 6 Weeks 2 Weeks 1 Week 1 Weeks 15 Weeks
Maintenance Total
Activity Analysis Design Coding Testing Implementatio n Maintenance
2 3
4 5
6 7
10
11
12
13
14
7. FUTURE SCOPE
Page No - 27
Synopsis
Music Online
END USER SUPPORT The proposed system is developed in Oracle Server and Visual basic. If proposed company increases engineers it just has to add more machines and install the client software on it, which is in the form of EXE.
SECURITY There are basically three level of Security low, medium and high. The high level security users have to fill the ACR Reports, handle top management queries and reports.
Users having Medium Level of Security has to do all the data entry part regarding employees personal details, their job experience, educational qualification, leave taken etc.. .
Low Level Security Users has to handle day-to-day inquiries like when the next increment due, contact person details and leave balances.
LARGE DATABASE SUPPORT SQL Server supports large databases. This means it can support large number of complaints without delay in query process.
UNLIMITED USERS The proposed on line complaint monitoring system can support unlimited number of users. A number of engineers can simultaneously fill their call report through this software.
8. LIMITATIONS: 4. Because of using the Graphical User Interface the output or the quality of the reports are very good but are slower and costly to print.
Page No - 28
Synopsis
Music Online
5. Although we have given required field validations but immense care has to be taken while entering the data because any mistakes in entering the data in any of the fields might result in innumerable numbers of mistakes in the reports generated.
6. The provision of consolidated yearly salary printing is not there in the proposed system but it can be developed and implemented in later stages. The personal and other information like leaves and salary increment of the employees can be displayed on the Web pages on the Internet, so that the information can be accessible in all branches of the company. For the present this feature is not available in the proposed package, but it can be implemented in the near future.
5.3 Process Logic of Each Module5.3.1 Master File Maintenance Process:The following Master Files will be created in this process. Login (To store Login And Password for various users)
Page No - 29
Synopsis
Music Online
o
o
Department (To Store department code and their description) Design (To store designation code & description) Branch (To store various branch code & their description)
All the master files have the the following functions: Adding a New Record: Make a connection with the ORCL database. Make a record set of department table. Add the Record with proper validation i.e. deptno should be unique,
DNAME should not be blank. Save the record
Deleting the Record: Locate the existing record for deletion. After deleting the record move to the next record. Refresh the database.
Modifying the Record: Locate the existing record for modification. Update the record after modification. Refresh the database.
Navigation on the Record Set (Table) Provision for moving to the First Record Provision for moving to the Next Record Provision for moving to the Previous Record Provision for moving to the Last Record
Page No - 30
Synopsis
Music Online
Validation Checks If by pressing the Previous Button again and again the user reaches to the BOF then you should set the pointer to the first record. Similarly if by pressing the Next Button again and again the user reaches to the EOF then you should set the pointer to the last record.
5.3. 2 Employee Registration Process: In this particular process the related data will be entered in the following tables Employee Table This stores the personal details of the employees like employee no, employee name, department, designation, address for communication, phone nos, email, qualification, years of experience, experience summary.
There should be a provision to create a New Record, Modify the record, and delete the record in all the tables mentioned above. Validations Table Employee Emp_id Must be Unique Emp_dept Must exist in Department Table Emp_desig Must exist in Design Table 5. 3. 3 Salary Administration: Salary details information was available only with account departments. Personal department maintains the annual increment due of all the employees along with the following details.
Page No - 31
Synopsis
Music Online
Employee Number, Basic, Grade, DA, HRA, CCA, Special Allowance, PF, VPF, Loans Taken, Total Earning, Deductions, Net Salary Total Earning = Basic + Da + HRA+CCA+ Special Allowance Total Deductions = PF+VPF+Loans Net Salary = Total Earning Total Deductions
5 .3. 4 Top Management Queries: The following type of Queries required by the top management: - Dept wise Employee Personal Details - Qualification Wise Employee Personal Details - Experience Wise Employee Details - Salary Details of particular employee - Personal details of selected employee Information is fetched from tables on selected parameters. 5.3.5 Report Generation: The following type of reports will be generated: -
1. Employee Detail This report is based on the personal details of the employees who are working in our organization. You can print the details of the employees of a particular range. The output of the report can be sent to file or printer. 2. Department List This prints the details of the department available in the organization. The output of the report can be sent to screen, file or printer. 3. Designation List This prints the details of the designation available in the organization.
Page No - 32
Synopsis
Music Online
The output of the report can be sent to screen, file or printer.
4. Salary Report: This gives the employee id, name, basic, DA, HRA, CCA, PF, ITAX, Special Allowance, Loan Amount1, Loan Amount2, Total Earning, Total Deduction and Net Salary This is basically department wise Salary detail report. Department wise total salary is also calculated in this report. Total Earning = BASIC + DA+ HRA+ CCA+ Spl. Allowance Total Deduction = PF+ VPF+ITAX+Loan Amount1 + Loan Amount 2 Net Salary = Total Earnings Total Deductions
5. Audit Trail: For the security reason, we are maintaining the log of various users along with the date and time they have used the PIS Software. The following information is stored in the Audit Trail data store. User Name, Date, Time, Remarks The Audit Trail report can also be generated from the above mentioned table.
5.4 Input/Output Screens Input Screens are designed using Visual Basic Windows Forms. Proper Validations are applied on the Validate Event and the Lost Focus Event of the appropriate Controls. The Output Reports are generated using the Crystal Report tool given in Visual Basic. The detailed Input and Output Screen are enclosed in the Annexure (I)I
Page No - 33
Synopsis
Music Online
6. CODING In this software we have used Visual [Link] Programming language as a front end and ORACLE RDBMS as a back end. Mostly the data input screens are designed using ADO object connectivity. Reports are made using Crystal Report and ODBC Environment is used to provide the connectivity with the database object. For parameter passing reports we have made the connection using Microsoft ADO Object library 2.0. We have used a single connection with the ORACLE database and it is mentioned in the startup module by making a main procedure.
Hardware Requirement As this project can be implemented in LAN also by doing slight modification in the connection string defined in the various forms and we have to create DSN. If we have to implement it on Network we require Server as well as Client. In our case we implemented it on standalone machine.
Server: Intel Pentium IV with 256 MB RAM & 20 GB HDD Software: Windows XP, Oracle 8 Server
Client
: Intel Pentium III with 128 MB RAM & 20 GB
HDD
Page No - 34
Synopsis
Music Online
Software
: Windows 2000 Professional Client and Oracle 8
Client
Database is created in Oracle 8 and Visual basic is used as Front End to provide a GUI based user Interface. The project coding is enclosed in Annexure (II) 7. TESTING In this section we have tested our system in different modes. Thorough testing is required to run the project at client end successfully. We prepared a number of test cases and input the data from the developed software and saw their impact in the final reports for example let us take a case when the employee joins the company. First we record the personal details, Qualification, previous working experience and salary details. After entering the records we generated various reports and queries and check the impact of the data on the reports. . This was the simple case then we took a little bit complicated by giving various level of security to the users and then see the impact on the MDI forms options. In this way we tested the entire software thoroughly.
Test Case I Let us take a case when the Employee is hired in the organization and his information is to be entered through input forms and must be stored in the employee table and qualification in the qualification table. We have entered the basic salary of some employees and then take out the salary slip and other reports and found ok as per our manual calculation.
Page No - 35
Synopsis
Music Online
Test Case II After entering the data through input screens, we have generated all the reports and match the query results with that of manually prepared reports and answers of the queries to check the validity of computerized Reports and queries. We found them 100 % correct.
Test Case III We invoked the software with different users at different times and dates and then printed the Audit Trail report and found it satisfactory.
8. SYSTEM IMPLEMENTATION On server, we have to run a SQL script named [Link]. This will generate all the required tables to run the software in the Oracle database on the server. The contents of the script are as follows. 8.1 Database Creation Script Login to oracle SQL with the following login and password: Login Password And now run [Link]. The script is enclosed in Annexure (III) : Sample : Project
Then we can run the setup file available in the CD to install the software in the appropriate directory.
8.2 Backup & Recovery
Page No - 36
Synopsis
Music Online
The Database Administrator (DBA) will take backups at regular intervals. The backup of data is taken by export utility which creates a DMP file consisting of table structures, data, grants, views and other data base objects like procedures, functions and triggers.
The backups can be restored at the time of crash using Import utility. This recovers the entire information from the DMP file.
5. SYSTEM DESIGN
Designing of this software is done with high cohesiveness, i.e. there is a minimized interaction between two different modules. There is no intra modular relationship between modules. Most of the modules are self-independent. At the same time modules are loosely coupled i.e. inter modular relation exists. Hence the Software is loosely Coupled and Highly Cohesive.
Designing part includes its Data Flow Diagrams, Database Tables, Process logic of each and every module, Input design and Output design. Input design includes input screens such as user login screen, Employee registration screen and password inquiry screen etc. and Output design includes output screens such as Balance leave screen and output Reports.
Page No - 37