CIT 111 FINAL EXAM REVIEW QUESTIONS WITH CORRECT ANSWERS| 100% verified

CIT 111 FINAL EXAM REVIEW QUESTIONS WITH CORRECT ANSWERS FIXED LENGTH FILE CORRECT ANSWER text file, each column has a fixed width DELIMITED FILE CORRECT ANSWER columns are separated by a value (delimitter) like a comma REDUNDANCY CORRECT ANSWER The same data is repeated in several places of the database. DATA INTEGRITY CORRECT ANSWER Refers to the accuracy and quality of the data RELATIONAL DATABASE CORRECT ANSWER database that works with relationships between different tables (foreign keys, primary keys, etc.) RDBMS CORRECT ANSWER Relational DataBase Management System SERVER CORRECT ANSWER Provides services to the client (i.e. a web server) CLIENT CORRECT ANSWER Requests a service from a server (i.e. a web browser requesting information from a web server) LOGICAL DESIGN CORRECT ANSWER The design of a database without regard to the physical design of the database PHYSICAL DESIGN CORRECT ANSWER A diagram of tables and columns that portrays the relationships between separate data tables- includes DBMS-specific data types, file locations, etc. ERD - ENTITY RELATION DIAGRAM CORRECT ANSWER A diagram of tables that shows the relationships between separate tables as illustrated in SQL CROW'S FEET NOTATION CORRECT ANSWER notation used to illustrate the relationships between physical design tables