SQL Import


SQL Import

SQL Import is a Wintempla tool to create a GUI from a SQL script. SQL Import creates the GUI elements, and writes the respective SQL/C++ code. UseSQL ImportSQL Import in a Dialog, Window or Web application to create a starting point and save time. SQL Import will work best when:
  1. The SQL script is correct
  2. The SQL script has CREATE TABLE statements
  3. The primary key is composed of only one column
  4. The primary key is an integer value
Once SQL Import has created the GUI and written the code, the programmer may review and edit the project.

SQL Web Page

It is possible to insert a Web Page specifically tailored for SQL. From the menu use the option Tools > Add Wintempla Item... > SQL Web Page . In previous versions of Wintempla, you must use: Project > Add New Item... .

Problem 1
Edit the university.sql file to match the database diagram shown below.

universityDiagram

classroom_table

course_table

department_table

period_table

professor_table

time_block_table

Problem 2
Create a Wintempla Application called UniMng to manage the university database (You may use the Wintempla Database Application wizard to start your project). The software is targeted to: Professors, Administrators and students. Points to evaluate:
  1. Select (view), Delete, Insert, Edit departments
  2. Select (view), Delete, Insert, Edit professors
  3. Select (view), Delete, Insert, Edit courses
  4. Select (view), Delete, Insert, Edit periods
  5. Select (view), Delete, Insert, Edit time blocks
  6. Select (view), Delete, Insert, Edit time classrooms
  7. Select (view), Delete, Insert, Edit time schedules (assign a course to a professor in a classroom for a specific period of time with a time block
  8. Print
  9. Copy to clipboard
  10. Export to Microsoft Excel
  11. Organization (easy to navigate and use)
  12. Students do not need to login to see the schedule (as soon as the application opens, it shows the schedule)
  13. Administrators need to login to modify the schedule
  14. Professors see only the schedule of the courses they have assigned
  15. Plus or extra: error notification (for instance one professor is not teaching any class), number of teaching hours per week per professor, two or more professors are at the same time in the same place, ...

Problem 3
Create a Wintempla Web application called UniWeb to manage the university database. Points to evaluate:
  1. Select (view), Delete, Insert, Edit departments
  2. Select (view), Delete, Insert, Edit professors
  3. Select (view), Delete, Insert, Edit courses
  4. Select (view), Delete, Insert, Edit periods
  5. Select (view), Delete, Insert, Edit time blocks
  6. Select (view), Delete, Insert, Edit time classrooms
  7. Select (view), Delete, Insert, Edit time schedules
  8. Organization (easy to navigate and use)
  9. The web application is published in a web server

© Copyright 2000-2019 Wintempla selo. All Rights Reserved. Sep 05 2019. Home