[TYPE THE COMPANY NAME]
Exam
(elaborations)INF370
3 Assignment 2
(COMPLETE
ANSWERS) 2024 -
DUE 28 June 2024•
Course• Databases
II - INF3703
(INF3703)•
, Institution•
University Of South
Africa• Book•
Principles of
Database
Management
[Type the document subtitle]
tabbymwesh59@gmail.com
[Pick the date]
[Type the abstract of the document here. The abstract is typically a short summary of the contents of
the document. Type the abstract of the document here. The abstract is typically a short summary of
the contents of the document.]
, Exam (elaborations)
INF3703 Assignment 2 (COMPLETE ANSWERS) 2024 -
DUE 28 June 2024
Course
Databases II - INF3703 (INF3703)
Institution
University Of South Africa
Book
Principles of Database Management
INF3703 Assignment 2 (COMPLETE ANSWERS) 2024 - DUE 28 June
2024 ;100 % TRUSTED workings, explanations and solutions. ...........
Question 1 [30] As stated in the case, Skyworth follows the Systems
Development Life Cycle (SDLC) (see page 529 of Coronel et al., 2020) to
design information systems for their clients. In the planning phase, the
database design and development team conducted a feasibility study to
address, amongst others, the technical aspects of hardware and software
requirements (see page 530 Coronel et al., 2020). The database architect3 ,
Sanjay Kumar, promoted the Oracle Database 21c Express Edition and SQL
Developer Tool to be deployed to design the database for the POS project.
Sanjay instructed you to install and prep Oracle 21C for the physical design by
performing the required configurations and troubleshooting. 1.1. You installed
the Oracle Database 21c Express Edition for Windows x64 and the SQL
Developer tool.
1.1.1. Using SQL Plus, connect the SYS administrator account to the
container database. Capture a screenshot showing only the necessary details,
such as connection message and relevant database information. For
example: (5)
To capture the necessary details showing the connection message and relevant database
information for Oracle Database 21c Express Edition using SQL Plus, follow these steps:
