Kashipara.com is a community of 5.00 lakh programmers and students, just like you, helping each other.Join them; it only takes a minute: Sign Up


Database project on SQL Database

SQL Database ideas     Harmanjot Singh    2018-12-16

10 Reviews
4.3



Database project features and function requirement. Share SQL Database Project ideas and topics with us. Grate and many SQL Database project ideas and topics . Here some SQL Database project ideas for research paper. Here large collection of SQL Database project with source code and database. We many idea to development application like mobile application,desktop software application,web application development. You can find more project topics and ideas on SQL Database. Development ideas on Database. You can find Top Downloaded SQL Database projects here. Many project available to download with SQL Database source code and database. Free download Database project synopsis available.


Free download Database mini and major SQL Database project source code. Download simple learning SQL Database project source code with diagram and documentations. More project with source code related to latest SQL Database projects here.


Project Topic category
Java project,demo,program ideas and topics
PHP project,demo,program ideas and topics
C# .NET project,demo,program ideas and topics
Android project,demo,program ideas and topics
VB project,demo,program ideas and topics
HTML CSS project,demo ideas and topics
Java Servlet project,demo,program ideas and topics
Python project,demo,program ideas and topics
VB .NET project,demo ideas and topics
JSP project,demo,program ideas and topics
Laravel PHP project,demo ideas and topics
IoT Raspberry Pi project,demo,program ideas and topics
C/C++ project,demo,program ideas and topics
ASP .NET project,demo,program ideas and topics
AngularJS project,demo ideas and topics
Java Spring Framework project,demo ideas and topics
Codeigniter PHP project,demo ideas and topics
Hibernate framework project,demo ideas and topics
javascript project,demo ideas and topics
Swift project,demo,program ideas and topics
Titanium project,demo ideas and topics
SQL Database project ideas and topics

Database project abstract


Posted by :  Harmanjot Singh
Project Name :  Database
Upload Date :  2018-12-16
Platform :  SQL Database
Programming Language :  pl/sql
Database :  sql
Project Type :  web Application
View :  863

Database project description



Project Create following tables: Programs: with coloumns: prCode, prName and rows: prCode prName MAD Mobile Development CDS Computer Data Systems NET Networking BDS Big Data System Course: with coloumns: courseNo, CourseName, CourseHours, CourseFees and following rows: CourseNo CourseName courseHours courseFees CDS101 Data base 3 1200 CDS102 Java programming 5 2000 CDS103 Web development 5 2200 CDS104 HTML5 3 900 CDS105 PL SQL 4 1100 CDS106 Android 5 2200 CDS107 PHP 4 1000 and create the Students table with coloumns: stNo, stName, stPrCode then you must fill names of 10 students. note that stPrCode is a foreigh key to column prCode in table programs. create a table preRequests with following columns CourseNo preReqCourseNo CDS103 CDS104 CDS103 CDS107 CDS106 CDS102 CDS105 CDS101 Create a table studentCourses with columns: stNo CourseNo This table will be filled by the program. in the program do following: 1. Enter student No. then print out in which program he is enrolled 2. Show list of names of all courses from the table courses. 3. Enter a courseName then show its hours and fees and all pre request. 4. Ask the student if want to register this course press 1 if not press 0 5. if yes then insert the studentNo. and courseNo in the table studentCourses 6. Add number of hours of the course to the hourstotal, and add coursefees to feestotal 7. Ask the user if want to register another course press 1 if not press 0 8. if yes repeat from step 2 to 7 9 if not print out list of courses the student registered in and total number of hours and total of fees. Note: Dont allow any student to register more than 17 hours. Dont allow the student register the same course more than once Dont allow register the course and its pre requests.

You may like this projects

Latest SQL Database Project Source Code


Bus Reservation System project in SQL Database

4.33

This project is designed to meet the requirements of a Bus reservation system. It has been developed in the database has been built in PL/SQL only, keeping in mind the specifications of the system. Apart from MS-Access we could have also implemented ...

  saha2011suman   2018-09-01

Mobile shop Online project in SQL Database

0

Designed to be website online shopping and best product purchase in website. Product search algorithm in use the search product that is all different-2 type product display. This website designing very good format of combination color choose. It is u...

  gvnpatidar   2017-01-02

structured qurey language project in SQL Database

1

SQL   is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). Originally based upon...

  saphal.v.nath   2015-09-25