Blog

Question 14: What is the ASCII code, and how is it relevant to character representation and manipulation in C programming?

Question 1: What is the purpose of a “newline” character in C, and how is it represented within a string literal?

Two part question: Review the DDL script below and answer the following two questions: 1. Identify and describe two distinct (cannot be the same issue in a different place) script-related problems in this code.  These issues could potentially cause errors or unwanted outcomes. Upper and lower cases do not cause issues. 2. Assuming the issues are fixed and the script ran without errors, what will be the result after it runs meaning what will exist in the database? CREATE TABLE members (     uteid             varchar(20)     primary key,     first_name  varchar(30),     last_name   varchar(40),     email            char(15),     phone           varchar(12),     grade            number(1),     birthdate      date )   CREATE TABLE committees (    committee_id           NUMBER(5)              PRIMARY KEY,    committee_name     VARCHAR(30),    semester_year          VARCHAR(4) )   CREATE TABLE member_committees (    uteid                    VARCHAR(20),    committee_id      NUMBER(5),    CONSTRAINT   uteid_committtee_pk     PRIMARY key  (committee_id),    CONSTRAINT   uteid_fk                         FOREIGN KEY (UTEID)  References  members (UTEID),    CONSTRAINT   committee_fk                foreign key (committee_id)  references  committees (committee_id) )   DROP TABLE member_committees DROP TABLE members DROP TABLE committees

When sub-dividing data elements, the rule of thumb is to always subdivide a composite attribute into smaller components no matter the context in which the data is used.  True or False.  Also, concisely explain why.

Native Americans on the plains relied on the [BLANK-1] for food, shelter, and clothing.

[BLANK-1] was a Radical member of Congress following the civil war. He had himself buried in an African American cemetery.

A [BLANK-1] is an organization of workers who assemble to achieve better working conditions.

EXTRA CREDIT:  Worth up to 5 points In the essay box below, paste your IPA transcription of this speaker’s production of the 5 words indicated below. Include diacritics if phonemes alone aren’t sufficient to accurately represent the production of the target.   Female Speaker born in Puebla, Mexico words to transcribe:  these, spoons, snow, Bob, Wednesday [The same audio is available in two different formats. Both are identical. Please listen to whichever one you like.]  

In the essay box below, paste your IPA transcription reflecting what you hear for the second production of this word using narrow transcription with one diacritic only. [When you listen to the recording, I’m intentionally contrasting the diacritic difference, so listen for what diacritic would best represent the difference in these two productions. The same audio is available in two different formats. Both are identical, so please listen to whichever one works best.]      

A. Terms. Select the description that best corresponds to each term. (1pt each x 10 = 10pts)