Describe the purpose of the database

Assignment Help Database Management System
Reference no: EM131136292

Assignment: Business Rules and Data Models

Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.

Use the internet to research the types of information that a college would want to track in a database. Focus your attention on information that could represent entities within a database as well as attributes of such entities.

Write a two to three page paper in which you:

1. Describe the purpose of the database.

2. Based on your research and / or common knowledge of a college and the information tracked by a college, describe the entities of the database and the attributes of each entity.

3. Based on your research and / or common knowledge of a college and the information tracked by a college, describe the business rules that could impact the structure of the database.

4. Determine the information that the conceptual model of the database would include and determine the information that the physical model of the database would include.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

• Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

Reference no: EM131136292

Questions Cloud

Protection for endangered species : So, I need these questions answer in two separate discussion boards. The samples from where you will be answering the questions are below. Should be failry easy. Read the sample and then answer if it is a claim or not and why and so on. Do so in ..
Analyze the existing security situation in the organization : Analyze the existing security situation in the organization. Identify the predominant electronic and physical threats to communications networks. Explain the importance of explicit enterprise security policies and procedures.
What is the best that can be done to keep gdp : Compare the path of GDP in this question with the path in problem 1 after policy actions have been taken.
Why are government programs seldom terminated : Policy analysis is about finding out what governments do, why they do it, and what difference those activities make. Why are government programs seldom terminated? Provide at least three reasons in your response
Describe the purpose of the database : Describe the purpose of the database. Based on your research and / or common knowledge of a college and the information tracked by a college, describe the entities of the database and the attributes of each entity.
The effects of the increased government spending : What policy actions can be taken to put GDP back on target each period?
Research about effect of video game to the children : Write a 700- to 1,050-word essay (not counting title or reference page material) about the topic you chose in Week 1. Incorporate at least two research sources.
Describe the proper decontamination stage : The facility has been hit by a chemical terrorist attack. Describe the proper decontamination stage and initial decontamination considerations that are specific to the facility that has been hit in your area
Why is real gdp targeting the riskier of the two strategies : Why is real GDP targeting the riskier of the two strategies?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Is it possible for r to be in bcnf if so under what conditon

Consider the relation schema R(A,B,C), which has the FD B → C. If A is a can-didate key for R, is it possible for R to be in BCNF? If so, under what conditions? If not, explain why not.

  Design program that displays table of contigrade temperature

Design a program that displays a table of the contigrade temperatures 0 through 20 and their Fahenheit equivalents. The formula for converting a temperature from centigrade to Fahrenheit is.

  Describe the different procedure performed in dbms

Describe the different procedure performed in DBMS for student database in which fields are student id, student name, student class, marks.

  Create a conceptual model of a database

create a conceptual database model using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain experience with the various modeling tools needed to create a conceptual model of a database

  What model would you use for this estimation

What model would you use for this estimation? How accurate would it be and how would you obtain the estimate?

  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.

  Compute the customer margin for the hoium family

Compute the activity rates (i.e., cost per unit of activity) for the activity cost pools. Round off all calculations to the nearest whole cent.

  Create a mock-up interface for the project

Create your first mock-up of this interface - Based off of your previously chosen organization, you will now begin the design.

  Patients post cardiac bypass surgery

Monitor Renal Outcomes in patients post cardiac bypass surgery?

  Develop basic tools to expedite use of oracles data

develop basic tools to expedite use of oracles data dictionarygoalsdevelop and demonstrate sql skillsdevelop your

  Write the vbscript code

Write the VBScript code that initializes all the variables in the numArray(100) to the value numArray(0)=1, numArray(1)=2,&#-123;,numArray(100)=101

  Intro to programming

For this assignment, you will create a class to describe the product that is being ordered. You will then modify your code to create an instance of this class and utilize it in the ordering process.

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