Skip to main content

INF503 WEEK-1 LESSON (1,2&3) LAB

  LESSON-1

Q1) which of the following functions of the database management system causes some data to be read and some data to be written into a database.

A) Transaction


Q2)  which of the following applications analyses large amount of data to search for the occurrences of specific patterns of relationships.

A) Data Mining

Q3) Who is responsible for identifying data to be stored in the database and for choosing appropriate structures to represent and store the data.

A) Database Designer

Q4) during which of the following stages for creating a database are further specifications provided for storing and assessing the database.

A) Physical Design

Q5) Which of the following DBMS processes stores data on some storage medium that is controlled by the dbms.

A) Constructing

LESSON-2

Q1) Which of the following schema levels describes the structure of the whole database for a community of users?.

A) Conceptual schema  

Q2) Which of the following data models is meant for computer specialists, not for end users?

A) Physical

Q3) In most relational DBMS, there is no specific language that performs the role of--------.

A) SDL


Q3) Which of the following languages specifies the internal schema?

A) SDL

Q4) Which model is also known as the CODASYL DBTG model?

A) Network Model

LESSON-3

Q1)  What is the last phase of the database design process?

A) Physical design

Q2) What attribute can be divided into smaller subparts, which represent more basic attributes with independent meaning?.

A) Composite

Q3)  Which constraint specifies whether the existence of an entity depends on it being related to another entity via the relationship type?

A) Participation

Q4)  In UML terminology, relationship types are called as_______?

A) Associations



LAB

























































































































































































































































Comments

Post a Comment

Popular posts from this blog

IS5213 Data Science and Big Data Solutions

WEEK- 2 code  install.packages("dplyr") library(dplyr) Rajeshdf = read.csv('c:\\Insurance.csv') str(Rajeshdf)                        str(Rajeshdf) summary(Rajeshdf) agg_tbl <- Rajeshdf %>% group_by(Rajeshdf$JOB) %>%    summarise(total_count=n(),             .groups = 'drop') agg_tbl a = aggregate( x=Rajeshdf$HOME_VAL, by=list( Rajeshdf$CAR_TYPE), FUN=median, na.rm=TRUE ) a QUIZ 2. What famous literary detective solved a crime because a dog did not bark at the criminal? A). Sherlock Holmes 1.  In the Insurance data set, how many Lawyers are there? A).  1031 3. What two prefixes does the instructor use for variables when fixing the missing values? Select all that apply. A). IMP_ M_ 4. What is the median Home Value of a person who drives a Van? A).  204139 5. In the insurance data set, how many missing (NA) values does the variable AGE have? A) 7   1. What...
Post a Comment
Read more

GE5103-2 Project Management [Aug 23 Syllabus]

    Some of the advantages of using time boxes and cycles in project coordination efforts include creating urgency, measuring progress, and allowing for predictable measurements. A)        True 2.    Even though most project managers are not contract specialists, they need to understand the process well enough to coordinate with the team. For the current assignment, you are looking at a short-term and small effort with a contractor of just a few hours without significant clarity. Which of the following would be the most applicable contract to use in this situation? A)        Time and materials 3. The project you are working on has had modifications to the plan from the start and even how the project is run. Project governance covers all of the 3 following except: A)        Naming The project manager 4. Of the following, which is most likely a trigger condition defined early in t...
Post a Comment
Read more

GE5093 Design Thinking All Quizzes

  GE---5093-1D2-FA-2021 - Design Thinking Home My courses 2021-FA GE---5093-1D2-FA-2021 Week 1 Reading Quiz 1 Started on Sunday, October 31, 2021, 2:04 PM State Finished Completed on Sunday, October 31, 2021, 2:30 PM Time taken 25 mins 58 secs Grade 8.00  out of 10.00 ( 80 %) Top of Form Question  1 Correct 1.00 points out of 1.00 Flag question Question text A critical finding of Edward Lorenz related to Design Thinking was: Select one: a. An application of the caterpillar effect b. The idea of deterministic chaos or the "Butterfly Effect" c. Business leaders enjoy chaos d. Statistical modeling of weather was fairly accurate in the long term Feedback Your answer is correct. The correct answer is: The idea of deterministic chaos or the "Butterfly Effect" Question  2 Incorrect 0.00 point...
Post a Comment
Read more