27 Aug '12

Shiva Prasad

Hello all, I am collecting resources from different sources and Our freelance developers are developing VB.Net, ASP.Net, PHP, ASP, JAVA, Android projects, C# Programming, C and C++ programming projects for IT, Diploma and engineering students.

10 Shares

Database design of College Network System

Advertisements

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

Field

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

Field

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

Field

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

Field

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

Field

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

Field

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

  • 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…………………….

  • Pingback: Social Networking Site for College Students - Student Project Code

  • 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)