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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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