You have been asked to create a database about human habitation in your general area, organised by...

Question

You have been asked to create a database about human habitation in your general area, organised by time periods, types of humans), the technologies they used (e.g. fire, stone implements, etc.) and smaller local areas (e.g. the districts within your local authority).

Your database should allow records to be entered and amended by teachers efficiently. The output should be in a format that is easy to understand by pupils. Both teachers and pupils should be able query the database to find answers to questions about what their local area was like a long time ago. Your test data does not need to be accurate. Please note that the list of time periods will be determined by which part of the world you live in. However, you may want to start with; pre-homo sapiens (humans before our type), the stone age, the bronze age and the iron age. Please feel free to add to or amend this list. The list of technologies is also up to you. Sheet1 human habitation in types of ages items/agesstone ageneolithicmetal ages paleolithicmesolithicneolithicbronze ageiron age time2.5mil yrs -10000 bc10000-8000 bc8000 -3000 bc3000bc-1300 bc1300 bc -900 bc https://www.history.com/news/prehistoric-ages-timeline#:~:text=The%20Prehistoric%20Period%E2%80%94or%20when,Bronze%20Age%20and%20Iron%20Age. where they stayedopen area, caves, nearby lakescaves, nea rivercaves ,near rivercaves ,near rivercaves ,near river way of livingnot organised, always migratingmore organised, and stay in 1 placemore organised, and stay in 1 placemore organised and have traditonsmore organised and have traditons ecomonical activittyhunting animals and jungle resources and catching fishesagriculture,rearing animals technoly usedstone,woods,hand axestone ,woods,firestone but more sharp n polished,potterybronze metals,repalced the stones, iron tools and steel toolshttps://www.history.com/news/prehistoric-ages-timeline#:~:text=The%20Prehistoric%20Period%E2%80%94or%20when,Bronze%20Age%20and%20Iron%20Age. beliefaninismeaninisme clothinganimal skinanimal skinanimal skin,woven garments type of humanhomo sepianshomo sepianshomo sepianshuman as current worldhuman as current worldhttps://www.tf.uni-kiel.de/matwis/amat/iss/kap_2/advanced/t2_1_6.html ex of discrict areagua niah sarawak,kota tampan,bukit jawa ,bukit bunuh lenggong perak,gua tingkayu sabahnull(not happen in malaysiagua cha, kelantan,bukit tenkorak, sabah,gua harimau perakSungai Jenera, Ulu Kelantan, Chuping di Perlis dan Tanjung Malim di Perak.Sungai Tembeling, Pahang Gua Harimau, Perak Changkat Menteri, Perak Lembah Bernam, Selangor time period start time end time

your-database-should-allow-records-to-be-entered-and-amended-by-teachers-efficiently-3vljjnro-utetbzjq.docx cw-data-vombmnta-1u3ecfy0.xlsx

Bikram · Accepted Answer

ER Diagram:
Database Used: Microsoft Sql Server
DB Scripts:
script.sql
USE [master]
GO
/****** Object:  Database [db_9ab8b7_122dda7618]    Script Date: 4/5/2022 2:27:43 PM ******/
CREATE DATABASE [db_9ab8b7_122dda7618]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'db_9ab8b7_122dda7618_Data', FILENAME = N'H:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\db_9ab8b7_122dda7618_DATA.mdf' , SIZE = 8192KB , MAXSIZE = 307200KB , FILEGROWTH = 10%)
 LOG ON 
( NAME = N'db_9ab8b7_122dda7618_Log', FILENAME = N'H:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\db_9ab8b7_122dda7618_Log.LDF' , SIZE = 3072KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
 WITH CATALOG_COLLATION = DATABASE_DEFAULT
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET COMPATIBILITY_LEVEL = 150
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [db_9ab8b7_122dda7618].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET ARITHABORT OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET  ENABLE_BROKER 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET  MULTI_USER 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET DB_CHAINING OFF 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [db_9ab8b7_122dda7618] SET QUERY_STORE = OFF
GO
USE [db_9ab8b7_122dda7618]
GO
/****** Object:  Table [dbo].[Beliefs]    Script Date: 4/5/2022 2:27:46 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Beliefs](
	[Belief_ID] [int] IDENTITY(1,1) NOT NULL,
	[BeliefName] [nvarchar](50) NULL,
 CONSTRAINT [PK_Beliefs] PRIMARY KEY CLUSTERED 
(
	[Belief_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Clothings]    Script Date: 4/5/2022 2:27:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Clothings](
	[Clothing_Id] [int] IDENTITY(1,1) NOT NULL,
	[ClothingName] [nvarchar](50) NULL,
 CONSTRAINT [PK_Clothings] PRIMARY KEY CLUSTERED 
(
	[Clothing_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DistrictArea]    Script Date: 4/5/2022 2:27:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DistrictArea](
	[Area_Id] [int] IDENTITY(1,1) NOT NULL,
	[AreaName] [nvarchar](50) NULL,
 CONSTRAINT [PK_DistrictArea] PRIMARY KEY CLUSTERED 
(
	[Area_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[EconomicalActivities]    Script Date: 4/5/2022 2:27:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EconomicalActivities](
	[EconimicalActivity_ID] [int] IDENTITY(1,1) NOT NULL,
	[EconomicalActivityName] [nvarchar](50) NULL,
 CONSTRAINT [PK_EconomicalActivities] PRIMARY KEY CLUSTERED 
(
	[EconimicalActivity_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[HumanAgeByClothing]    Script Date: 4/5/2022 2:27:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HumanAgeByClothing](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[HumanAge_ID] [int] NULL,
	[Clothing_ID] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[HumanAgeByDistrictArea]    Script Date: 4/5/2022 2:27:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HumanAgeByDistrictArea](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[HumanAge_ID] [int] NULL,
	[DistrictArea_ID] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[HumanAgeByEconomicalActivity]    Script Date: 4/5/2022 2:27:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HumanAgeByEconomicalActivity](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[HumanAge_ID] [int] NULL,
	[EconimicalActivity_ID] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[HumanAgeByLiving]    Script Date: 4/5/2022 2:27:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HumanAgeByLiving](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[HumanAge_ID] [int] NULL,
	[LivingWay_ID] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[HumanAgeByStaying]    Script Date: 4/5/2022 2:27:47 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].

Your database should allow records to be entered and amended by teachers efficiently. The output should be in a format that is easy to understand by pupils. Both teachers and pupils should be able...

Answer To: Your database should allow records to be entered and amended by teachers efficiently. The output...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment