Object and Data Modelling for National University Enrollment System

This assignment provides a comprehensive case study solution on object and data modelling, focusing on the development of a National University enrollment system. The solution begins with the identification and description of various use cases, including user detail storage, authentication, major selection, course management, and review processes. A detailed storyboard is created to visualize the user interaction flow within the system. The document then explains the concept of drill-down reports, emphasizing their role in exploring multi-dimensional data and enabling users to navigate through different levels of information. The discussion covers the application of drill-down functionality, its benefits in business intelligence, and its importance in creating self-service analytics. The solution also highlights the implementation of drill-down reports, the definition of data hierarchies, and the integration of the drill-down feature within the user interface. References to relevant research and studies are also included.

Running head: OBJECT AND DATA MODELLING
Object and Data Modelling
Name of the Student
Name of the University
Author’s Note

1
OBJECT AND DATA MODELLING
Table of Contents
Use case Identification and description......................................................................................2
Creation of Storyboard...............................................................................................................3
Explanation of Drill Down.........................................................................................................5
Identification and discussion of the drill down..........................................................................6
References..................................................................................................................................8

2
OBJECT AND DATA MODELLING
Use case Identification and description
For identifying the use case an analysis is made on the requirement of the
development of National University enrolment system. The following use cases are identified
that helps in developing the storyboard.
#1: Storing user details
#2: Authentication and validation of User
#3: Choose Major
#4: Selection of change
#5: Course Addition
#6: Delete Course
#7: Course Update
#8: Review Details

3
OBJECT AND DATA MODELLING
Creation of Storyboard

4
OBJECT AND DATA MODELLING

5
OBJECT AND DATA MODELLING
Explanation of Drill Down
The development of the drill down report allows the user to navigate through different
layers by clicking the specific elements of an application available in the web page. It helps
the user to explore the multidimensional data while navigating from a primary level to a
detailed level. The users can view hierarchical, aggregated and data summary for specific

6
OBJECT AND DATA MODELLING
analysis of the data (Gómez et al., 2017). OLAP can be used as the key function of the drill
down and enabling users to answer complex multi-dimensional queries. OLAP also enables
management of complex multidimensional queries of data and enables navigation form
different layers with a single click made on the data elements and using similar windows for
visualization. From the user perspective the drill down is present with the GUI where the user
can click on the representation of data for reaching to the final level (Moussa, Haddad &
Bejaoui, 2018). The drill down is present in most of the computer system where the users can
click on a folder for finding the specific location and similar practice is used for webpage for
navigating to the deeper level. The business reporting tools also make the use of drill down
reports for enabling the capability to use the aggregated value and reveal exact level in the
hierarchy. The data that is essential for answering questions can be found.
The data can be displayed in different ways eliminating the need of creation for
dashboard and reports and it can be used for digging various layers without navigating to
visualization and analyse the data visually (Notarnicola et al., 2017). The data of different
layers can be viewed and enables garnering data rapidly. The performance of the server can
be improved with the application of drill down by displaying single layer of data at a time
period and reducing the user query.
Identification and discussion of the drill down
Drill down repot is important for implementation of a different interactive
functionality in the developed information system. Self-service analytics can be used for
setting up business intelligence and provides the non-technical users the ability to create and
edit reports. It also provides them greater insights and thus improving the workflow and
decision support system. Different set of features can be used for utilizing the core and self-
service for team and data development. It can help in increasing the reliability and simplicity
for managing the data from the user view point (Shortell, 2015). It is important to create a

7
OBJECT AND DATA MODELLING
comprehendible layer of data and define different platform with the use of metadata layer.
The complex database structure and their names is needed to be replaced with the layers of
metadata for the creation of information business view.
The functionality of the drill down is applicable to the business view for defining drill
down functionality report. It also helps in defining the hierarchy for the data related with each
other and different formulas can be used for fetching data without any format and
structuration. The hierarchy is defined such that the report utilizing the business view can be
utilized for enabling the drill down functionality (Wallace et al., 2017). The application of the
drill down also saves the time of development if it is compared with generating codes with
manual coding.
Permission is defined for enabling self-service and management of security needs in
the information system development. The integration of single sign technology helps in
managing internal permission and develop the university enrolment system with the details of
all of the system. The data that is not needed to be displayed to all of the user is identified and
manipulated such that a relationship between the database hierarchy is maintained. In the
condition for the student enrolling with the information system the course details are needed
to be available to the user and the student can view the other available information after
successfully registering with the information system (Moussa, Haddad & Bejaoui, 2018). The
views ins needed to be managed and the report view is needed to be manipulated for
maintaining the hierarchy. Multi-dimensional array can be used for exploring and navigating
the general level to the next level. Thus the integration of the drill down with the user
interface helps the user to click on the interface and representing it to the finer level.

8
OBJECT AND DATA MODELLING
References
Gómez, A., Mendialdua, X., Bergmann, G., Cabot, J., Debreceni, C., Garmendia, A., ... &
Trujillo, S. (2017, July). On the opportunities of scalable modeling technologies: An
experience report on wind turbines control applications development. In European
Conference on Modelling Foundations and Applications (pp. 300-315). Springer,
Cham.
Moussa, R., Haddad, A., & Bejaoui, T. (2018, November). The Quest for Scalable and
Intelligent Trajectory Data Analytics Systems: Status Report and Future Directions.
In 2018 International Conference on Smart Communications and Networking
(SmartNets) (pp. 1-6). IEEE.
Notarnicola, B., Sala, S., Anton, A., McLaren, S. J., Saouter, E., & Sonesson, U. (2017). The
role of life cycle assessment in supporting sustainable agri-food systems: A review of
the challenges. Journal of Cleaner Production, 140, 399-409.
Shortell, T. M. (Ed.). (2015). INCOSE Systems Engineering Handbook: A Guide for System
Life Cycle Processes and Activities. John Wiley & Sons.
Wallace, J. C., Port, J. A., Smith, M. N., & Faustman, E. M. (2017). FARME DB: a
functional antibiotic resistance element database. Database, 2017.