27 Aug '12

Shiva Prasad

A collection of source codes that I wrote in VB 6.0, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone.

Database design of College Network System

This document covers Database design of College Network System. A database is an inherent collection of data with some inherent meanings, designed, built, and populated with data for a specific purpose. The following guidelines are been followed during the database design:

  • Descriptive names for the tables, columns and indexes
  • Singular names for tables and columns
  • Proper data type for each column

This document describes the tables that are used to design the software, its attributes, data type, constraints, and relationship among these tables. The relationships among tables are defined via E-R Diagram (Entity-Relationships). A diagrammatical representation of relationships between an entity and its attributes is referred to as E-R model. ER model concentrates on the structure of the database and design of the database. ER model is mainly used in the design of the conceptual schema in database design. An entity may be an object with physical or conceptual existence. The properties that are used to describe the entity are called attributes. Entities that do not have key attributes of their own are called weak entity type. The relationship type that relates a weak entity to its owner is called identifying relation of the weak entity type. A weak entity type always has a total participation constraint with respect to its identifying relation.

Database name: Collegenetworking

Table name:- college

Database name: Collegenetworking

Table name:- college


Type Null Description
collegeid bigint(10) No Id of the college
collegename varchar(50) No Name of the college
collegelocation varchar(50) No Location of the college

Table name:- image


Type Null Description
imgid bigint(8) No Image Id
imagname varchar(20) No Name of the image
imgcategory varchar(20) No Image category
description varchar(50) No Image description
uploadimage varchar(25) No Path of the image

Table name:- pracdemo


Type Null Description
videoid bigint(8) No Video Id
videoname varchar(25) No Name of the video
videosection varchar(25) No Section of the video
videosubject varchar(25) No Video subject
uploadvideo varchar(25) No Path of the video
description varchar(50) No Brief description of the video

Table name:- questionanswer


Type Null Description
qid bigint(8) No Question Id
question varchar(50) No Question
answer varchar(70) No Correct answer
option1 varchar(70) No Option 1
option2 varchar(70) No Option 2
option3 varchar(70) No Option 3
option4 varchar(70) No Option 4
visible varchar(25) No If value of visible is true then user can answer for this question  otherwise not.

Table name:- questionpaper


Type Null Description
paperid bigint(8) No Question Paper Id
Papername varchar(25) No Question paper name
subject varchar(20) No Subject name
section varchar(20) No Student Section name
description varchar(50) No Brief description of Question paper
upload varchar(50) No Path of the file
uploadtext text No Uploaded text file

Table name:- studentaccount


Type Null Description
id bigint(8) No Student Account Id
firstname varchar(25) No Student First name
lastname varchar(25) No Student Last name
email varchar(30) No Student Email Id
password varchar(30) No Password
confirmpassword varchar(30) No Confirmation password
iam varchar(10) No Gender
dob Date No Date of Birth
For more project Ideas visit http://www.bestprojectsidea.com/
For Source code of all projects visit http://www.studentprojectcode.com/

Related Posts

    No posts found.

  • skano lux

    love to watch these again and again, trying to develop a social site for colleges in Ghana and all students in the world…………………….

  • Neha Shrama

    please send me full database table used in the
    College Network System….
    plz upload database……plzzzzz….

  • komal

    please send me full database table used in the
    College Network System….
    plz upload database……plzzzzz….

  • Dun

    great…..am trying to develop a social networking site for east africa universities and colleges…

  • Geetha

    i like this project. i can do. so please send me full database table used in the College Network System….
    plz upload database……plzzzzz….

  • gezeay

    please upload and send me full database table used in the
    College Network System.

  • gezeay

    please send me full documentation of the project that contains abstract, introduction,
    requirement analysis, design, implementation and testing.

  • sushila

    pleass tell me how it was overall performing how can i run this program

  • T-ghurl

    pls can i get the full documentation as in the introduction, abstract, requirement analysis, literature review, design, implementation, methodology and testing to my e-mail (timmieghurl@gmail.com)