HomeworkLib
Question

Define the attribute names, data types, and optional comments needed to create a table that could...

Define the attribute names, data types, and optional comments needed to create a table that could be used as a datebook.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

To create a datebook table here are the following details:-

Attributes-

1. Id

2. EventName

3. FromDate

4. ToDate

5. Summary

DataTypes-

1. Int

2. Varchar

3. Date

4. Date

5. Varchar

0 0
Add a comment
Know the answer?
Add Answer to:
Define the attribute names, data types, and optional comments needed to create a table that could...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 1. Describe the difference between variable and attribute data. What types of control charts are used...

    1. Describe the difference between variable and attribute data. What types of control charts are used for each?

  • Write SQL to create a table called City in your account. The schema of the table...

    Write SQL to create a table called City in your account. The schema of the table is listed below. You must define the data types and not null constraint (if needed) of every column and all the primary key and foreign key constraints for the table. No screenshot needed for this question. City (Name, Country, Population, Capital). Name: the name of the city. Text string with maximum 50 characters. Must not be null. Country: the name of the country where...

  • Write an SQL CREATE statement to create the structure of a table to store the following...

    Write an SQL CREATE statement to create the structure of a table to store the following employee information empLastName, empFirstName, Dept (foreign key to department table), emp Address, empZip, empCity, empState. Use appropriate data types to reflect the data which will be stored in each attribute. Identify attributes which should not be null by using the correct SQL statements in the create statement

  • data base Given the data model shown below, please define the following: 1) Table names 2)...

    data base Given the data model shown below, please define the following: 1) Table names 2) Primary keys for each table. If the key is composite, please indicate. 3) Foreign Keys for each table and what table/field the FK relates to 4) Define which table is the "Parent" and is the "Child" in the relationship. EMPLOYEE(Employee Number, ElastName, FirstName, EAddress, Ecity, EZipCode, EDepartCode) DEPARTMENT(DepartmentCode, DeptName, Dept Div) DIVISION(DivisionCode, DivName, DivvP) EPHONE(PhoneID, EmpNum, Phone Number, Phone Type) TTT Arial 3 (12pt)...

  • Write the SQL statement to create a five-field table to contain sample student information. The constraints...

    Write the SQL statement to create a five-field table to contain sample student information. The constraints that need to be satisfied by the attributes of this table are as follows: the attribute First_Name is mandatory and can have up to 16 characters, the attribute Last_Name is mandatory and can have up to 16 characters, the attribute Date_Of_Birth is of type date is required, the StarID field identifies each student and is 8 characters long the GPA field is numeric that...

  • How can we create table? What are the various data types available using sql What are...

    How can we create table? What are the various data types available using sql What are the various constraints that you can create. What is the difference between table level constraints and column level constraints? table create with SQL Using oracle.

  • Develop a table that critques three types of EHR’s to include the following: Names of systems...

    Develop a table that critques three types of EHR’s to include the following: Names of systems Advantages and disadvantages HITECH standards How it protects patient privacy How it improves efficiency What settings they are best used in

  • Procedure Part 1: Attributes of Laws and Theories 1 Designate whether each attribute in Data Table...

    Procedure Part 1: Attributes of Laws and Theories 1 Designate whether each attribute in Data Table 2 is true of a law. If the attribute applies, record an “X” in the “Law” column. If the attribute does not apply, leave the area blank. Data Table 2: Attributes of Laws and Theories Attribute Law Theory X Helps unify a field of study A particular phenomenon always occurs if certain conditions are present Supported by a large amount of data Explains why...

  • An attribute in a data model is the same as a(n) in a table or spreadsheet....

    An attribute in a data model is the same as a(n) in a table or spreadsheet. column row item range Relational data modelers should always begin with a engineer an existing data model. data model or reverse conceptual physical relational logical A data modeler steps through the 1NF, 2NF, and 3NF in order to eliminate redundancy duplicate entities many to many one to many

  • how could I know attribute X and attribute Y are dependent in each dataset through the table or athe graph? especially...

    how could I know attribute X and attribute Y are dependent in each dataset through the table or athe graph? especially (b) and (d) 4.14 Exercises 355 Noise Anrbutas Noise Aavbues Class A Cass Records Class B Cass E (a) Synthetic data set 1 (b) Synthetic data set 2. Attributes Noise Anrbutes Cass A Cass B Cass A Cass BCass A Class ass AClass Class A B Cass A ClassA Cass B CasSA Class B Cass A Cass B (d)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT