I'm havinvg difficulty answering this question... Question 18Answer savedMarked out of 1.00Flag questionQuestion textReferring to the table below, what TYPE of data would you give to the 4h attribute?Table Name: DIRECTORDirlD123DirDOB05-19-194112-28-195303-01-195405-09-1940DirsSN128456798426456708623456767124456700DirLNameDirFNameEphronFoleyHowardBrooksNoraJamesRonJames4Select one:a. logicalb. numericC. characterd. date

Question text Referring to the table below, what TYPE of data would you give to the 4h attribute? Table Name: DIRECTOR DirDOB 05-19-1941 DirSSN 128456798 426456708 623456767 124456700 DirlD 1 DirLName Ephron Foley Howard Brooks DirFName Nora James Ron 12-28-1953 03-01-1954 4 James 05-09-1940 Select one: a. logical b. numeric c. character d date

Question text Referring to the table below, what TYPE of data would you give to the 4h attribute? Table Name: DIRECTOR DirDOB 05-19-1941 DirSSN 128456798 426456708 623456767 124456700 DirlD 1 DirLName Ephron Foley Howard Brooks DirFName Nora James Ron 12-28-1953 03-01-1954 4 James 05-09-1940 Select one: a. logical b. numeric c. character d date

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 11MC: Which of the following has no repeating groups but can contain partial or transitive...

See similar textbooks

Similar questions

Create one new table Products_xxxx. Your table names must follow the above format(table name is case sensitive) with following fields in correct data types. p_id: auto_increment integer, primary key  name: varchar(200), unique, NOT NULL  description: varchar(200), NOT NULL  type: varchar(50), NOT NULL  sell_price: float, NOT NULL  cost: float, NOT NULL  quantity: int, NOT NULL  e_id: int, NOT NULL, a foreign key to the employee_id field in the table v_id: int, NOT NULL, a foreign key to the vendor_id field in the table.
Create a new table Courses_xxxx with following fields in correct data types.1) cid: varchar(200), unique, NOT NULL, primary key2) name: varchar(200), unique, NOT NULL3) term: varchar(200), NOT NULL4) enrollment: int, NOT NULL5) Fid: int, NOT NULL, a foreign key to TECH3740.Faculty table.6) Rid: int, NOT NULL, a foreign key to TECH3740.Rooms table.7) aid: int, NOT NULL, a foreign key to TECH3740.Admin table.
8) Which datatype can store unstructured data in a column? CHAR RAW NUMERIC VARCHAR
Db&__Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers...
Which of the following(s) (is)are accepted as data reduction? I decreasing number of variables II decreasing number of records III forming linear combiniation of existing features to create new features a. only I b. only II c. only I and II d. I, ıI and III
Using the DBMS 130 Course Project ERD and Table Details spreadsheet, write and runSQL statements to insert records into your tables.Place comments in your script including course number, date, your name, and otherrelevant comments.1. Use www.imdb.com to find at least 6 titles for your FLEX_MOVIES table.2. Insert at least 6 fake records for your rental FLIX_CUSTOMERS table.3. Insert at least 2 records into each of the following tables: FLIX_RENTAL_HISTORY FLIX_MEDIA FLIX_STAR_BILLINGS FLIX_ACTORS
Use five classes to organize the above raw data; use class-limits → 41-46, 47-52, 53-58, 59-64, 65-70.a) Create a table with (i) Class-limits; (ii) Class-boundaries; (iii) Class-mid-points (??); (iv)Frequencies (?); (v) Relative ?; (vi) Cumulative ?. [Follow the same pattern as done with Excelin class. If you want, you can create the Table in Excel, then copy and paste into your Word document]b) Plot a Histogramc) Plot a Frequency Polygond) Plot an Ogive
Joe, one of your systems analysis team members, made the following entry for the data dictionary usedby Marilyn’s Tours:DATA ELEMENT = TOURIST* * * * PAYMENTALIAS = TOURIST PAYCHARACTERS = 12−24RANGE = $5.00−$1,000VARIABLES = $5.00, $10.00, $15.00, up to $1,000, and anything in between in dollars and cents.TO CALCULATE = TOTAL COST OF ALL TOURS, ANY APPLICABLE NY STATE TAX, minusany RESERVATION DEPOSITS made.a. Is this truly a data element? Why or why not?b. Rewrite the data dictionary entry for TOURIST PAYMENT, reclassifying it if necessary. Use theproper form for the classification you choose.
Could you kindly clarify the difference between custom settings and custom metaData in Salesforce and tell me if custom settings and custom metaData may be used in formula fields? Could you also clarify the distinction between custom settings and custom metaData? Please be aware that posts containing plagiarised content may be reported and their vote totals decreased.
Which of the following has no repeating groups but can contain partial or transitive dependencies?a. unnormalized datab. 1NFc. 2NFd. 3NF
Using the DBMS 130 Course Project ERD and Table Details spreadsheet, insert records into your tables. Place comments in your script including course number, date, your name, and other relevant comments.1. Use www.imdb.com to find at least 6 titles for your FLEX_MOVIES table. 2. Insert at least 6 fake records for your rental FLIX_CUSTOMERS table.3. Insert at least 2 records into each of the following tables: FLIX_RENTAL_HISTORY FLIX_MEDIA FLIX_STAR_BILLINGS FLIX_ACTORS
Which of the following are insertion anomalies caused by redundancies in the following table? Inserting a new record without employee name (eName). Inserting a new employee who is not assigned to any hotel. Inserting a new record with NIN 1135 and eName John Smith. A) All three B) 1 and 2 C) 1 and 3 D) 2 and 3