Design the database using the given fields and criteria

Assignment Help Database Management System
Reference no: EM131132159

Create an Android app that will be used to enter student grades for college courses.

Develop three screens as follows:

• The first screen should allow the entry of a student id, first name, last name, class id, and class name.

• The second screen should allow the entry of a grade for each student and class that they took. The grade entry will be a number which can range from 0 - 100.

• The third screen should show the student name and overall letter grade for the semester based on the classes that they took. Note: Use the grade conversion table below:

Points              Grade

100-90                 A

80-89                   B

70-88                   C

60-69                   D

Below 60              F

Use the sample students and grades below:

Student ID      Student Name       Class ID       Class Name       Grade

1                       Sally Smith           100            Biology               70

1                       Sally Smith           110            Gym                   90

2                       Mark Front           120             English               40

2                       Mark Front           110             Gym                   10

3                       Rick Hart              130            Science                85

3                       Rick Hart              100            Biology                90

3                       ick Hart                110            Gym                    45

4                       Justin Jones         140            Computers           45

4                       Justin Jones         120            English                 70

Design the database using the following fields and criteria:

StudentID VARCHAR(8),

FirstName varchar(20),

Lastname varchar(20),

ClassID varchar(20),

Grade Integer(3),

Lettergrade Varchar(2)

Reference no: EM131132159

Questions Cloud

Write an eight to ten page project paper : write an eight to ten page project paper:- Business Introduce your business idea.-Describe the Business type (new business, franchise, operating business) and include rationale.
The gross requirement of dependent item is computed : The gross requirement of a dependent item is computed from the
Provide evidence of paleocultural behavior : How can the "Olduwan Industry" be said to provide evidence of "paleocultural" behavior and what is some evidence for hunting as the dominant component of early hominid economies?
Identify the different types of inventories : Identify the different types (list several items of each) of inventories (raw materials, WIP, and finished goods) carried in the following organizations:
Design the database using the given fields and criteria : Design the database using the following fields and criteria: StudentID VARCHAR(8), FirstName varchar(20), Lastname varchar(20), ClassID varchar(20), Grade Integer(3) and Lettergrade Varchar(2).
Which will change equilibrium output more : You hear the argument that a reduction in the deficit will increase consumer and business confidence and thus reduce the decline in output that would otherwise occur with deficit reduction. Is this argument valid?
Differences between the two approaches : In your own words, explain the relationship between JIT and Lean. In your answer, address (at a minimum), each of the following: Key elements of each approach to production and operations management. Similarities between the two approaches. Diifferen..
Major characteristics of processual archaeology : What are the major characteristics of processual archaeology? Use Koster to provide examples of these characteristics.
Briefly discuss how it is used in organizations and in hr : Create section headings for the key HR metrics for each of the 3 categories identified in the attached Matrix and discuss(table): Routine HR Metrics, HR Strategy Metrics, and HR Organizational Oversight Metrics.

Reviews

Write a Review

Database Management System Questions & Answers

  Translate the conceptual e-r data model for the application

Translate the conceptual E-R data model for the application, developed without explicit consideration of specific user interfaces, into normalized data requirements.

  Requirementscreate a database from scratch that contains at

requirementscreate a database from scratch that contains at a minimum the elements listed below. the type of database

  1 code an oracle database trigger to enforce the constraint

1. code an oracle database trigger to enforce the constraint that an employee can never change his or her department.2.

  Relational database modelling techniques and e-r diagram

Practical experience in using Entity-Relationship and Relational Database modelling techniques - design using an E-R diagram an entity-relationship model of the problem, convert the model into a relational model, and assess the normal form of each ..

  Explain how data mining be used to imporve customer service.

Please explain how a databses management system (DBMS) and data mining can help a motor vehicle maintenance center improve its services, and what tables would be needed in such a database

  Assume that you would like mary to be able to verify that

Assume that you would like Mary to be able to verify that all your email mes- ages are really sent from you. How can you authenticateyour messages without encrypting the actual text?

  If you cannot capture some constraints explain why

Consider the university database from Exercise 2.3 and the ER dia-gram you designed. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why.

  Develop an e-r diagram for the library database

Develop an E-R diagram for the library database. The relation schemas for the library database. Normalization of the relations (your relations should be in 4NF)

  Discuss the main characteristics of the database approach

Please submit at least 250 words for this portion of the discussion forum. Discuss the main characteristics of the database approach and how it differs from traditional file systems. With what other computer system software does a DBMS interact

  Criteria selecting a life-cycle model for the project

What criteria would you use in selecting a life-cycle model for the project?

  Sql statements that return a subset of columns

Design and develop the below queries using professional principles and standards: Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause

  Find database management system selection

Identify and describe three criteria that should be used to evaluate the selection of a database management system.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd