Dwikhi Deandra Purnianto, . (2026) PERANCANGAN ASSET 3D DAN PENGELOLAAN DATABASE PADA SISTEM DENAH VIRTUAL UPNVJ KAMPUS PONDOK LABU. Skripsi thesis, Universitas Pembangunan Nasional Veteran Jakarta.
![[img]](http://repository.upnvj.ac.id/style/images/fileicons/text.png) |
Text
ABSTRAK.pdf Download (108kB) |
|
Text
AWAL.pdf Download (685kB) |
|
Text
BAB 1.pdf Restricted to Repository UPNVJ Only Download (256kB) |
|
Text
BAB 2.pdf Restricted to Repository UPNVJ Only Download (1MB) |
|
Text
BAB 3.pdf Restricted to Repository UPNVJ Only Download (3MB) |
|
Text
BAB 4.pdf Download (207kB) |
|
Text
DAFTAR PUSTAKA.pdf Download (196kB) |
|
Text
DAFTAR RIWAYAT HIDUP.pdf Restricted to Repository staff only Download (95kB) |
|
Text
LAMPIRAN.pdf Restricted to Repository UPNVJ Only Download (3MB) |
|
Text
HASIL PLAGIARISME.pdf Restricted to Repository staff only Download (43MB) |
|
Text
ARTIKEL KI.pdf Restricted to Repository staff only Download (466kB) |
Abstract
The initial questionnaire showed that 14 of 21 respondents had difficulty finding locations on the UPNVJ Pondok Labu Campus. This project aimed to design a database schema and Entity Relationship Diagram (ERD), define Row Level Security (RLS) policies, manage initial data, create and arrange 3D assets for buildings and facilities, and apply the same location code to database records and destination objects in Unity. The work used a prototyping method involving requirements collection, initial design, inspection, and iterative improvement. The documented final schema contains 11 tables for campus data, the 2D map, administration, auditing, and analytics, connected by 10 foreign keys. Four 2D-map tables entered the final schema after development and UAT follow-up, so they are not presented as initial requirements. The complete SQL is retained as a documentation artifact and was not executed while preparing the report because it contains table-removal commands. The asset workflow covered reference photography, visual creation in the Unity Editor and Blender, prefab arrangement, Pointer creation, and location-code alignment. The results comprise 19 building assets and one Masjid facility asset, a complete 11-table ERD, an RLS design, and initial data containing 19 building entities and 311 facilities. The SQL contains no trigger definition; therefore, the report does not claim that an audit trigger is active. At the shared-product level, the final functional test passed 24 of 24 scenarios, and the combined UAT score was 81.50 percent. These results show that the author's contribution provides the visual, data-structure, and access-rule foundations for the virtual map, while field updates and mapping checks remain necessary whenever the data change.
| Item Type: | Thesis (Skripsi) |
|---|---|
| Additional Information: | [No.Panggil: 2210511131] [pembimbing 1: Ridwan Raafi’udin] [pembimbing 2: Novi Trisman Hadi] [penguji 1: Widya Cholil] [penguji 2: Kharisma Wiati Gusti] |
| Uncontrolled Keywords: | 3D asset, database, ERD, Row Level Security, virtual map |
| Subjects: | Q Science > QA Mathematics > QA75 Electronic computers. Computer science Q Science > QA Mathematics > QA76 Computer software Z Bibliography. Library Science. Information Resources > ZA Information resources > ZA4450 Databases |
| Divisions: | Fakultas Ilmu Komputer > Program Studi Informatika (S1) |
| Depositing User: | DWIKHI DEANDRA PURNIANTO |
| Date Deposited: | 02 Sep 2026 08:15 |
| Last Modified: | 02 Sep 2026 08:15 |
| URI: | http://repository.upnvj.ac.id/id/eprint/51904 |
Actions (login required)
 |
View Item |