 <quiz>
    <!-- Question 1 -->
    <question type="truefalse">
        <name>
            <text>Implementation Terms and Entity Existence-Dependency</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[In implementation terms an entity is existence-dependent if it has a mandatory primary key.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>false</text>
        </answer>
    </question>

    <!-- Question 2 -->
    <question type="truefalse">
        <name>
            <text>Connectivities and Cardinalities</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Connectivities and cardinalities are established by concise statements known as business rules.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>true</text>
        </answer>
    </question>

    <!-- Question 3 -->
    <question type="multichoice">
        <name>
            <text>Database Table Error Resolution</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[A user gets an error when entering new information into a table. The error suggests the wrong values are entered in. What can the user review about the table's attributes to ensure the right values are entered in?]]></text>
        </questiontext>
        <answer fraction="100">
            <text>The attribute's domain</text>
        </answer>
        <answer fraction="0">
            <text>The name of the entity</text>
        </answer>
        <answer fraction="0">
            <text>The tables primary identifier</text>
        </answer>
        <answer fraction="0">
            <text>The candidate key</text>
        </answer>
    </question>

    <!-- Question 4 -->
    <question type="truefalse">
        <name>
            <text>Database Size and Standards</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[A database design can deviate from normal standards when the database size is less than 100 MB.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>false</text>
        </answer>
    </question>

    <!-- Question 5 -->
    <question type="multichoice">
        <name>
            <text>Customer and Invoice Relationship</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[If CUSTOMER and INVOICE is classified as a 1:M and one direction would specify that a CUSTOMER may generate many INVOICEs what would be true of the opposite direction?]]></text>
        </questiontext>
        <answer fraction="0">
            <text>CUSTOMER is unique to many INVOICEs</text>
        </answer>
        <answer fraction="100">
            <text>Each INVOICE is generated by one CUSTOMER</text>
        </answer>
        <answer fraction="0">
            <text>Each INVOICE is written to many CUSTOMERs</text>
        </answer>
        <answer fraction="0">
            <text>CUSTOMERs are given INVOICEs</text>
        </answer>
    </question>

    <!-- Question 6 -->
    <question type="multichoice">
        <name>
            <text>Entity Representation in Chen Model</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Using attributes such as STU_NAME and STU_PROGRAM the entity STUDENT would be represented with a _____ in the Chen model.]]></text>
        </questiontext>
        <answer fraction="0">
            <text>square</text>
        </answer>
        <answer fraction="0">
            <text>diamond</text>
        </answer>
        <answer fraction="0">
            <text>circle</text>
        </answer>
        <answer fraction="100">
            <text>Rectangle</text>
        </answer>
    </question>

    <!-- Question 7 -->
    <question type="multichoice">
        <name>
            <text>GPA Domain Values</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[When a student's grade point average (GPA) attribute has a domain of (0-4) the GPA can hold ____ possible values.]]></text>
        </questiontext>
        <answer fraction="0">
            <text>0</text>
        </answer>
        <answer fraction="0">
            <text>1</text>
        </answer>
        <answer fraction="100">
            <text>Many</text>
        </answer>
        <answer fraction="0">
            <text>4</text>
        </answer>
    </question>

    <!-- Question 8 -->
    <question type="multichoice">
        <name>
            <text>Database Design Conceptualization</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[After building a database using an implementation-oriented approach the database designers must now conceptualize the model so that it appeals well to management. How should the designers conceptualize the linked attributes to a single entity?]]></text>
        </questiontext>
        <answer fraction="0">
            <text>Dotted line</text>
        </answer>
        <answer fraction="100">
            <text>Solid line</text>
        </answer>
        <answer fraction="0">
            <text>Double line</text>
        </answer>
        <answer fraction="0">
            <text>Double dotted line</text>
        </answer>
    </question>

    <!-- Question 9 -->
    <question type="multichoice">
        <name>
            <text>Characteristics of a Good Database Model</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Software vendors appreciate a database model that is implementation-oriented. If a conceptual design is not ideal, what characteristics of a good model would be better than a web of ideas type of layout?]]></text>
        </questiontext>
        <answer fraction="100">
            <text>a model with associated entities and attributes</text>
        </answer>
        <answer fraction="0">
            <text>a large circle with connected entities</text>
        </answer>
        <answer fraction="0">
            <text>a dotted line connecting associated entities and attributes</text>
        </answer>
        <answer fraction="0">
            <text>A clear workflow from 1NF to 3NF</text>
        </answer>
    </question>

    <!-- Question 10 -->
    <question type="multichoice">
        <name>
            <text>Database Design for Multiple Colors</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[In designing a database for a car shop, the 'CAR' entity initially included attributes like model, make, and color. Given that a car can have multiple colors (e.g., body and trim), a database designer may consider splitting the 'COLOR' attribute into separate components in a Crow's Foot ER diagram. What advantages does this approach offer compared to maintaining a single 'COLOR' attribute?]]></text>
        </questiontext>
        <answer fraction="0">
            <text>Increases data redundancy</text>
        </answer>
        <answer fraction="0">
            <text>Reduces data flexibility</text>
        </answer>
        <answer fraction="100">
            <text>Enhances data accuracy and query specificity</text>
        </answer>
        <answer fraction="0">
            <text>Simplifies the database schema</text>
        </answer>
    </question>

    <!-- Question 11 -->
    <question type="multichoice">
        <name>
            <text>Functional Dependencies and Database Anomalies</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.]]></text>
        </questiontext>
        <answer fraction="0">
            <text>fully dependency</text>
        </answer>
        <answer fraction="0">
            <text>partial dependency</text>
        </answer>
        <answer fraction="100">
            <text>transitive dependency</text>
        </answer>
        <answer fraction="0">
            <text>anomaly</text>
        </answer>
    </question>

    <!-- Question 12 -->
    <question type="multichoice">
        <name>
            <text>Mentee and Mentor Relationship</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Given the relations: MENTEE (menteeID, menteeName, phoneNumber, cgpa, mentorID) MENTOR (mentorID, mentorName, mentorPhoneNumber), such that each mentee is assigned to one mentor and one mentor can have many mentees, which of the following is TRUE?]]></text>
        </questiontext>
        <answer fraction="0">
            <text>cgpa cannot be null</text>
        </answer>
        <answer fraction="0">
            <text>menteeID is both a primary key and foreign key</text>
        </answer>
        <answer fraction="100">
            <text>mentorID is a foreign key</text>
        </answer>
        <answer fraction="0">
            <text>no attribute is listed in the above relations</text>
        </answer>
    </question>

    <!-- Question 13 -->
    <question type="multichoice">
        <name>
            <text>Functional Dependency and Determinants</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Given the below functional dependency supplierID -> supplierName, supplierAddress, supplierPhone, which of the following is FALSE?]]></text>
        </questiontext>
        <answer fraction="0">
            <text>supplierName is functionally dependent on supplierID</text>
        </answer>
        <answer fraction="0">
            <text>supplierID is a determinant</text>
        </answer>
        <answer fraction="100">
            <text>supplierName is a determinant</text>
        </answer>
        <answer fraction="0">
            <text>all of above</text>
        </answer>
    </question>

    <!-- Question 14 -->
    <question type="truefalse">
        <name>
            <text>Data Redundancies and Partial Dependencies</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[In the context of partial dependencies, data redundancies occur because every row entry requires the duplication of data.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>true</text>
        </answer>
    </question>

    <!-- Question 15 -->
    <question type="truefalse">
        <name>
            <text>2NF and Single-Attribute Primary Keys</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Since a partial dependency can exist only if a table's primary key is composed of several attributes, and if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>true</text>
        </answer>
    </question>

    <!-- Question 16 -->
    <question type="multichoice">
        <name>
            <text>Data Modeling in Systems Development</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Data modeling plays an important part of the systems development process because of the following EXCEPT:]]></text>
        </questiontext>
        <answer fraction="0">
            <text>It enables communication among designer, programmer, and user.</text>
        </answer>
        <answer fraction="0">
            <text>Data characteristics are important in the design of programs and other systems components.</text>
        </answer>
        <answer fraction="100">
            <text>The data in a system are generally less complex than processes and play a central role in development.</text>
        </answer>
        <answer fraction="0">
            <text>It provides an abstraction for a specific problem domain.</text>
        </answer>
    </question>

    <!-- Question 17 -->
    <question type="truefalse">
        <name>
            <text>Initial Study and Conceptual Design</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[The overall purpose of the database initial study is to create the conceptual design.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>false</text>
        </answer>
    </question>

    <!-- Question 18 -->
    <question type="truefalse">
        <name>
            <text>Database Management System and Data Integrity</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>true</text>
        </answer>
    </question>

    <!-- Question 19 -->
    <question type="multichoice">
        <name>
            <text>Objectives in Database Design</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Mr. Abu is a computer scientist graduate. He is now a database designer, which of the options below is not one of the primary objectives that he should consider in designing a database?]]></text>
        </questiontext>
        <answer fraction="0">
            <text>Create complete database models</text>
        </answer>
        <answer fraction="100">
            <text>Create illogical database models</text>
        </answer>
        <answer fraction="0">
            <text>Create normalized database models</text>
        </answer>
        <answer fraction="0">
            <text>Create non-redundant database models</text>
        </answer>
    </question>

    <!-- Question 20 -->
    <question type="multichoice">
        <name>
            <text>Next Phase in DBLC</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Mr. Abu’s team is creating a new database for a client. What is the next phase for his team in DBLC after the database initial study is done?]]></text>
        </questiontext>
        <answer fraction="0">
            <text>Database maintenance</text>
        </answer>
        <answer fraction="0">
            <text>Database testing</text>
        </answer>
        <answer fraction="100">
            <text>Database design</text>
        </answer>
        <answer fraction="0">
            <text>Conduct interview and survey with clients</text>
        </answer>
    </question>

    <!-- Question 21 -->
    <question type="multichoice">
        <name>
            <text>Process of Creating Information Systems</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[The process of creating an information system is known as _____.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>Systems development</text>
        </answer>
        <answer fraction="0">
            <text>Database development</text>
        </answer>
        <answer fraction="0">
            <text>Normalisation</text>
        </answer>
        <answer fraction="0">
            <text>ERD</text>
        </answer>
    </question>

    <!-- Question 22 -->
    <question type="truefalse">
        <name>
            <text>SDLC Analysis Stage</text>
        </name>
        <questiontext format="html">
            <text><![CDATA["Should the existing system be replaced?" is a question that is asked during the analysis stage of the Systems Development Life Cycle (SDLC).]]></text>
        </questiontext>
        <answer fraction="100">
            <text>false</text>
        </answer>
    </question>

    <!-- Question 23 -->
    <question type="truefalse">
        <name>
            <text>Differential Backup</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[In a differential backup, only the objects that have been updated or modified since the last full backup are backed up.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>true</text>
        </answer>
    </question>

    <!-- Question 24 -->
    <question type="truefalse">
        <name>
            <text>Module Coupling and Cohesivity</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[Module coupling describes the strength of the relationships found among the module's entities. Whereas module cohesivity describes the extent to which modules are independent of one another.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>false</text>
        </answer>
    </question>

    <!-- Question 25 -->
    <question type="truefalse">
        <name>
            <text>Logical Design and Normalized Attributes</text>
        </name>
        <questiontext format="html">
            <text><![CDATA[As a database designer, you should ensure that the logical design contains only properly normalized attributes.]]></text>
        </questiontext>
        <answer fraction="100">
            <text>false</text>
        </answer>
    </question>
</quiz>

created 1 year ago

HTML Online Editor & Compiler

Write, Run & Share HTML code online using OneCompiler's HTML online Code editor for free. It's one of the robust, feature-rich online Code editor for HTML language, running on the latest version HTML5. Getting started with the OneCompiler's HTML compiler is simple and pretty fast. The editor shows sample boilerplate code when you choose language as HTML. You can also specify the stylesheet information in styles.css tab and scripts information in scripts.js tab and start coding.

About HTML

HTML(Hyper Text Markup language) is the standard markup language for Web pages, was created by Berners-Lee in the year 1991. Almost every web page over internet might be using HTML.

Syntax help

Fundamentals

Any HTML document must start with document declaration <!DOCTYPE html>
HTML documents begin with <html> and ends with </html>
Headings are defined with <h1> to <h6> where <h1> is the highest important heading and <h6> is the least important sub-heading.
Paragrahs are defined in <p>..</p> tag.

Links are defined in <a> tag.

Example:

<a href="https://onecompiler.com/html">HTML online compiler</a>

Images are defined in <img> tag, where src attribute consists of image name.
Buttons are defined in <button>..</button> tag
Lists are defined in <ul> for unordered/bullet list and <ol> for ordered/number list, and the list items are defined in <li>.

HTML Elements and Attributes

HTML element is everything present from start tag to end tag.
The text present between start and end tag is called HTML element content.
Anything can be a tagname but it's preferred to put the meaningful title to the content present as tag name.
Do not forget the end tag.
Elements with no content are called empty elements.
Elements can have attributes which provides additional information about the element.
In the below example, href is an attribute and a is the tag name.
Example:
```
<a href="https://onecompiler.com/html">HTML online compiler</a>
```

CSS

CSS(cascading style sheets) describes how HTML elements will look on the web page like color, font-style, font-size, background color etc.

Example:

Below is a sample style sheet which displays heading in green and in Candara font with padding space of 25px.

body{
  padding: 25px;
}
.title {
	color: #228B22;
	font-family: Candara;
}

HTML Tables

HTML Tables are defined in <table> tag.
Table row should be defined in <tr> tag
Table header should be defined in <th> tag
Table data should be defined in <td> tag
Table caption should be defined in <caption> tag

HTML-Javascript

Javascript is used in HTML pages to make them more interactive.
<script> is the tag used to write scripts in HTML
You can either reference a external script or write script code in this tag.

Example

<script src="script.js"></script>