Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

· Answer all three questions · Please utilize following link for textbook (recommend downloading it): https://drive.google.com/file/d/16cV7PEVJbR6eqMqbd3Mm1DROHt4x-SYj/view?usp=sharing 1. Suppose...

1 answer below »
· Answer all three questions
· Please utilize following link for textbook (recommend downloading it): https:
drive.google.com/file/d/16cV7PEVJbR6eqMqbd3Mm1DROHt4x-SYj/view?usp=sharing
1. Suppose you were designing a file of student records for your university’s placement office. One of the fields that would likely be in this file is the student’s major. Develop a coding scheme for this field that achieves the objectives outlined in this chapter for field coding.
2. Suppose you were designing a default value for the ma
iage status field in a student record at your university. What possible values would you consider and why? How would the default value change depend on other factors, such as type of student (undergraduate, graduate, professional)?
3. Transform the E-R diagram of Figure 7-20 (pg.254) from the textbook into a set of 3NF relations. Make up a primary key and one or more non-keys for each entity that does not already have them listed.
Answered 3 days After Mar 01, 2023

Solution

Sumit Kumar answered on Mar 04 2023
31 Votes
Algorithms Assignment
Question: - Suppose you were designing a file of student records for your university’s placement office. One of the fields that would likely be in this file is the student’s major. Develop a coding scheme for this     field that achieves the objectives outlined in this chapter for field coding.
Solution: -
Coding scheme for student records: -
    Data Type
    Description
    Numbe
    Number data used for Students Roll Number, what year the student is in, for calculations and unique numbers like index. For this we use 4 bytes and 8 bytes to store.
    Text
    Text used to store Student first name, middle name, last name, Department of the student (In which student is studying), Student’s phone numbers, Student’s cu
ent Address and Permanent Address of students.
    Decimal
    Decimal Data is used to store Decimal number calculation Result, for calculation and it also for storing score percentage of the student.
    Yes/No
    Yes/No Value is used for student give some question answer in yes/ no format.
    Hyperlink
    This is used to store student full information like...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here