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

  Design work breakdown structure for designing database

Design a work breakdown structure for the task below: Designing the database, Working on the website content

  Describe features of the potential database

List the major topics of the database to track concerts and venues - Write a draft statement of work, including a brief history, a statement of scope, objectives, and preliminary timeline.

  Write a report about how your nationometer works

Write a report about how your Nationometer works and provide a URL link to a working version and understand the different types of dataset you may need to use and how you can gain access to them.

  Write short notes on erd and database file

This course utilizes the Virtual Organizations, an Apollo Group, Inc. learning tool. The Virtual Organizations portal is accessed from the link on your course materials page.

  Data-flow diagrams can be used to the physical system

Data-flow diagrams can be used to model both the physical and logical systems. Data models can be analyzed to identify possible inconsistencies that exist between two sets of diagrams or within a single DFD.

  Calculate confidence and support of rule

Assume that 30% of science students are majoring in biology. Would you consider to be novel with respect to rule? Describe. Calculate confidence and support of rule.

  Database management challenge than relational database

What is it about a 200 MB video or audio file which makes it so much more of database management challenge than relational database the same size?

  Find all non-trivial dependencies

Compute the closure sets of R, find all non-trivial dependencies and what are the candidate keys of R?

  Create a dtd file and an xsd file that specify the schemas

Create an XML file that describes 3 product elements; each product has three sub-elements: id, name, and description.

  Create a corresponding xmlschema file

A simple database with a single table contains data concerning car registration. The table contains four fields that store data relating to registration number (unique), make of car, year of manufacture and car colour

  What is the appearance of the relation result

In terms of the relations shown below, what is the appearance of the relation RESULT after executing each of these instructions?

  Study on managing the software enterprise

This course is for those in a management capacity, or those interested in management, involving the strategic consideration of software acquisition, development and project management.

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