CETS 468 Database Management
42 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which of the following best describes the term 'information technology' (IT)?

  • Technology solely used for storing information in banks and hospitals.
  • Any technology that helps to process, communicate, and store information. (correct)
  • The use of computers exclusively.
  • Technology that is used only in paperless workplaces.
  • What was the primary reason for the increasing use of IT in everyday life?

  • The rise of paperless work environments, which shifted the industry focus toward computing technology. (correct)
  • The increase in the number of large companies using computers in the 1970s.
  • The introduction of software programming in the 1960s.
  • The affordability and widespread availability of personal computers in the early 2000s.
  • Which of the following are examples of Database Management Systems (DBMS)?

  • MS Access
  • MySQL Database
  • Oracle Database
  • All of the above (correct)
  • Which of the following is NOT considered a part of Information Technology?

    <p>Robotics (A)</p> Signup and view all the answers

    What are the two main components of Information Technology?

    <p>Computer Technology and Communications Technology (A)</p> Signup and view all the answers

    What is the primary function of a Database Management System (DBMS)?

    <p>To provide a user interface for interacting with a database (D)</p> Signup and view all the answers

    In the given example, what is the role of the "Property Custodian" in the database?

    <p>To manage the inventory of materials (C)</p> Signup and view all the answers

    How can we best understand the transformation of Information Technology from the 1960s to the early 2000s?

    <p>IT transitioned from a specialized field used in a few sectors, to an essential aspect of everyday life, with computers and software playing prominent roles. (A)</p> Signup and view all the answers

    What is the significance of organizing data into tables, rows, and columns in a database?

    <p>To facilitate efficient storage and retrieval of information (A)</p> Signup and view all the answers

    What does the acronym "DBMS" stand for?

    <p>Database Management System (B)</p> Signup and view all the answers

    Which of the following is NOT a component of an information system?

    <p>Marketing (A)</p> Signup and view all the answers

    What is the primary benefit of data management in construction projects?

    <p>Improved communication between departments (A)</p> Signup and view all the answers

    Which of these is an example of a record-keeping task in data management for construction projects?

    <p>Recording the materials used on the project (C)</p> Signup and view all the answers

    What is the relationship between a system and its components?

    <p>A system can be decomposed into components (B)</p> Signup and view all the answers

    Which of the following tasks is NOT typically included in a data management exercise for construction projects?

    <p>Marketing strategy (C)</p> Signup and view all the answers

    How does data management benefit construction projects?

    <p>It helps in making decisions based on accurate information (C)</p> Signup and view all the answers

    What is the difference between data and information?

    <p>Data is raw facts, while information is processed and interpreted data (B)</p> Signup and view all the answers

    Why is it important to understand the relationship between a system and its components?

    <p>To ensure that the components work together effectively (A)</p> Signup and view all the answers

    What is a common problem faced by surveyors due to unfavorable site conditions?

    <p>Difficulty in accessing the site due to terrain (D)</p> Signup and view all the answers

    Which of the following is NOT a typical application of AutoCAD?

    <p>Analyzing financial data (B)</p> Signup and view all the answers

    What is the primary benefit of using remote sensing in surveying?

    <p>It is very cost-effective for surveying large areas. (B)</p> Signup and view all the answers

    What is the role of GIS in surveying?

    <p>It allows for the analysis and visualization of spatially referenced data. (C)</p> Signup and view all the answers

    In the context of surveying, what is the primary advantage of using AutoCAD?

    <p>It can automatically define dimensions in a drawing. (B)</p> Signup and view all the answers

    Which of the following is NOT a common problem faced by surveyors?

    <p>Lack of access to modern technology. (A)</p> Signup and view all the answers

    What is a defining characteristic of remote sensing in surveying?

    <p>It involves the acquisition of data without direct contact. (D)</p> Signup and view all the answers

    Which of the following technologies would be most helpful for creating topographic maps with elevation contours?

    <p>Both GIS and Remote Sensing (A)</p> Signup and view all the answers

    What is the primary purpose of Information Technology (IT) in project management?

    <p>To create and manage databases for storing project data. (A), To automate tasks and processes to improve efficiency. (B), To facilitate communication and collaboration among project stakeholders. (C), To analyze project data and generate reports for decision-making. (D)</p> Signup and view all the answers

    Which function is NOT directly associated with the PRIMAVERA software?

    <p>Statistical analysis of market trends. (D)</p> Signup and view all the answers

    Which of the following is NOT a basic component of an information system?

    <p>Social media platforms. (D)</p> Signup and view all the answers

    In the context of information systems, what distinguishes a message from simple data?

    <p>A message has a specific format, content, sender, and receiver. (A)</p> Signup and view all the answers

    What is the primary purpose of information management in an engineering context?

    <p>To organize and analyze engineering data to support decision-making. (B)</p> Signup and view all the answers

    According to the content, what is the key defining characteristic of a system?

    <p>A system is always composed of at least two interconnected elements. (C)</p> Signup and view all the answers

    Why is IT particularly useful for time-money analysis in project management?

    <p>All of the above. (D)</p> Signup and view all the answers

    What is the main advantage of using PRIMAVERA software in project management?

    <p>It provides a comprehensive platform for managing all aspects of the project. (D)</p> Signup and view all the answers

    What is the common thread between the job roles listed for 2014, 2019, and 2023?

    <p>These jobs are all affected by technological advancements and changing demands. (D)</p> Signup and view all the answers

    Based on the excerpt, what is a significant drawback of traditional methods in civil engineering analysis?

    <p>Traditional methods struggle to achieve the necessary level of accuracy and speed in data analysis. (C)</p> Signup and view all the answers

    Which of the following is NOT a direct benefit of using Information Technology (IT) in civil engineering design?

    <p>IT eliminates the need for physical prototypes, reducing both time and expense. (A)</p> Signup and view all the answers

    What does the term "soft prototyping" refer to in the context of IT's role in civil engineering?

    <p>Using computer models to explore different design options and test their feasibility. (C)</p> Signup and view all the answers

    How does Computer-Aided Drafting (CAD) software enhance the design process in civil engineering?

    <p>CAD allows for the creation of detailed drawings that are easier to understand and communicate. (B)</p> Signup and view all the answers

    Which of the following statements BEST reflects the impact of IT on the job market in civil engineering?

    <p>IT has significantly impacted the specific skills required for civil engineering jobs, demanding greater tech proficiency. (D)</p> Signup and view all the answers

    Which of the following is NOT a primary purpose of CAD software as described in the text?

    <p>To create designs that are aesthetically pleasing and visually appealing to clients. (A)</p> Signup and view all the answers

    What is the main implication of the statement that civil engineering has a “multi-physics character”?

    <p>Civil engineers must consider the interaction of multiple physical forces and phenomena, which is complex and often challenging. (A)</p> Signup and view all the answers

    Flashcards

    Information Technology (IT)

    IT refers to technologies that produce, manipulate, store, and communicate information.

    Computer Technology

    Technology related to computers for processing and storing data.

    Communications Technology

    Technologies that enable communication over distances, e.g., networking.

    Application of IT in Civil Engineering

    Use of IT tools to design, analyze, and manage civil projects.

    Signup and view all the flashcards

    Development of IT history

    IT evolved from a niche term in the 1960s to essential in everyday life.

    Signup and view all the flashcards

    Wage Disparity

    The difference in earnings based on skill levels; high skills lead to high wages.

    Signup and view all the flashcards

    Information Technology in Civil Engineering

    IT helps manage complexity in civil engineering through data modeling and analysis.

    Signup and view all the flashcards

    Soft Prototyping

    Creating a 3D computer model of a design for testing.

    Signup and view all the flashcards

    Computer-Aided Drafting (CAD)

    Software that assists engineers in the design process, producing models rapidly.

    Signup and view all the flashcards

    Advantages of CAD

    CAD optimizes designs, increases productivity, and enhances detail in documentation.

    Signup and view all the flashcards

    Model Verification

    The process of ensuring the correctness of a design model.

    Signup and view all the flashcards

    Traditional Methods Limitations

    Manual methods often fail in timely verification and accuracy of designs.

    Signup and view all the flashcards

    Data Modeling

    The process of representing real-world data structures for analysis and design.

    Signup and view all the flashcards

    AutoCAD

    An interactive drawing system for creating 2D and 3D designs.

    Signup and view all the flashcards

    2D Drawings

    Flat representations of objects using height and width.

    Signup and view all the flashcards

    3D Models

    Three-dimensional representations with height, width, and depth.

    Signup and view all the flashcards

    Geographical Information System (GIS)

    A system for managing and analyzing spatial data.

    Signup and view all the flashcards

    Remote Sensing

    Studying phenomena from satellites or air without contact.

    Signup and view all the flashcards

    Topography

    The arrangement of natural and artificial physical features of an area.

    Signup and view all the flashcards

    Surveying Challenges

    Difficulties faced in surveying, like site conditions and equipment transport.

    Signup and view all the flashcards

    Survey Base Maps

    Maps created with topographic details and elevation data.

    Signup and view all the flashcards

    PRIMAVERA Software

    A project management tool for planning and analysis in IT.

    Signup and view all the flashcards

    Functions of PRIMAVERA

    Includes project management, standardization, and user interface development.

    Signup and view all the flashcards

    Information System

    A system that manages and communicates information effectively.

    Signup and view all the flashcards

    Components of Information System

    Includes hardware, software, data, people, and processes.

    Signup and view all the flashcards

    Message in Information Systems

    A structured communication that contains content, sender, and receiver.

    Signup and view all the flashcards

    System Definition

    A collection of related elements that function together.

    Signup and view all the flashcards

    Role of IT in Project Management

    Helps in planning, monitoring, and controlling projects effectively.

    Signup and view all the flashcards

    Time-Money Analysis

    Evaluating time and cost efficiency in project management.

    Signup and view all the flashcards

    Database Management System (DBMS)

    Software used to store, retrieve, and manage data.

    Signup and view all the flashcards

    CRUD Operations

    Create, Read, Update, Delete - basic functions of DBMS.

    Signup and view all the flashcards

    Examples of DBMS

    MS Access, MySQL Database, Oracle Database are popular DBMS examples.

    Signup and view all the flashcards

    Data Organization

    Data can be organized using tables, rows, and columns for easy access.

    Signup and view all the flashcards

    Database Interface

    DBMS acts as the interface between users and the database.

    Signup and view all the flashcards

    Decomposition in Systems

    The process of breaking a system into components or subsystems.

    Signup and view all the flashcards

    Components of an Information System

    Includes hardware, software, stored data, personnel, and procedures.

    Signup and view all the flashcards

    Data Management

    The practice of organizing and maintaining data integrity while facilitating sharing across an organization.

    Signup and view all the flashcards

    Construction Project Data Management

    Data management in construction organizes tasks like time, cost, quality, and materials.

    Signup and view all the flashcards

    Stored Data

    Facts or information retained in a system for future access or processing.

    Signup and view all the flashcards

    Database

    A systematic collection of data that organizes information for easy access.

    Signup and view all the flashcards

    Interaction of System Components

    How system components communicate and function together within a suprasystem.

    Signup and view all the flashcards

    Study Notes

    Course Information

    • Course Title: CETS 468 Database Management in Construction Information Technology
    • Course Instructor: Engr. Joden Sorila

    Course Objectives

    • Define information technology
    • Differentiate computer technology and communications technology
    • Explain how information technology applies to civil engineering
    • Discuss software applications in civil engineering fields

    Information Technology History

    • In the 1960s and 70s, IT was used primarily in specific sectors (e.g., banks, hospitals) for data storage
    • The shift to paperless workplaces and computing technology led to IT becoming a common term
    • IT now encompasses the industry using computers, networks, software, and other tools to process and retrieve information

    Information Technology Timeline

    • 1950: No computers
    • 1960: Beginning of personal computers
    • 1970: Very expensive computers primarily for large businesses
    • 2001: Powerful personal computers available, introduction of common desktop software applications

    Information Technology Definition

    • Information technology (IT) encompasses any technology for producing, manipulating, storing, communicating and disseminating information.
    • Two primary areas of IT are computer technology and communications technology

    Computer Technology

    • A computer is a general-purpose, programmable machine that receives raw data and processes it to create useful information.
    • Computer technology includes hardware, software, the internet and storage devices.
    • The purpose of computers is problem solving and increased productivity through speed.
    • Computer performance, storage, and other related devices are continuously evolving. This makes data storage and distribution more efficiently and accessibly in electronic format for engineers

    Computer Technology Revolution

    • Diminishing costs of personal computers put computing power within the reach of small companies
    • Rapid advancements in hardware and storage capabilities support storing, sharing, and distributing documents and data in electronic format
    • Development of networking technologies (servers, network cards, modems, routers) allows for community collaboration and sharing of computing resources

    Communications Technology

    • Communication is the act of transferring information between individuals, groups or locations.
    • Traditional methods include telephones, typewriters, and mail.
    • Modern communications technology allows for communication regardless of location, virtually as if everyone is in the same physical space.
    • Modern systems include email and videoconferencing.

    Telecom Technology

    • Telecommunications is a form of communication that uses electromagnetic devices and systems to transmit data over long distances.
    • Key components include a transmitter (originator), a medium (air/cables), and a receiver (endpoint).

    Information Technology in Companies

    • IT is known as Management Information Services (MIS) or Information Services in many organizations.
    • Recent technological advancements have enabled increased information processing, storage and the rapid distribution of data through networks
    • In industries, IT has caused significant economic/competitive changes

    Information Technology in Civil Engineering (2014, 2019, 2023)

    • The roles of IT in civil engineering have expanded over time and cover various specializations. For example, in 2014, roles included Oil and Gas Engineering and Aircraft Maintenance technology. In 2019, these were augmented with actuarial and accounting roles. In 2023 these specializations were augmented with newer technologies.

    Need for IT in Civil Engineering

    • Civil engineering is complex, involving multiple physical factors.
    • Procedures are often challenging to stabilize and conduct accurate analytical calculations
    • Conventional methods are often insufficient for accuracy and timeliness in analysis.
    • Existing methods also often lack time and resource efficiency

    IT in Design & Modeling

    • IT greatly assists in creating designs that are difficult or impossible to create manually
    • 3D modeling enables computer-based testing to help verify design and modeling
    • Examples of software include Tekla Structures, AutoCAD, Revit Structures, and Midas Gen

    Computer Aided Drafting (CAD)

    • CAD software aids in design and process development.
    • CAD helps in streamlining workflow, enhancing design quality, improving documentation, and supporting the manufacturing design process
    • Examples of CAD software include AutoCAD and Revit

    IT in Surveying (GIS)

    • Geographic Information Systems (GIS) are integrated computer systems used to capture, manipulate, analyze and display spatially referenced data.
    • GIS uses overlay techniques for attribute mapping and spatial analysis across layers of data
    • GIS calculations and analysis are used for shortest path analysis, surface analysis, and land use analysis
    • Remote Sensing technologies are used for data collection from space or aircraft, helpful in surveying larger areas efficiently at reduced costs in remote, challenging locations

    Information Technology (IT) in Surveying (Remote Sensing)

    • Remote sensing involves the study of phenomena sensed from the air or satellites.
    • Engineers use remote sensing data to interpret information and views of Earth's features, particularly useful in large, difficult-to-access areas.

    IT in Project Management

    • IT is applied in the theory and practical use of computer-based project planning, analysis, and control in civil engineering projects.
    • Construction operation monitoring, project planning, management and control, time-cost analysis, and quantitative/qualitative methods are part of this application
    • Example software includes Primavera for project management systems and database creation (or data repository)

    Database Management Systems (DBMS)

    • Database management systems (DBMS) are software that manages data storage, retrieval and query functions.
    • DBMS act as an interface between the end user and the database.
    • Examples of DBMS include MS Access, MySQL, and Oracle.

    Information Systems in Construction

    • Information systems are systems that collect, process, store, manage and exchange data within construction project organizations
    • The flow of information in a construction process is essential for smooth project workflows and deliverables
    • Examples illustrate a paper-based chain-of-custody approach for requests, approval processes and delivery

    Exercises

    • Students are asked to choose one software for design/modeling, surveying, and project management and identify five advantages and disadvantages of each.
    • Students are given an exercise to identify examples of database management systems (DBMS), and analyze advantages and disadvantages.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    Description

    Test your knowledge on Database Management within Construction Information Technology. This quiz covers the basics of information technology, its application in civil engineering, and key historical timelines. Engage with questions that explore how IT has evolved and its significance in modern engineering practices.

    More Like This

    Use Quizgecko on...
    Browser
    Browser