Create Relationships among Tables – Introduction to Databases
2.9.6 Create Relationships among Tables Next we need to setup relationships among these five Tables using the primary and foreign keys. In the Oracle 18c Express Edition database environment, the relationship between Tables can be set by using the Property wizard under each Table. Now let’s begin to setup the relationship between the LogIn and…
Explore MoreCreate Relationship between LogIn and Student Tables – Introduction to Databases
2.9.6.2 Create Relationship between LogIn and Student Tables In a similar way, you can create a foreign key for the LOGIN Table and setup a one-to-many rela-tionship between the STUDENT and LOGIN Tables. Perform the following operations to setup this relationship between the LOGIN and STUDENT Tables: 1) Click on the LOGIN Table under our…
Explore MoreCreate Relationship between Student and StudentCourse Tables – Introduction to Databases
2.9.6.4 Create Relationship between Student and StudentCourse Tables The relationship between the STUDENT and the STUDENTCOURSE Tables is one-to-many, the STUDENT _ ID in the STUDENT Table is a primary key and the STUDENT _ ID in the STUDENTCOURSE Table is a foreign key. FIGURE 2.32 The finished foreign key for the COURSE Table (Copyrighted…
Explore MoreStore Images in the Oracle 18c Express Edition Database – Introduction to Databases
2.9.7 Store Images in the Oracle 18c Express Edition Database When building the Faculty and Student Tables in Sections 2.9.4 and 2.9.5, we need to store faculty and student images in the Oracle 18c XE database directly. Due to the image property of the Oracle 18c XE database, an image can be directly stored in…
Explore MoreStore Images in the FACULTY Table 3 – Introduction to Databases
3) Then click on the drop-down arrow on the right of the Faculty Table combo box again, select the GridView item and then drag the GridView item and place it in the Faculty _ Form window, as shown in Figure 2.45. 4) Now go to File|Save All to save all of these additions and modifications.5)…
Explore MoreStore Images in the FACULTY Table 2 – Introduction to Databases
9) Click on the OK button to continue this connection process.10) In the opened Data Source Configuration Wizard, which is shown in Figure 2.42, check the Yes, include sensitive data in the connection string radio button, since we want to keep all of these connection parameters to be used in the future in our project.…
Explore MoreStore Images in the FACULTY Table – Introduction to Databases
2.9.7.1 Store Images in the FACULTY Table To access different databases, various data providers that work as adaptors or a data drivers are needed. These adaptors provide various functions, such as connecting to a target data source and accessing, retrieving, inserting, updating and deleting data from the data source. In this book, we adopt a…
Explore MoreStore Images in the STUDENT Table 2 – Introduction to Databases
Before we can run the project to insert student images into the Student Table, we need to set up the Student _ Form as the Startup Form to enable Visual Basic to run that form first as the project runs. Perform the following operations to complete this setup: 1) Go to the Project|Oracle Image Project…
Explore MoreStore Images in the STUDENT Table – Introduction to Databases
2.9.7.2 Store Images in the STUDENT Table In a similar way, you can add all the student images into the STUDENT Table in our database, CSE _ DEPT. All student images can be found at the CRC Press ftp site in the folder Students/Images/ Students. Refer to Figure 1.2 in Chapter 1 for more details…
Explore MoreA SHORTCUT: HOW TO USE THE SAMPLE DATABASE WITHOUT BUILDING IT – Introduction to Databases
2.10 A SHORTCUT: HOW TO USE THE SAMPLE DATABASE WITHOUT BUILDING IT Refer to Appendix E to get more details on how to quickly duplicate the sample database, CSE _ DEPT, by using the Oracle SQL Developer if users do not want to build it. 2.11 CHAPTER SUMMARY A detailed discussion and analysis of the…
Explore More