Digits, letters and special symbols are referred to as ______.
Fill in the blank(s) with the appropriate word(s).
characters.
You might also like to view...
Match the following terms to their meanings:
I. Performance Analyzer II. Data redundancy III. Analysis tools IV. Indeterminate relationship V. Table Analyzer A. Provides three levels of suggestions: recommendations, suggestion, and ideas B. A relationship that does not enforce referential integrity C. Repeated data in a table D. Searches for repeated data in a table to avoid data redundancy E. Used to improve database performance and increase data reliability
To open the Start menu, you click on the ________ located at the left end of the taskbar
A) Window button B) Start button C) Menu button D) Open button
Which of the tabs in the accompanying figure allows you to find out the total file-editing time for a project?
A. General B. Summary C. Custom D. Statistics
Professor Smith would like to assign m projects to n students in a database class. Each project can be described by its name, description, deadline and status (completed or in progress); each student has a student id, a name, and an email. Students can work in groups of several persons on one of the m projects. Different groups will take different projects (assume more projects than students, so
some projects will have no students assigned) and each student participates in exactly one group. After the project for a group is finished, a grade for the project is determined and given to all students in the group. Assume each group is identified by a unique group name. In the following, you are asked to help Dr. Smith design a database system to facilitate the assignment and grading of the projects, (a) Draw an E-R diagram for the system, in particular, use arrows or thick lines to represent constraints appropriately. Write down your assumptions if you need to make any. (b) Translate the above E-R diagram to a relational model, in particular, specify your primary key and foreign key constraints clearly. That is, give SQL CREATE statements that define the tables you need. (c) Write an SQL statement to create a view that gives the project name and group name of completed projects.