MINOR PROJECT PARTIAL PROGRESS REPORT
ON
“Project name”
SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENT FOR THE PARTIAL PROGRESS REPORT
Group no:
Name Roll no Section
DEPARTMENT OF INFORMATION TECHNOLOGY
COLLEGE OF ENGINEERING
Location
Acknowledgement
Acknowledgement is not mere formality but a genuine opportunity to thank all those people without that active support in this project would not be able to be possible.
We are thankful to Mrs.XYZ for her valuable time devoted to us and give us a lot of knowledge and help regarding our project. During our last semester in the curriculum of B. Tech. we are also thankful to our respected Head of Department Mr.ABC for their expert guidance. It is a great experience for us and we gained a lot here.
Words defeat us in expressing our deep sense of gratitude for our class mates, whose continual support and guidance enabled us all the challenges posed by this project, who provided us all the relevant information and the necessary Hardware, Software and new ideas that really helped us a lot. Special thanks are due to all other staff, Colleagues and friends for all the encouragement, inspiration and motivation.
Finally, we are thankful to the almighty God who had given us the power, good sense and confidence to complete my project successfully. We also thank our parents who were a constant source of encouragement. Their moral was indispensable.
SongsBird is developed using ASP.NET. It is a computerized, online solution for entertaining people who wish to get information about the latest music albums, movies available in India
Statement about the Problem-existing system
In basic system, people who want to have the information about the latest albums or movies which provide best entertainment had to visit music shops or refer to television for seeking the information regarding date of release etc. One has to physically move to music shops to check all details about the albums or movies available and then only they can decide and purchase those products. Moreover, most of the work involved in the process has to be done manually which is very time consuming and cumbersome and also, it reduces the efficiency, accuracy and speed of retrieval of data. It is not that no effort has been made towards this end. An attempt to get the complete working automated failed as the system could not be integrated into a functional whole. I felt this shortcoming becoming glaringly evident. A discussion with my project guide produced enthusiastic response and I decided to take the challenge. And want to do something different in my Project hopefully.
SOFTWARE REQUIREMENR SPECIFICATON
1. Scope:
This document shall provide the requirement specification for the “SONGSBIRD” as per the scope defined.
2. Users:
This site can be used by 2 types of users:
2.1. The users who are interested in searching, playing and downloading of songs.
2.2. The administrator of the system who will be responsible for the updates to be made as per the requirement like adding, updating, deleting an album in the database.
3. Assumptions:
3.1. The alerts will not be provided by the site, the user has to visit it to get the information.
4. Requirements:
4.1. Functional Requirements:
4.1.1. The portal will search for the details of the albums as per details entered by user.
4.1.2. If the user is an admin, he has to login.
4.1.3. Admin can add, modify or delete records related to various albums.
4.1.4. The user can search for albums, play and download songs.
4.1.5. The concept of Master Pages and Content Pages is used.
5. Non-functional Requirements:
5.1. Portability:
The system will be designed to be portable across popular Windows OS.
5.2. Extensibility:
The system should be extensible to add further information and users for more expansion.
5.3. Re-Usability:
The system’s code could be reused to add further new features if need to be added in future.
5.4. Reliability and Availability:
System shall be able to deliver the required in reliable manner.
5.5. Software Upgradeability:
System is to be developed in phases, so it shall be easily upgradeable to include the new items in the database.
6. User Interface Requirements:
6.1 Log in screen:
Admin has to first log in to the site.
6.2 Home page:
Home page allows user to browse through albums.
6.3 Panels:
Website is divided into 3 panels for Home page of different users:
Ø User panel
Ø Admin panel
Ø 6.3.1 User panel:
Users can browse through albums. They can get information about albums, view and play songs online and download songs.
6.3.2 Admin panel:
Administrator can update any information such as addition, modification and deletion of albums.
Data Flow Diagram:
This gives the basic idea of the project and also gives the idea of how the data will flow within a organization.
Table
Tables |
(i) Category (ii) Album (iii) Album Details (iv) Reviews (v) Videos |
Database
The various roles through which the data flows used in the project are:
1) Administrator
2) User
1 Level DFD
Diagram here of DFD
Database Files
Sr. No. | Table Name | Description |
1. | Tbcat | Information about song Categories |
2. | Tbalb | Information about the Albums |
3. | Tbalbdet | Detail of songs in an album |
4. | Tbrev | Detail of reviews given by users |
Relations in the database for EZ-tracks
The following are the relations we have designed to manage the database. Here we have followed a convention of having the table names with tb as a prefix, and the remaining name of the table represent the description of the data inside that table.
Tbcat (Category)
Catcod | Int | PK | Code |
Catnam | varchar(50) | Not Null | Music Category |
Tbalb (Albums)
Albcod | Int | PK | Code |
Albnam | Varchar(100) | Not Null | Album Title |
Albdwnfil | Varchar(100) | Not Null | Album Download File |
Albpic | Varchar(100) | Not Null | Cover Page of album |
Albltssts | Char(1) | Not Null | Album latest status |
Albart | Varchar(100) | Not Null | Album Artist |
Tbalbdet (Album Details)
Albdetcod | Int | PK | Code |
Albdetalbcod | Int | FK | Code |
Albdetdsc | Varchar(100) | Not Null | Song Title |
Albdetfil | Varchar(100) | Not Null | Downloadable File |
Tbrev (Reviews)
Revcod | Int | PK | Code |
Revusrnam | Varchar(50) | Not Null | User Name |
Revalbcod | Int | FK | Code |
Revdat | Datetime | Not Null | Date of review |
Revdsc | Varchar(200) | Not Null | Review Desc |
BIBLIOGRAPHY
BOOKS
· Software engineering-Rajib mall
· ASP.NET Wrox publications
· Database management system KORTH
· SQL Server Microsoft Press
WEBSITES
Project guide: Mrs.XYZ
Remarks:
Post a Comment