2.8.3.1 Data Files The main purpose of a database is to store and retrieve data. It consists of a collection of data that is treated as a unit. An Oracle database has a logical and physical structure. The logical layer consists of Table spaces, necessary for the smooth operation of […]
Category: Foreign Keys and Referential Integrity
Initialization Parameter Files – Introduction to Databases
2.8.3.5 Initialization Parameter Files The Oracle server must read the initialization parameter file before starting an Oracle database instance. There are two types of initialization parameter files: static parameter files and persistent parameter files. An initialization parameter file contains a list of instance parameters, the name of the database the […]
CREATE A NEW ORACLE XE 18C SAMPLE DATABASE – Introduction to Databases
2.9 CREATE A NEW ORACLE XE 18C SAMPLE DATABASE After you finish the installation of Oracle 18c Express Edition database (refer to Appendix A), you can begin to use it to connect to the server and build our database. Now let’s start to create a new Oracle 18c XE sample […]
Create an Oracle User Account for the User Schema – Introduction to Databases
2.9.2 Create an Oracle User Account for the User Schema After the default Oracle 18c XE database is connected, we need to create our customer Oracle data-base. Creating a customer database in Oracle18c XE is different from creating a customer database in the Microsoft SQL Server database management system (MDBS). […]
Create LogIn Table – Introduction to Databases
2.9.3 Create LogIn Table Now expand our user account or sample database icon, CSE _ DEPT, and we need to create and add all five Tables into this database. The first Table we need to add is the LogIn Table. Perform the following operations to create and add this Table […]
Create Other Tables – Introduction to Databases
2.9.5 Create Other Tables In a similar way, create the rest of three Tables: Course , Student and StudentCourse. Select course _ id, student _ id and s _ course _ id as the primary keys for these Tables (refer to Tables 2.14, 2.15 and 2.16). For the data type […]