Kashipara.com is a community of ONE million programmers and students, Just like you, Helping each other.Join them. It only takes a minute: Sign Up
Job Resume TemplateKashipara.com is a community of ONE million programmers and students, Just like you, Helping each other.Join them. It only takes a minute: Sign Up
Job Resume TemplateDatabase 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.
| Publish by | Harmanjot Singh |
| Project Name | Database |
| Upload Date | December 16, 2018 |
| Platform | SQL Database |
| Programming Language | pl/sql |
| Database | sql |
| Front end | |
| Back end | |
| Project Type | web Application |
| View | 1672 |
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.
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 other database software like Oracle or SQL. For designing the system we have used simple data flow d ... [ Download Source Code ]
Oracle 10g Express Edition Easy to retrieve data from database And easy to maintain. A dashboard website for a Life Insurance Company. Built using PHP, MySQL, HTML, CSS Login, logout, session, multilevel access, image uploads are implemented here. Features Agents can create clients Agents can only edit and delete info of the client. They creat ... [ Download Source Code ]
This program is used to display the alternate odd number of records from the given table. In that, inner query and analytic function are used. ... [ Download Source Code ]
This program fetches the alternate even number of records from a given table. In this program, inner query and analytic function are used. ... [ Download Source Code ]
This program is used to fetch last five records from a given table. With the help of inner query, I have completed this program. ... [ Download Source Code ]
