Start learning 50% faster. Sign in now
The objective is to integrate city functions, utilize scarce resources more efficiently, and improve the quality of life of citizens. To improve safety and security To improve the efficiencies of municipal services. The use of Information and Communications Technology (ICT) is at the core of enhancing the city’s liveability, workability, and sustainability.
In a relational database, a foreign key is used to:
How many types of architecture we have in DBMS
Pick the odd one out.
Which of the following is used to speed up data retrieval in a relational database?
Which of the following joins returns all rows from both tables, filling in NULL values for non-matching rows?
In database management, which SQL command is used to remove a table and all its data from a database?
Which type of database backup only includes the data that has changed since the last full backup?
Which database model is based on the mathematical set theory and is the foundation of many modern databases?
Which normal form deals with the issue of transitive dependencies?
What does the term "normalization" refer to in the context of database design?