ZuoTi.Pro
Question

Table 1-1 shows example metadata for a set of data items. Identify three other columns for...

Table 1-1 shows example metadata for a set of data items. Identify three other columns for these data (i.e., three other metadata characteristics for the listed attributes) and complete the entries of the table in Table 1-1 for these 3 additional columns (for example the existing ones are Name, Type, Length, Min, Max, Description; an additional column could be something like “Required Field”).

Name Type Length Min Max Description
Course Alpha 30 Course ID and Name
Section Integer 1 1 9 Section Number
Semester Alpha 10 Semester and Year
Name Alpha 30 Student Name
ID Integer 9 Student ID
Major Alpha 4 Student Major
GPA Decimal 3 0.00 4.00 Student GPA
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)

All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Table 1-1 shows example metadata for a set of data items. Identify three other columns for...
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

Similar Homework Help Questions

  • Conceptual data diagram The ABC university keeps track of each student&#39;s name, student number, social security...

    Conceptual data diagram The ABC university keeps track of each student&#39;s name, student number, social security number (I C number), current address and phone, permanent address and phone, birthdate, sex, class (alpha, Beta, Gamma ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student&#39;s permanent address, and to the student&#39;s last name. Both social security number and student number have...

  • Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is...

    Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, birth date, sex, class (freshman, sophomore,., graduate), major department, minor department (if any), and degree program (B.A., B.S.,..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...

  • Problem 1 Consider the following set of requirements for a university database that is used to...

    Problem 1 Consider the following set of requirements for a university database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, -, graduate), major department, minor department (if any), and degree program (B.A., B.S., ...., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...

  • rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name...

    rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name varchar(25) student last name major_id integer the ID of the student's major; a foreign key for the major_id in the rider_major table rider_major Column Data Type Description major_id integer the primary key major_name varchar(50) student first name major_description varchar(100) student last name Use the Tables above to answer the questions. Questions: 1. Write a SQL statement to add a student record to the rider_student...

  • 1. Create a dependency diagram for the set of given columns for the EMP table: EMPID  ...

    1. Create a dependency diagram for the set of given columns for the EMP table: EMPID   Employee’s ID LAST Employee’s last name FIRST Employee’s first name DEPTID Employee’s department number DEPTNAME Employee’s department name DEPENDENTNO Employee’s number of dependents DEPENDENTSSN Dependent’s Social Security Number DEPENDENTDOB Dependent’s date of Birth PROJNO Employee’s project number PROJNAME Project name PROJTYPE Project Type PROJDESC Project Description 2. Using the dependency diagram of the EMP table from #1 above, normalize the table to 3NF. Use...

  • (7) Student grade point statistics [Problem description] There is a need to make statistics of the grade points o...

    (7) Student grade point statistics [Problem description] There is a need to make statistics of the grade points of the students in the first semester of 2018. It is assumed that there are n (can be set as 6) classes in this grade, and there are 20 students in each class, the total number of courses with exam is m (can be set as 10), and the percentage system is adopted for each course. The gpa is 4, 3, 2,1,...

  • Problem 1. Please create the following tables for UMBC bookstore’s textbook management system with appropriate primary...

    Problem 1. Please create the following tables for UMBC bookstore’s textbook management system with appropriate primary keys & foreign keys. Please include drop table statements with cascade constraints before your create table statements so it is easier to grade your create table statements. E.g., suppose you will create table tab1, tab2, including the following before creating them: Drop table tab1 cascade constraints; Drop table tab2 cascade constraints; Assumptions: Each teacher can teach one or more scheduled course sections. Each scheduled...

  • (MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications...

    (MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...

  • Files given in this assignment (right-click on the file to download) Assignment7.cpp (need to complete) Student.h...

    Files given in this assignment (right-click on the file to download) Assignment7.cpp (need to complete) Student.h (Given. Just use it, don't change it!) Student.cpp (Partially filled, need to complete) 1. Assignment description In this assignment, you will write a simple class roster management system for ASU CSE100. Step #1: First, you will need to finish the design of class Student. See the following UML diagram for Student class, the relevant header file (class declaration) is given to you as Student.h,...

  • python anywhere questions. A Class Management System, Part 2 Please also refer to the description provided...

    python anywhere questions. A Class Management System, Part 2 Please also refer to the description provided in Part 1 of the project “A Class management System”. You have had a chance to state your understanding of the requirements for this project, draft a preliminary design, and express it by means of UML diagrams. Now it’s time to implement your design. As stated in the original requirements, there will be three categories of users: 1. Students 2. Instructors 3. Administrators Recall...

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
ADVERTISEMENT