(4 pts) An educational institution stores information about students, classes, and grades.
2. (4 pts) An educational institution stores information about students, classes, and grades. State whether each of the following represents data or metadata (if it represents data, state whether it is structured or unstructured data). If it represents metadata, state whether it is a fact describing a property of data or a fact describing the context of data. Remember that metadata is data about data, like the length of a field, or if the field is optional or mandatory. i. Students name and address. ii. Grades for a course offered in database design. iii. The resolution of a student’s ID photo in pixels. iv. Length of the course number field. v. The fact that the student ID field is the primary key for students.4. (3 pts) Database design is key to the success of a properly functioning system. What is the best way to start the design of a database system? 5. (5 pts) For each of the following entities in a college, indicate whether (under typical circumstances) there is a one-to-one, one-to-many or many-to-many relationship. STUDENT and COURSE (for example Joe Smith and COP3703, would be MANY to ONE, since many students can sign up for COP3703) i. BOOK and BOOK COPY ii. COURSE and COURSE-SECTION iii. COURSE-SECTION and ROOM iv. INSTRUCTOR and COURSE v. ROOM and INSTRUCTOR 6. (7 pts) Consider a student club or organization in which you are a member. What are the entities of this enterprise? List and define each entity.
Students are often burdened with the task of writing essays. They need to master various academic topics, understand how to integrate facts and arguments, and organize all of this information in a clear and logical way. This is not an easy task for many students. But fear not! We’ve got your back. Here at MoreEssays.com, we offer professional academic help that can take on all these tasks on your behalf. All you need to do is fill out the Order form with your paper’s details, and we will get started on it right away!