Creating a new database : The below are the steps followed to create a new database: Click “File->New” and then choose the option “Blank desktop database”. Provide the name of the database and click “Create”. In the menu bar, click on the “create” menu and then click on “Table”. “Table1” will be created, right click on it and choose “design view”. A “Save As” dialog box appears. Type the name of the table and click “OK”. Specify the required field name and data type.

Question

Want to see the full answer?

Answer 1

Question

Chapter 5, Problem 9CE

Program Plan Intro

Creating a new database:

The below are the steps followed to create a new database:

Click “File->New” and then choose the option “Blank desktop database”.

Provide the name of the database and click “Create”.

In the menu bar, click on the “create” menu and then click on “Table”.

“Table1” will be created, right click on it and choose “design view”.

A “Save As” dialog box appears. Type the name of the table and click “OK”.

Specify the required field name and data type.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

You are asked to design a database for an University. This particular university has multiple departments. Each department in that university offers one or more courses to the students. All the students are part of a certain department and they take courses in that department. A department has a name, unique number and chairman. The courses have a name, a course number such as ‘311’ , a credit point value, and the year it commenced. A course cannot be identified uniquely with the course number, but the course number is unique for each department. Students have given names, surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a course the year and the semester he or she took that particular course is recorded. When he finishes the course , the grade and total marks are recorded. A student can take multiple courses but they are also allowed to drop a semester in that university by taking no courses. Construct an ER diagram using the requirements…

You are to design a Hospital database. So before creating the database, your task is to draw the ER diagram based on the following data collected and analyzed: A hospital will have a name, unique id, multiple helpline numbers (one for doctor's appointment, one for ambulance, one for bill information and one for other services' info) and locations. A hospital may have more than one location as it may have different branches and each of the locations will have a building no., street address, road no. and city name. A patient will have a name, unique ID, may have more than one phone number, age, height, weight and symptoms. A patient takes an appointment in a hospital and the appointment date is recorded. A patient may have an attendant. An attendant will have his/her name, contact numbers and relationship with the patient as a record in the database. Due to the covid situation, the hospital authorities will only allow 1 attendant with 1 patient.

Design the database in an MS Excel spreadsheet as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own: Title: Star Trek Year: 2009 Genre: Sci-Fi Rating: PG Format: DVD Director: J. J. Abrams Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy) What normal form is this design? Why? What should be done to correct the design?