Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ASSIGNMENT QUESTION PURPOSE This asssigment is intended to enhance learners' knowledge on the basic implementation of storing and manipulating data by using a relational database
ASSIGNMENT QUESTION PURPOSE This asssigment is intended to enhance learners' knowledge on the basic implementation of storing and manipulating data by using a relational database management system. SCENARIO Assume that you have been running a car workshop for over two years with sizeable amount of customers and some staff (admin and mechanics) to manage your workshop. At present, all the data is stored in a manual way involving considerable amount of physical files. In order to cope with data which is increasing day by day, you have decided to choose computer based approach over manual approach by adopting relational database management system approaches. Tasks: By using MS Access (QBE or SQL or BOTH), perform the following: Part 1: a) Based on the scenario, provide meaningful name for the database file, create the possible tables (3-5 tables) and their relevant data items (3-4 data items) with appropriate data types, which are required for the above company. b) Create a suitable forms for each table and enter at least 5 records and make sure the records fulfil the queries provided in Part 2. c) Then, identify appropriate primary key (s) and foreign key (s) and relate all the identified table. Show their relationships with suitable cardinalities. Part 2: Produce any 5 queries, based on requirements stated as below. You may refer to the sample provided: a) List All field names in any ONE (1) of the tables. ASSIGNMENT QUESTION PURPOSE This asssigment is intended to enhance learners' knowledge on the basic implementation of storing and manipulating data by using a relational database management system. SCENARIO Assume that you have been running a car workshop for over two years with sizeable amount of customers and some staff (admin and mechanics) to manage your workshop. At present, all the data is stored in a manual way involving considerable amount of physical files. In order to cope with data which is increasing day by day, you have decided to choose computer based approach over manual approach by adopting relational database management system approaches. Tasks: By using MS Access (QBE or SQL or BOTH), perform the following: Part 1: a) Based on the scenario, provide meaningful name for the database file, create the possible tables (3-5 tables) and their relevant data items (3-4 data items) with appropriate data types, which are required for the above company. b) Create a suitable forms for each table and enter at least 5 records and make sure the records fulfil the queries provided in Part 2. c) Then, identify appropriate primary key (s) and foreign key (s) and relate all the identified table. Show their relationships with suitable cardinalities. Part 2: Produce any 5 queries, based on requirements stated as below. You may refer to the sample provided: a) List All field names in any ONE (1) of the tables
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started