User Account

All Pages

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

  Implement in access database using check and unique

These comprise NOT NULL, CHECK, UNIQUE, REFERENTIAL INTEGRITY, and PRIMARY KEY constraints. Are these constraints which we are talking about easy to implement in Access Database?

  Write a join query that for every order placed on september

Write a join query that for every order placed on September 5, 1998, (use '05-SEP-1998') will list the order number and order date along with the customer number, last name, and first name of the customer who placed the order

  Select the primary key from the candidate keys

How do you select the primary key from the candidate keys? How do foreign keys relate to candidate keys? Provide examples from either your workplace or class assignments.

  How can you enforce business rules in dbms

What is 1 tier, 2 tiers and 3 tiers and N tiers in database architecture? Can you offer an example on each tier?

  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.

  Discuss the serious data redundancy problems

Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure and looking at the EMP_NAME and EMP_PHONE contents in Figure, what change(s) would you recommend?

  Show attributes and include relationship and connectivity

Show all attributes and include relationship and connectivity. Convert all M:N relationships into entities. You are to use Crow's Foot notation showing all attributes for each entity and naming each relationship. Do not show M:N relationship, convert..

  Logical development of appropriate data types

Demonstrate professional presentation skills by the development of a professional business presentation to the client outlining the development process for this Database Management System project.

  Draw the flowchart for the decision structure

Identify appropriate test values for the decision structure and submit the results of a desk check of the program.

  Justify a question on database management

When a student has not chosen a major at a university, the university often enters a value of "Undecided" for the major field. Is "Undecided" a way to represent the null value? Should it be used as a default value? Justify your answer carefully.

  Develop a table that identifies top threats to new customer

Develop a table that identifies the top threats to the new customer rewards program at Kudler Fine Foods in preparation for your final report. Include the likely vulnerabilities each threat might exploit.

  Explain good strategy for processing queries

Explain a good strategy for processing each of following queries. Determine all machines at Almaden plant. Determine employee 1 machine.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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