- A Pangkalan Data Mariadb Bagi Sistem Pengurusan Persidangan Berasaskan Web Dihoskan Dalam Pelayan Web Apache Dengan Ala 1 (101.57 KiB) Viewed 40 times
- A Pangkalan Data Mariadb Bagi Sistem Pengurusan Persidangan Berasaskan Web Dihoskan Dalam Pelayan Web Apache Dengan Ala 2 (120.88 KiB) Viewed 40 times
- A Pangkalan Data Mariadb Bagi Sistem Pengurusan Persidangan Berasaskan Web Dihoskan Dalam Pelayan Web Apache Dengan Ala 3 (108.09 KiB) Viewed 40 times
PLEASE REFER TO IMAGE 6 FROM ABOVE (10 marks)
c) Construct an Article dass in Model architecture. Subsequenty, write a method called queryArticle () to query and return the article records listed in Table 2.
PLEASE REFER TABLE 2 FROM ABOVE
d) Construct an Article Controller class in Controller architecture. The responsibility of this controller class is to communicate with the Article class model and returns the query result from queryArticle() to the article details page in View architecture. (5 marks)
a) Pangkalan data MariaDB bagi sistem pengurusan persidangan berasaskan web dihoskan dalam pelayan web Apache dengan alamat IP 103.26.197.21. Memandangkan butiran log masuk seperti yang ditunjukkan dalam Jadual 1, ubah suai fail database.php (seperti yang ditunjukkan dalam Rajah 5), untuk menyambung ke pangkalan data conference_db dalam MySQL. The MariaDB database of the web-based conference management system is hosted in the Apache webserver with the IP address 103.26.197.21. Given the login details as shown in Table 1, modify the database.php file (shown in Figure 5) to connect to the conference_db database in MySQL. Jadual 1: Butiran log masuk Table 1: Login details Rajah 5: Fail pangkalan database php Figure 5: database . php file (5 markah/marks)
Diberi rajah perhubungan entiti dalam Rajah 6, tulis transaksi SQL untuk melaksanakan transaksi berikut: - Cari conf_name, conf_organizer, art_id dan art_title dengan art_status ialah "Accept'". - Pilih art_id terkini daripada jadual article dan gunakan art_id seterusnya sebagai art_id baharu - Kemudian, masukkan butiran artikel baharu ke dalam jadual article. - Selepas itu, masukkan butiran pengarang ke dalam jadual author_details. Anda boleh menggunakan data palsu untuk menunjukkan transaksi SQL. Given the entity relationship diagram in Figure 6, write a SQL transaction to perform the following transactions: - Find the conf_name, conf_organizer, art_id and art_title where the art_status is "Accept" - Select the latest art_id from article relation and use the next art_id as the newart_id - Then, insert a new article data into the article relation. - After that, insert the author's details into the author_details table. You can use the dummy data to demonstrate the SQL transaction. Rajah 6: conference_db Diagram Perhubungan Entiti Figure 6: conference_db Entity Relationship Diagram (10markah/marks)
c) Bina kelas Article dalam seni bina Model. Selepas itu, tulis kaedah yang dipanggil queryArticle() untuk membuat pertanyaan dan mengembalikan rekod article yang disenaraikan dalam Jadual 2. Construct an Article dass in Model architecture. Subsequently, write a method called queryArticle () to query and return the article records listed in Table 2. Jadual 2: Rekod artikel Table 2: Article Records (a 11 an nas y 616 no) d) Bina kelas Article_controller dalam seni bina Controller. Tanggungjawab kelas Controllerini adalah untuk berkomunikasi dengan model kelas Article, mengembalikan hasil pertanyaan daripada queryArticle() ke halaman article_details dalam Viewseni bina. Construct an Article_control ler class in Controller architecture. The responsibility of this controller class is to communicate with the Art icle class model and returns the query result from queryArticle() to the article_details page in View architecture. (5 markah/marks)