Create a relationship between table students and department

Assignment Help Database Management System

Reference no: EM132650053

Information Technology Project

For Oracle Apex, see the slide on using Oracle Apex on Moodie.

1. Create a table named Students with the following columns and structure

Column Mil Type Length Precision Scale Pommy Key Nuliable

57013 NUMBER 3 0

LA_STNAME VARCWAR2 25

FIRSINAME VARCHAR2

ADDRESS VARCHAR2 100

0E2^-n0 NUMBER 5 0 ?

2. Create a table named Department with the following structure

Column Data Type Length Precision Scale Primary Key Nuliable

DEPT I) NUMBER

DEPTNAME VARCHAR2 25

DEPTADDRESS VARCHAR2 100

3. Create a relationship between table Students and Department, such that deptlD is a foreign key in table Students.

4. Insert five records into the tables created in (1) and (2).

5. Create a query that selects the student id. lastname. firstname. and deptname from both Students and Department.

6. Create a query that selects the Firstname and Lastname of students in Accounting department.
For Microsoft Access, download the file BookDB.accdb from Moodie and open it into Microsoft Access. Create and save the following queries. Name each query appropriately.

1. In Microsoft Access, create a database named BookDB with the following Tables and Structures Tables: Book, Author, Order

Book

Column Names	Data types	Length Constraint
ISBN	Short Text	50 Primary Key
AuthID	Number	Foreign Key
Title	Short Text	50
Retail Price	Currency
Wholesale Price	Currency

Author

Column Names	I Data types	Length	Constraint
AuthID	I Number	5	Primary Key
Last Name	Short Text	50
First Name	Short Text	50

Order

Column Names	Data types	Length	Constraint
OrderlD	Number
ISBN	Short Text	50	Forman Key
Quantity	Number	50	Forman Key

• Records of National Board of Health and Welfare - includes reports from all 14 IVF clinics in Sweden regarding who underwent IVF and when they had their procedure
• Records from all 26 childhood disability centers in Sweden - includes diagnosis data on all children treated for cognitive disorders during childhood
Answer the following questions:
a) In two sentences, is this an example of a prospective cohort study or a retrospective cohort study? How do you know?
b) What is the timeframe of your study, meaning what years of data will you include? Hint: Think about when each of the outcomes is assessed.
c) Who is in the exposed population? Who is in the unexposed population?
d) Which data source(s) would you use to identify exposure status and outcome status? (Remember that there are multiple outcomes in this study)

Question 3:
You have been asked to investigate the association between exposure to low-level radiation emanating from a nearby nuclear plant and risk of mortality (death) from all causes. There is a large recreational sports facility located 0.5 miles from the nuclear plant. The sports facility has near-complete records on all its members, including names, addresses, and ages; furthermore, all members visit the facility on a regular basis, making them easy to locate and track. In an effort to avoid loss to follow-up, you select members of this sports facility as your exposed population. For your non-exposed population, you select individuals of similar age, sex, and racial/ethnic characteristics from an area at least 50 miles away from the nuclear plant. Identify and explain two types of bias are you likely to have introduced to this cohort study.

Reference no: EM132650053

Questions Cloud

What does total quality management emphasize : What does Total Quality management emphasize [or put stress on]? Why is feedback necessary in management process? Explain what is the process of control?

Understand the covid-19 problem : How can we use allegory to help us understand the COVID-19 problem.

What are the three management functions : What are the three management functions that management accounting information can be used to make them become more effective?

Ethnocentrism and cultural relativism impact : How do ethnocentrism and cultural relativism impact how people view cultures? How might these impact the development of an ideal society?

Create a relationship between table students and department : Create a relationship between table Students and Department, such that deptlD is a foreign key in table Students and Create a query that selects the student id

Determine the change in squawk box accounting : Determine whether the change in Squawk Box's accounting method will require an adjustment of income under IRC §481 and determine the timing

Concept of locus of control : How can the concept of Locus of Control (LOC) have an impact - either positive or negative - on patient care and recovery?

Explain example of previous or current american president : What is an example of a previous or a current American President used impression management techniques with the public? What tools did he used during the perfor

Impact the development of an ideal society : How do ethnocentrism and cultural relativism impact how people view cultures? How might these impact the development of an ideal society?

User Account

All Pages